Group Announcements
Nov 2020 | SQL Engine: Its Working Style
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 Join our Discord community |
Oct 2020 BTR .NET/SQL UG "Campfire Stories"
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! Links:
|
September 2020 ONLINE User Group Meeting!
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
|
March 2020 BRSSUG Meeting
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
When: Wednesday, 02/12/2020 Agenda: 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
When: Wednesday, 01/08/2020 Agenda: Location: Louisiana Technology Park- location 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, |
| Attachments:
ATourThroughAzureSQLDB_2020-BRSSUG.pdf
December 2019 December Social
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! 4215 South Sherwood Forest Boulevard · Baton Rouge How to find us Upstairs at the Londoner on Sherwood |
November 2019 BRSSUG Meeting
|
October 2019 BRSSUG Meeting
|
September 2019 SQL Server User Group meeting
|
| Attachments:
SQL Security Principals and Permissions 101.pptx
1-10 of 125