SQL Server Admin Best Practices with DMVs at GroupBy Americas 2021

On Tuesday I'm looking forward to presenting again at GroupBy Americas on a topic that was voted on by the attending public. This presentation "SQL Server Admin Best Practices with DMVs" is a talk that I've been giving for more than a decade and been tweaking and tuning ever since. 

This talk covers basic roll-your-own maintenance strategies using data inside SQL Server including wait stats, query stats and the Query Store, fragmentation and index maint, index DMVs for new/existing indexes, and a ton more helpful DMVs introduced in SQL 2017 and 2019. 

You can register for this talk here: groupby.org.

You can download my presentation here, and the toolbox of sample scripts referenced throughout can be found in here.

#GroupBy Americas: #DBA Track starts soon!
Here's our lineup of speakers:@gfritchey@hellosqlkitty@solarwinds with @SQLBek and Devon Wilson@PureStorage with @DBArgenis@Aschenbrenner@william_a_dba@Dallas_DBAs with Jeff Moden@dbanuggets

Register: https://t.co/1ss3ldVAwQ pic.twitter.com/3LjrMDzDye

— GroupBy (@GroupByConf) May 25, 2021

GroupBy: SQL Server Admin Best Practices with DMV's

Thanks for the 40+ of you online for GroupBy 2019 North America, excited to have presented my DMV session for the audience.

Big shoutout to Bob Pusateri's fantastic preceding presentation, which I hadn't seen before, on Locks, Blocks, and Snapshots, that was masterful explanation of the concepts. Thanks also Jeremy Alexander for being GroupBy's v-jay/video moderator/streaming host for entertaining!

Slidedeck: https://github.com/williamadba/Public-Presentations/blob/master/GroupBy%20Conference%202019/DBA%20Best%20Practices%20with%20DMVs.pptx

Toolbox: https://github.com/sparkhoundsql/sql-server-toolbox

SQL Server Admin Best Practices with DMV's at GroupBy

Excited to be presenting at virtual GroupBy Conference for the first time on Thursday, during the North America time slots. I just finished tuning up this old presentation that I've presented dozens of times. It's been a great learning tool for me throughout my career and informative for DBA's and Developers at any level of experience. This time I packed in some new SQL Server 2019 content as well, so I'm looking forward to demoing both my old classic hand-tooled jokes as well as fresh new content.

In all this time though, this is the first I'll be presenting this slidedeck to a virtual audience, so be sure to use the chat window to give me a lol or a groan every now and then. I've already made the slide

deck available here and I'll be ready to roll on Thursday at 1pm Central.

Later Thursday afternoon, I'll be presenting a second webinar, Think Like a Certification Exam, in the PASS Career Development Marathon. Hope to see you online there as well!

You can register for this free all-online conference here. Here's the GroupBy conference lineup:

Europe - October 9th   9:00 UTC | Alexander Arvidsson Boring Is Stable, Stable Is Good. SQL Server Best Practices 10:00 UTC | Magnus Ahlkvist  Eight hours of work in 20 minutes, partitioning rocks 12:00 UTC | Emanuele Meazzo How to use PowerBI as a free monitoring tool (5 free reports for SQL Server) 13:00 UTC | Alex Yates  Solving the dev database problem with GitHub, Docker and PsDatabaseClone 14:00 UTC | Rich Benner  Adventure – Performance Edition

Download Invite

North America - October 10th   9:00 PDT | Aaron Nelson  Azure Data Studio  SQL People 10:00 PDT | Bob Pusateri Locks, Blocks, and Snapshots: Maximizing Database Concurrency 11:00 PDT | William Assaf  SQL Admin Best Practices with DMVs 13:00 PDT | Collin Lysford  Demystifying Dynamic SQL 14:00 PDT | Erik Darling  The SQL Server Performance Tasting Menu 15:00 PDT | Mohammad Darab Big Data Clusters for the Absolute Beginner

Download Invite