Group Announcements


September 2022 | Facilitating User-Centered Dashboard Ideation Sessions | Thelma Van

posted Aug 16, 2022, 4:07 PM by Kenneth Neal

RSVP on Meetup

Details
Location: Louisiana Tech Park

Agenda:
• 5:00 - 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

Take the guess work out of what your users need from a dashboard. These guided workshops simplify the requirement process and incorporate the needs of not only the end-user, but the entire team.

Presenters: Thelma Van

Thelma Van is a user experience strategist, product designer, and UX leader. She currently serves as a UX design innovation expert for Excella. Thelma has served as product director for elections and campaign systems, designed experiences for aviation and nuclear chemistry management, and more recently began applying human-centered design to machine learning. For the past decade, she has used logic and creativity to make complex systems easy to use and understand.

Thelma has a passion for helping others achieve their career goals. Through mentorship, she provides growth opportunities for designers at all levels. In her last role as Director of Product, she implemented a six-month internship program for aspiring UX designers and product managers. Partnering with local non-profits, Thelma conducts human-centered design workshops with the premise of believing that HCD principles can help reshape how we define problems and find solutions in multiple areas of life.

June 2022 | Azure Synapse Analytics Into | Steve Carella

posted Jun 14, 2022, 8:01 AM by Kenneth Neal

RSVP on Meetup

Details
Location: Louisiana Tech Park

Agenda:
• 5:00 - 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

Azure Synapse Analytics Into
Steve will be giving an overview of Azure Synapse Analytics and a demonstration of a very basic data lake / data warehouse implementation using Synapse

Steve Cardella
Steve Cardella has been a Business Intelligence consultant for over 8 years and is starting to lose count. He has specialized in the Microsoft data and analytics space with ongoing flirtations with open source technologies. 
He has seen BI transition from the on premises SQL Server stack to the present cloud-first modern data platforms. He has architected and implemented both on-prem and Azure-based data warehouses and data lakes and is one of the primary developers of BlueGranite's ETL framework.

May 2022 | Death to YAML: Building a Better Pipeline ​| Austin Webre

posted May 2, 2022, 5:12 PM by Kenneth Neal   [ updated May 2, 2022, 5:17 PM ]

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

posted Apr 1, 2022, 3:56 PM by Kenneth Neal


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.
  • What is Azure Key Vault - We'll briefly review what Microsoft Azure is from a very high level before diving into Key Vault 
  • Use cases - when should Key Vault be used and how should key vault be used in different environments (prod vs dev/test)
  • Requirements - Can legacy applications use Key Vault? What .net libraries are required? We'll also review authorization vs authentication, and firewall/network security requirements
  • Basic implementation - We see step by step how to put it in motion

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

Check out our YouTube channel.

Join our discord community.

March 2022, !!!IN-PERSON!!! | Using Execution Plans to Performance Tune SQL Server | Thomas Leblanc

posted Mar 8, 2022, 4:29 AM by Kenneth Neal



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

Check out our YouTube channel.

Join our discord community.

June 2021 | Git for DBAs with Justin Dearing

posted Jun 1, 2021, 2:10 PM by Kenneth Neal

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.

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

1-10 of 132