I’m very that my session on table partitioning from the 2017 SQL PASS Summit is being featured as one of the “Best of Summit” videos.
I had a terrific time presenting this session, thanks to everyone in the audience: you were awesome!
You can watch the video here, and follow the link above to see even more great videos from the conference for free.
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why I’m excited about those features rather than afraid of them.
Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.
I had a great time this week talking about isolation levels with Hekaton – aka In-Memory OLTP – aka Memory Optimized tables. Here’s a video of the recorded webcast.
One of the great things about writing presentations is that it spurs you to “clean up” your definitions. When it comes to writing a slide about something, I ask myself, “Do I really know what that is?” I check my assumptions, and clarify how I think about something.
This week I was working with SQL Server memory settings, and I “cleaned up” my understanding of the following definitions.
I received a question recently asking about disk access patterns for index seeks in SQL Server. The question suggested that index seeks would have a random read pattern.
Is this necessarily the case?
Webcasts are held on Thursdays at 9 AM Pacific / noon Eastern / 4 pm UTC.
Here’s the upcoming slate of topics:
I can’t wait to put together these presentations, and I hope to see you on Thursdays!
Last week, I had a great time giving a webcast for the terrific DBA Fundamentals Virtual Chapter. If you like free online training, check them out and sign up for future events.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.