Whenever we have multiple sessions modifying data, things get tricky. When we have a pattern of “check if the data exists and then do a thing,” multiple sessions get even more complicated.
In this episode of “Dear SQL DBA,” I answer a question about early adoption of SQL Server, discuss why testing in production isn’t necessarily crazy, and recommend how to handle requests to upgrade your SQL Server to use new features.
I’ve gotten a few compliments lately on the images I’ve been using in my posts. Images help engage your readers. You should also set a “featured image” for each post for thumbnail usage in your theme or in RSS readers. But it can be kind of a pain to search for images and make sure the image copyright allows you to use and share it.
I’m about four months into my planned six month sabbatical.
At the beginning, I worried a little that I might not like life as a grownup without a job. Would I feel lost? Purposeless? Bored?
Nope. It turns out that I am excellent at not having a real job. I’ve learned a bunch, enjoyed life, seen a bit of the world, gotten healthier, and created some teaching materials that I’m super proud of.
If you’re a database administrator, a developer, or just someone who plays one on TV, I know you’ve got questions. Technical questions. Political questions. Questions about how to handle your coworker with stinky feet who wears flip flops to work. (Been there!)
Now you’ve got a way to get answers. Submit your question to Dear DBA.
Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in. Or maybe the indexes aren’t checked into source control, and you’re working on fixing that. (Important!)
Either way, sometimes you need to do it, and it’s not fun through the GUI. I needed to write some fresh demo code for this recently, and I needed it to give the details for partitioned tables using data compression, and I thought I’d share.
Microsoft recently updated their policies and recommendations for installing cumulative updates.
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.