Group Announcements
May 2022 | Death to YAML: Building a Better Pipeline | Austin Webre
RSVP on Meetup Details Location: Louisiana Tech Park Agenda: • 5:15 - 5:30: Introduction/Food and Drinks (Note our earlier start time!!) • 5:30 - 7:15: Presentations • 7:30 - Until: Open forum for questions Sponsor: TBD Presentations: Death to YAML: Building a Better Pipeline Developers everywhere seem to dislike working with YAML, even though it's become the "industry standard" for building out CI/CD Pipelines "in code". In this talk, we discuss how we got here, what makes YAML so painful, and how we can use the tools we already know and love to make a better pipeline-building experience. Austin Webre Austin is a Full Stack .NET Developer with 5 years of experience in Software Consulting. When I'm not writing .NET/React code for clients, you'll often find me empowering my fellow developers by automating builds, deployments, and all things infrastructure. In my free time, I co-host a Software Development podcast called Use Case. |
April 2022 | Implementing Microsoft Azure Key Vault | Laird Wilson
We'll build a basic .net web app in Microsoft Azure, create a Key Vault, add key vault secrets, and then build logic to retrieve and display those secrets. We'll further discuss best practices using Key Vault and how it potentially impacts CI/CD pipelines.
Presenters: Laird Wilson is a graduate of Louisiana State University where he majored in ISDS. His career began in Network Engineering focusing on Cisco network/switch and Microsoft Server administration. He discovered his passion in developing new solutions using C# and SQL while earning his master's degree at Champlain College of Vermont. He put his passion in motion at Community Coffee, Blue Cross Blue Shield of LA, LSU, Continuum Inc., and most recently at Kuvare where he works as a Solutions Architect. Laird has more than a decade of experience working in .net software and database development, and holds certifications in Microsoft Azure, ITIL, and CompTIA. He also loves going to Disneyworld and the beach with his family, and hopes his brother-in-law will buy a boat to take him fishing. In short he's a nerd and professional geek. May God have mercy on his soul. Our sponsor for this meeting is TBD |
March 2022, !!!IN-PERSON!!! | Using Execution Plans to Performance Tune SQL Server | Thomas Leblanc
This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window? We might even look at the Query Store. Presenters: Thomas LeBlanc is a Data Warehouse and Business Intelligence Architect in Baton Rouge, LA and uses his decades of experience in IT to help develop OLAP database for end-to-end dimensional data marts with SSIS, SSAS, Power BI, and Excel. He also assists with OLTP systems designing and tuning normalized databases for high-performing T-SQL. Our sponsor for this meeting is TekChix Staffing |
June 2021 | Git for DBAs with Justin Dearing
Join us on Wednesday, June 16, 2021, at 5:30 PM CDT for another virtual BRSSUG meeting! In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. Microsoft has fully embraced Git. It powers modern on premise and cloud versions of TFS (now know as Azure Devops) as well GitHub, which Microsoft recently acquired. What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in version control. In my session. We'll cover: How do I use SSDT to help prevent developers from using code first ORMs? What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? We will be covering using git from both the command line and Visual Studio. Check out our YouTube channel. Join our discord community. Discord: https://discord.gg/JDp5YS |
March 2021 | Become a Contributor to SQL Docs
Join us on Wednesday, March 10, 2021, at 5:30 PM CST for another virtual BRSSUG meeting! ---- Become a Contributor to SQL Docs Presenter: Microsoft Docs Team (TBD) Check out our YouTube channel Join our Discord community |
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. |