Blog

T-SQL Tuesday #202 – An Unforgettable Outage

For T-SQL Tuesday this month, Marlon Ribunal invites us to write about an unforgettable SQL Server outage. Click the T-SQL Tuesday logo to the right to read over the invite post. I’ve written about a few outages and issues in the past and wanted to write about a different one for this post. One that…

Revisiting SSMS SQL Formatter

I posted a few months ago about the latest SQL Server Management Studio updates, including a preview of their SQL Formatter. SSMS 22.9.0 was released a few weeks ago and called out some SQL Formatter improvements on the release announcement, so I thought it would be worth taking a fresh look to see how things…

T-SQL Tuesday #201 – Temp Data

This month for T-SQL Tuesday, Jeff Taylor asks us to write about temp tables and temp data. Click the T-SQL Tuesday post logo to read the full invite. Jeff provides half a dozen prompts to get the ball rolling, and I thought I’d discuss my thoughts on “the whole family. #temp vs. table variables vs.…

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…

Something went wrong. Please refresh the page and/or try again.

Follow My Blog

Get new content delivered directly to your inbox.