A Broken Copilot Query
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into an interesting issue. This is part of a series of experiments with AI systems. My...
2025-10-16
12 reads
The Voice of the DBA
Prompt AI helping with Auditing
I had a conversation with a customer asking this question: how can I tell who called a stored procedure so I can audit the action? I decided to see...
2025-10-15
13 reads
Adding a Local Model to Ollama through the GUI
I saw some good reviews of the small gemma3 model in a few places and wanted to try it locally. This If you want to get started, read my...
2025-10-13
21 reads
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
It’s that time of the month, and I’m late. My apologies. I had a mix-up with a host and was on vacation all last week, so no invite. I’m...
2025-10-12
9 reads
A New Word: Ecstatic Shock
ecstatic shock – n. a surge of energy upon catching a glimpse from someone you like, which scrambles your ungrounded circuits and tempts you to chase after that feeling...
2025-10-03
15 reads
AI Model Size, Parameters and Download
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there was a great question that I wasn’t sure about. Someone asked about the download size...
2025-10-01
17 reads
Back in the EU
I flew to Amsterdam last night and hopefully by the time this publishes I’ll be at my hotel, catching up on messages and prepping for another Simple Talk Podcast...
2025-09-29
11 reads
SQL Saturday Boston Slides and Code
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve got resources listed below Slides Here are the slides from my two sessions Running a...
2025-09-27
21 reads
Advice I Like: Fear and Imagination
Fear is fueled by a lack of imagination. The antidote to fear is not bravery; it looks more like imagination – from Excellent Advice for Living What a neat...
2025-09-26
12 reads
The Challenge of Implicit Transactions: #SQLNewBlogger
I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another...
2025-10-17 (first published: 2025-09-24)
144 reads
Blogs
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
The Journey to PostgreSQL (or anything)
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers