Thursday, June 24, 2021

Speaking at Data ANZ 2021

Looking forward to speaking at Data ANZ 2021 this weekend. Data ANZ "is the data community event for the whole of Australia and New Zealand (and the world)"! 

I'll be presenting both my "How to Think Like a Certification Exam" and co-presenting "Ethics in Modern Data" along with Christine. Their schedule is published here

Both slidedecks are available for download here on Github.

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.