Sunday, May 23, 2021

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.


Friday, May 14, 2021

This Saturday: #DataWeekender, DataSaturday Southwest

Geeked to be speaking 2x on Saturday May 14, my second time speaking at #DataWeekender and at the very first Data Saturday Southwest 2021.

My Certification Exams Inside Out is one of my favorite presentations to give. Its fun, its positive and career-oriented, it's useful for folks at any point in their career. Between my guided walkthrough based on actual experience and fun sample test questions, I hope help you understand both how a question gets written, and how best to go about answering.

Slides for my presentations are available for download on Github: #DataWeekender and Data Saturday Southwest 2021.






Monday, May 03, 2021

"Ethics in Modern Data" at Minnesota Developers Conference 2021

Looking forward to speaking to a brand new conference for us, the Minnesota Developers Conference 2021 on May 4 at 2pmCT. Christine and I will be presenting a talk that we're both passionate about. We bring both our career focuses to the topic of modern data analytics, construct analysis, historical and current bias, and modern machine learning algorithms. We'll talk about ethics of bias in data both historical and issues ripped from the headlines. 

See you at 2pmCT virtually from Minnesota!

Our slidedeck for the presentation is available here.