Turning Off In-Memory OLTP
Decisions can be hard. There are negligible decisions like paper or plastic but also dicey decisions like figuring out what your wife really wants for dinner when she asks you to decide. To try speeding up the decision-making process, Amazon has followed the decision framework around two-way doors and one-way doors. The idea is that…
The Gell-Mann Amnesia Effect and AI
If you’re someone who was in school during the 2000s, you may remember arguing with your teachers or professors about using Wikipedia as a source on your homework. It used to be Wikipedia that wasn’t to be trusted because it could be updated by anyone at any time. It could never be relied on as…
T-SQL Tuesday #200 – Signs of a Bad Query
It’s T-SQL Tuesday 200! To celebrate this bicentennial, Brent Ozar invites us to say to ourselves, “When I’m looking at a query, I bet it’s bad if I see ____.” and fill in the blank. To read the full invite, along with a bit of history about how T-SQL Tuesday began and evolved, click the…
SQL Formatting in SSMS 22.7
Code formatting can be a touchy subject. Sometimes there are clear rules to designate right and wrong, and sometimes there’s not. Tabs versus spaces, anyone? Surprisingly, SQL Server Management Studio has never had a built-in SQL formatter. Users were always left to use third-party tools or format by hand. But with the latest SSMS 22.7,…
T-SQL Tuesday #199 – Moving Back From the Cloud
This month’s T-SQL Tuesday invite comes from Koen Verbeeck, who asks us to think about what it would look like to move back to on-premises infrastructure after years in the cloud. Do we still have the skills to go back to on-premises? What types of on-premises issues would be the most frustrating? Click the T-SQL…
Impact of Automatic Index Compaction
Index work has almost always been a core task for database administrators. If indexes aren’t performing well, then your queries probably aren’t performing well. And if your queries aren’t performing well, you aren’t performing well, because users will be complaining. There isn’t one set way to manage indexes. Maybe you use Ola Hallengren scripts. Maybe…
Your Next Database Prank
An interesting discovery was made as it relates to OpenAI Codex and its system prompt. From this article: The system prompt for OpenAI’s Codex CLI contains a perplexing and repeated warning for the most recent GPT model to “never talk about goblins, gremlins, raccoons, trolls, ogres, pigeons, or other animals or creatures unless it is…
Bulk Loading Data with mssql-python
I’ve had some projects in the past that involved using Python to load data in SQL Server. It wasn’t unbearably slow, but it seemed like a process that could be faster. For that reason, a recent SQL Server blog post about bulk loading data with Python caught my eye. I decided to test out the…
RegEx Arrives in SQL Server 2025
It’s been far too long since I did a blog post with some code examples, so let’s break that cold streak. Let’s talk about RegEx finally making its way to SQL Server 2025. RegEx provides a way to perform more advanced pattern matching with queries, and most would argue it was an overdue feature in…
Keeping AI Queries Under Control
Note: This post was an April Fool’s Day joke and is not to be taken seriously! AI usage isn’t slowing down, and it continues to consume more and more electricity. Microsoft has recognized this and is acknowledging its own contributions thanks to the increased usage of GitHub Copilot chat in SSMS. Thankfully, they are already…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Chad Callihan 