T-SQL Tuesday #204 – Are Blogs Still Relevant?
For this month’s T-SQL Tuesday, Jeff Iannucci asks a question that has been on my mind a lot over the last few years: are blogs still relevant? To read the full invite, click the T-SQL Tuesday logo to the right. I don’t think there’s a black and white answer, and it depends on what you’re…
Is AI Utopia or Bust?
I saw a comment on the news recently about a wild trend among those working closely in AI. It was said that some have such a belief in AI and its odds of curing cancer that they have taken up activities like smoking and forgoing sunscreen. The term for this, according to this article, has…
T-SQL Tuesday 203 – Risk vs. Rewards
For this month’s T-SQL Tuesday, Pat Wright invites us to write about weighing risk vs. reward when it comes to database design decisions. While Pat’s prompt mentions design, he also references risky decisions during production incidents. I’ve been involved with more of these reactive decisions than proactive ones and have learned that it’s better to…
AI Fridge Fail
We’ve all rolled our eyes and selected “Postpone” when prompted to download and install software updates. They almost always pop up at an inopportune time. Users of a Samsung refrigerator in South Korea got an update pushed out that did far worse than cause a slight annoyance. It didn’t break a smart feature or the…
Comparing Data with Vectors in SQL Server 2025
Along with the broader term of “AI”, “vector” has also been a hot term, but it may not be as clear what it means. You may have also noticed that with SQL Server 2025, one of the new features introduced is support for vectors. This may span a few blog posts, but I wanted to…
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…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
