GroupBy – Free SQL Server Training Podcast
1) Using Open Source Products to Collect Performance Metrics by Tracy Boggiano
Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If on...Show More
Using Open Source Products to Collect Performance Metrics by Tracy Boggiano
56:55 | Feb 12th, 2019
2) Columnstore Indexes: What are waiting for? by Niko Neugebauer
Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are whole execution plans behind those Index Scans ? Did you ever ask yourself, what are those ...Show More
3) The Problems With Optional Operators by Erik Darling and Joe Obbish
The optimizer has options. Not every option is optimal. Optimistic query tuners hope that the optimizer will make optimal choices. Often, the optimizer will stick an optional operator in a plan that j...Show More
4) How to get your dream job: Resume & job hunting tips by Andy Mallon
What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream. In this session, we'll talk about how I got where I am, and how you can ge...Show More
5) What ‘Digital Transformation’ Means, and How You Can Use It to Advance Your Career by Kendra Little
Whether you love or hate buzzwords, the big ones signify critical cultural changes. In this session, Kendra Little will explain what executives mean when they describe a 'digital transformation', why ...Show More
6) New Engine Features in SQL Server 2019 by Aaron Bertrand
A new release of SQL Server is like a new season of your favorite TV show. Some releases in the past were lacking; I always felt like SQL Server 2008 R2 was about as exciting as the Seinfeld finale. B...Show More
7) An Introduction to Partitioning by DBAfromthecold
This mainly demo-based session will cover the following: An introduction to partitioning, core concepts, and benefits. Choosing a Partitioning Key Creating Partition Functions & Schemes Indexing Cons...Show More
8) Make Your Own SQL Server Queries Go Faster by John Sterrett
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stumbled into my career in performance tuning. In this session...Show More
9) T-SQL Tools: Simplicity for Synchronizing Changes by Martin Perez
One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems. In this session we will look into different methods focusi...Show More
10) Be My Azure DBA (DSA) by Paul Andrew
There seems to be a common misconception that once you move from on premises SQL Server to Azure PaaS offerings a DBA is no longer required. This perception is wrong and in the session I’ll show you w...Show More