The End of Year Vacation Burn
It’s been a good year for me. With my sabbatical, I felt like I’ve gotten away from work quite a bit this year. I’ve had a few vacations around...
2025-10-20
23 reads
The Voice of the DBA
The Book of Redgate: Don’t be an a**hole
This was one of the original values: The facing page has this text: No matter how smart you are, or how good you are at narrowly defined tasks, there...
2025-10-17
180 reads
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
160 reads
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-31 (first published: 2025-10-15)
298 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-24 (first published: 2025-10-13)
405 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
28 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
26 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
63 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
19 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
38 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers