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…
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…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
