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? Wha...
Radio and PodcastLive Radio & PodcastsTechnology
GroupBy – Free SQL Server Training
GroupBy.org is free technical training by the community, for the community. Volunteer speakers submit abstracts at GroupBy.org and you – the attendee – vote to pick the sessions. Want to pre...
Episodes
20 of 74 episodesColumnstore 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 th...
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, th...
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 sessio...
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 executi...
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 Se...
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 Partitioni...
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 stu...
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. I...
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....
The Perfect Index by Arthur Daniels
Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It's not easy to form indexes for a large and...
Not just polish – How good code also runs faster by Daniel Hutmacher
I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvemen...
The Agile DBA: A Guide to Database DevOps with SSDT by Ryan Booz
As the DBA for an Agile, Sprint-based team, you may feel like the bottleneck at every turn. You've stuck with the existing processes and too...
Getting Better Query Plans by Improving SQL's Estimates by Brent Ozar
You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and using OPTION (RE...
Advanced Query Tuning Techniques by Guy Glantser
You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execu...
How to Monitor Everything by Maria Zakourdaev
Today's applications are not using monolithic approach anymore and evolving into micro-services architecture. Monitoring tools are also evol...
Columnstore Clustered vs Nonclustered, When to Choose What by Niko Neugebauer
The incredible Columnstore Indexes can increase your analytical query processing speed multiple times, they are updatable (Clustered from SQ...
SQL Server Containers and Clones by Paul Stanton
Microsoft emphasizes use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support...
SQL Server 2017 Community Driven Enhancements by Javier Villegas
Will cover all new SQL 2017 features that the Data Platform Community has requested and Microsoft has included in the next major version of...
Architecting Availability Groups by Derik Hammer
This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over c...