How to Clear the SSMS Cache (SSMS 21 and Later)
How to Clear the SSMS Cache (SSMS 21 and Later)
Updated for SSMS 21 and later: This is a new, rewritten version of my earlier article...
2026-10-21 (first published: 2026-10-10)
509 reads
The flight recorder: Replaying what an AI agent did on my SQL Server
“What exactly did it do on my server?” is the first question a DBA should ask about any AI agent. AgentDBA answers it from its own records: every decision...
2026-10-23 (first published: 2026-10-09)
310 reads
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon and SQLCon Barcelona 2026, with approximately 5,000 attendees at the conference. I’ve tried to make...
2026-10-28 (first published: 2026-10-08)
503 reads
Au Revoir for now
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight for Brussels and this is my last day at work for a couple of weeks....
2026-10-07
57 reads
Goodbye, Microsoft
A few years ago I took a new job at Microsoft, working as a Senior Content Developer, and as of this writing I own all the SQL Server content...
2026-10-05
185 reads
The SUM of Nothing: #SQLNewBlogger
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the...
2026-10-14 (first published: 2026-10-05)
393 reads
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But why keep this important visual warning at the bottom of the screen? In this post,...
2026-10-14 (first published: 2026-10-05)
554 reads
Architecting Zero Downtime Deployments–Day of Data Boston
Here are the resources for my talk at Day of Data Boston. Slides – ArchitectingZeroDowntime.pptx Slides also at: https://dayofdata.org/2026-10-03-dayofdata1150/#schedule Code: https://github.com/way0utwest/ZeroDowntime Book: Refactoring Databases Some interesting questions. I’ll write...
2026-10-04
108 reads
The Book of Redgate:A Prehistory
I’ve covered the values in a number of previous posts on the Book of Redgate. Those values came from our founders, Simon Galbraith and Neil Davidson. I am lucky...
2026-10-02
58 reads
Evidence-bound: what AgentDBA will and won’t link
When the evidence names the database, it says so. When it doesn’t, it stops. Three databases have no recorded full backup. One backup job failed. Many tools would link...
2026-10-12 (first published: 2026-10-02)
203 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers