Group Announcements


March 2021 | Become a Contributor to SQL Docs

posted Feb 25, 2021, 5:07 PM by Kenneth Neal

Join us on Wednesday, March 10, 2021, at 5:30 PM CST for another virtual BRSSUG meeting! 


----
Become a Contributor to SQL Docs

Microsoft Docs are open source on Github! Join the SQL-Docs content team for a discussion on modern Microsoft documentation (regardless of technology). Learn about the content publishing engines behind Docs, and the best ways to add your content and fixes to Docs that are read by the entire customer community. There are hundreds of thousands of GitHub issues and PR’s submitted to Docs every month, how can you be an effective part of that process and get your face on the top of an article?

Presenter: Microsoft Docs Team (TBD)

Check out our YouTube channel

Nov 2020 | SQL Engine: Its Working Style

posted Nov 8, 2020, 4:23 PM by Bedford Nieves-Sanchez   [ updated Nov 8, 2020, 4:26 PM ]

Join us on Wednesday, November 18, 2020 at 5:30 PM CST for another virtual BRSSUG meeting! In this meeting Deepthi Goguri will pull the curtain back on the SQL engine and show you how it thinks.

Link to the Meetup Event
Link to the YouTube Livestream

---

SQL Engine: Its Working Style

Many DBAs and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Cache in SQL Server, Relational Engine, Storage engine and the Transaction manager. You will learn how SQL Server manages Plan cache and Buffer pool and how SQL Server optimizer chooses the plans. We will also cover what happens under the covers during read and write operations within SQL Server. This session also has Demos showing how components of SQL Engine works for queries.

Deepthi will show you how the SQL engine thinks – enabling you to think like it!

Deepthi is a Database Administrator with 7 years of experience. She completed her Masters in Computer Technology at Eastern Illinois University and she is a Microsoft certified solution expert (MCSE). You can find her blog at dbanuggets.com and follow her on twitter: @dbanuggets

---

Check out our YouTube channel

Oct 2020 BTR .NET/SQL UG "Campfire Stories"

posted Oct 11, 2020, 1:55 PM by Bedford Nieves-Sanchez   [ updated Oct 11, 2020, 1:56 PM ]

For our October 14 2020 online meeting, we're having another themed short-format speaker night! Should be fun and seasonal! October's theme is SCARY or SPOOKY or WEIRD or STRANGE things you've seen in your technology. It can be a short-format presentation on weird behavior in tech, anti-patterns, horror stories, tech disasters, hard lessons learned, unsolved mysteries, whatever you want!

September 2020 ONLINE User Group Meeting!

posted Aug 25, 2020, 10:44 AM by william assaf   [ updated Sep 9, 2020, 2:53 PM ]

We're back online! We'll be streaming on Youtube!

When: Wednesday, 9/9/2020

Agenda:

• 5:30 - 5:45: Introduction

• 5:45 - 7:00: Presentations

• 7:00 - Until: Open forum for questions

Location: Speakers join via Teams, Attendees join via Youtube or Discord

Short Format Speakers

  1. William Assaf - New Azure Certifications for DBA's, Devs, Analysts
  2. Justin Obney - API Driven TypeScript CodeGen and whatnot
  3. Ryan Richard - Running PWA's in Stand-Alone Mode on Mobile Devices
  4. Anandi Subramanian- Data Analysis - Finding that needle in the haystack
  5. Andy Parkerson - Azure Functions and plugging holes in Azure Data Factory

March 2020 BRSSUG Meeting

posted Mar 2, 2020, 7:59 AM by Baton Rouge User Groups

When: Wednesday, 03/11/2020

Agenda:

• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!

• 5:45 - 7:30: Presentations

• 7:30 - Until: Open forum for questions

Location: Louisiana Technology Park- location info here

 

Our sponsor is Emergent Method - https://emergentmethod.com/

Emergent Method is a Louisiana-based management consulting firm focused on helping companies and organizations innovate, grow, improve their performance, and achieve their missions.

 

Main Presentation: Plan Stability through Plan Forcing with Query Store

Speaker: Erin Stellato

Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

February 2020 BRSSUG Meeting

posted Jan 31, 2020, 2:31 PM by Baton Rouge User Groups   [ updated Mar 2, 2020, 7:11 AM by william assaf ]

When: Wednesday, 02/12/2020

Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!
• 5:45 - 7:30: Presentations
• 7:30 - Until: Open forum for questions

Location: Louisiana Technology Park- location info here

 

Our sponsor for this meeting is HEADSPRING - https://headspring.com/

 

Main Presentation: Crud, Another ETL Solution: Azure Data Factory

Speaker: Brandon Brockhoeft

Summary: Spending too much time building and maintaining your data analytics and data warehousing applications, but don’t want to invest in a pricey commercial solution with licensing entanglements? Azure Data Factory is an alternative to writing something completely custom that plugs into lots of services and can be tailored where needed. In this talk, you’ll learn how and why to leverage Azure Data Factory as the stepping stone for your organization’s ETL, ELT, and big data solutions. We’ll explore the distinguishing data and compute platforms that you’ll be able to use along with developer features like git source control and continuous delivery. You’ll even get to see a sample pipeline built in .NET and the Azure UI Designer that works with open data sources.

Bio: Brandon Brockhoeft is a career software engineer working primarily with Microsoft solutions with over 15 years of professional experience. He is an LSU alumnus and native of the Baton Rouge area. Brandon is employed as a Principal Consultant for Austin-based Headspring custom software consultancy. He has provided development and architecture technology solutions in the finance, state government, energy, and aerospace industries. Brandon’s functional expertise includes full-stack development, distributed architecture, real-time communication, DevOps and agile transformation, & mentoring.

January 2020 BRSSUG Meeting

posted Jan 2, 2020, 6:25 AM by Baton Rouge User Groups   [ updated Jan 14, 2020, 11:44 AM by william assaf ]

When: Wednesday, 01/08/2020

Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!
• 5:45 - 7:30: Presentations
• 7:30 - Until: Open forum for questions

Location: Louisiana Technology Parklocation info here


Sponsor - Our sponsor for this meeting is ANTARES - https://www.antaresnet.com/


Main Presentation: Azure SQL Database for the Production DBA

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!


Main Speaker:  Tim Radney, SQLSKILLS

Tim Radney is a SQL Server MVP. He has presented at PASS,
SQLintersection, SQL Saturdays, user groups and numerous
webinars. In addition Tim runs the Columbus GA SQL Users Group,
is a PASS Regional Mentor and was named a PASS Outstanding
Volunteer in 2012. He’s married with three children and has a
passion for electronics. He also farms chickens (for eggs), dwarf
Nigerian goats, and tilapias in his spare time.

December 2019 December Social

posted Dec 4, 2019, 10:15 AM by John Wells

It's December, so instead of our usual meeting we will be hosting a social at the Smiling Dog, the bar above the Londoner on Sherwood Forest Blvd. Just a time to get together, relax, and chat with some friends before the holidays.

We'll also be celebrating the season by encouraging all attendees to wear an ugly sweater!

Wednesday, December 11, 2019

6:00 PM
 to 8:00 PM 

4215 South Sherwood Forest Boulevard · Baton Rouge

How to find us

Upstairs at the Londoner on Sherwood



November 2019 BRSSUG Meeting

posted Nov 3, 2019, 8:05 PM by Baton Rouge User Groups   [ updated Nov 8, 2019, 8:43 AM by william assaf ]


posted Oct 9, 2019, 5:15 PM by william assaf

When: Wednesday, 11/13/2019

Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!
• 5:45 - 7:30: Presentations
• 7:30 - Until: Open forum for questions

Location: Louisiana Technology Parklocation info here


Sponsor: Quest 


Main Presentation: What's New In SQLServer 2019


Main Speaker:  William Assaf, Sparkhound

William Assaf, MCSE, is a principal consultant and DBA Manager in Baton Rouge, LA.
Initially a .NET developer, and later into database administration and architecture,
William currently works with clients on SQL Server and Azure SQL platform optimization,
management, disaster recovery and high availability, and manages a crack multi-city
team of SQL DBA's at Sparkhound. William has written for Microsoft SQL Certification
exams since 2011 and was the lead author of "SQL Server 2017 Administration Inside Out"
by Microsoft Press, its second edition due out in 2019. William is a member of the
Baton Rouge User Groups Board, a regional mentor for PASS, and head of the annual
SQLSaturday Baton Rouge Planning Committee.

October 2019 BRSSUG Meeting

posted Oct 9, 2019, 3:15 PM by william assaf

When: Wednesday, 10/9/2019

Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!
• 5:45 - 7:30: Presentations
• 7:30 - Until: Open forum for questions

Location: Louisiana Technology Parklocation info here


Main Presentation: How to index, win friends, and influence people.

In this session, we'll discuss performance benefits of indexes and compare index types. If you're new to indexes in SQL Server or just in need of a refresher, this session should help.


Main Speaker:  Jonathan Jefferson, BCBS

Jonathan Jefferson is a SQL enthusiast and amateur DBA on occasion. I'm currently working to remove the amateur part.

1-10 of 126