Doing the Little Things
There are a lot of tasks that DBAs and developers struggle to get done. These little things can be important, and perhaps AI can help us keep on top of them.
2026-03-25
109 reads
Administration
2026-03-16
885 reads
2026-03-09
961 reads
2026-03-04 (first published: 2026-03-02)
1,066 reads
2026-02-16
702 reads
Troubleshooting Common SQL Server Errors: 823, and 824
Learn about the critical 823 and 824 errors in SQL Server and how to deal with them in this article.
2025-12-01
1,640 reads
The Version Store Won’t Clear If ANY Database Has Open Transactions.
Short story: what the title says.
2025-11-24
2025-11-10
1,055 reads
2025-11-07
1,232 reads
2025-11-03
1,300 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers