AI Experiments: Claude Solved a DAB Issue
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some sort of agent. I’m doing the same, but in this case, I had it tackle...
2026-07-29 (first published: 2026-07-22)
506 reads
Audit – Security Compliance Frameworks (Part 1)
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about GRC and different audits and other important information, later we will discuss each audit frameworks...
2026-07-21
79 reads
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack container in a Macbook. If you are like me who switched from a Windows laptop...
2026-07-29 (first published: 2026-07-20)
615 reads
Day of Data Baton Rouge Slides and Code
Thanks to everyone for attending my talk today at Day of data Baton Rouge 2026 (formerly SQL Saturday Baton Rouge). The slides are here: Building an API with DAB...
2026-07-18
91 reads
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array. The VM moved, the old volumes were destroyed, and nobody created a Protection Group on...
2026-07-27 (first published: 2026-07-17)
467 reads
The Book of Redgate: Products
We are product focused at Redgate Software. Here is another of our values that focused on this: The text on the next page is: Shipping something amazing is better...
2026-07-17
49 reads
Microsoft Copilot: What Each Copilot Does and Where It Fits
It can feel as if Microsoft has put the Copilot name everywhere, and that is not far from the truth. The important thing to understand is that Microsoft Copilot...
2026-07-27 (first published: 2026-07-16)
426 reads
KDA: Echoes of Deception - Case 7
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and Dublin, Krypto jumped between planes mid-air.
2026-07-24 (first published: 2026-07-16)
148 reads
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do and, still, nothing works. So, you decide that calling in for help is the next...
2026-07-24 (first published: 2026-07-16)
532 reads
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the tenth consecutive year, recognized in the Azure SQL and SQL Server technical areas under Data...
2026-07-16
68 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers