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.
I like to use the keyboard whenever I can in SQL Server Management Studio. It’s not always easy to remember every shortcut though– especially when those shortcuts change!
Since around the SQL Server 2012 era, you’ve been able to switch Intellisense on or off on SSMS with the shortcut chord: CTRL + Q, CTRL + I. I remembered this as “Control Quacky Intellisense.”
A user recently asked me what a good use case might be to run SQL Server on Linux in a Docker container.
One cool little feature in SQL Server 2016 is COMPRESS(). It’s a TSQL function available in all editions that shrinks down data using the GZIP algorithm (documentation).
It can be tricky to remember that SQL Server doesn’t short circuit on IF statements in stored procedures. Even when you know this, sometimes it’s hard to recognize the impacts.
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.