Databases and AI Agents
As part of my wider work exploring Claude Code and AI-assisted database engineering, I have been looking at how AI can support SQL Server operations. A failed job, missed...
2026-06-03 (first published: 2026-05-17)
557 reads
Creating a Pulsing Conducting Baton - Part 1
Train Wreck
The last time I watched a high school band nearly fall apart mid-performance was when the relatively new, certainly nervous band director started the piece off much faster...
2026-05-29 (first published: 2026-05-16)
226 reads
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
If you are considering any of the ISACA AI certs like the Advanced Artificial Intelligence Audit (AAIA) or the newly release Advanced Artificial Intelligence Risk (AAIR), ISACA will be...
2026-05-14
247 reads
A Fabric solution can be very cost effective
Are you currently using Microsoft Fabric or considering migrating to it? If so, there are a couple of options to significantly reduce your monthly running costs. Firstly, there’s the...
2026-06-01 (first published: 2026-05-14)
381 reads
Track SQL Server Configuration Changes Using the Error Log
Track SQL Server Configuration Changes Using the Error Log
If you work with SQL Server long enough, you or someone will eventually want to know, “Did...
2026-05-29 (first published: 2026-05-14)
503 reads
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working with cloud data platforms, SQL engines, and machine learning pipelines, a handful of titles keep...
2026-05-22 (first published: 2026-05-13)
434 reads
SSMS Evaluation – future ready
In previous posts, we looked at the SQL Server engine. for us DBAs, the SSMS plays an important role for handling/Managing SQL Server. we have been using these tools...
2026-05-14 (first published: 2026-05-13)
68 reads
Claude.ai vs Claude API
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and mobile apps) is the chat product you talk to. The Claude API is the developer...
2026-05-25 (first published: 2026-05-13)
602 reads
Vanishing objects; hello ORA-08103
In the previous post we saw that even though we had done an exchange partition mid-flights through a query execution, the query kept on running to successful completion. The...
2026-05-13
255 reads
T-SQL Tuesday #198–Change Detection
This month we have a new host, Meagan Longoria, who graciously agreed to help me this month. I’ve known Meagan for a number of years and she’s been a...
2026-05-12
48 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers