Query multiple Azure SQL Databases

I was sick of changing context in Azure Data Studio while cleaning up things discovered in our vulnerability assessments. Changing things via PowerShell I wanted to be cautious with...

Stack Overflow & AI

I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow for a long time. I think the concept of the place, ask a question, get...

Why I Created the SQL Rescue Sprint – And How It Works

Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global enterprises. And no matter the industry or infrastructure, one...

My first year on full disability, wow!

What a year … At the end of May 2024, I went on full time disability. For the first time in my adult life, I was not fully employed....

Getting References for GenAI Results

I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for results. Most of us might take a result from...

KDA: Echoes of Deception - Case 2

The people of Digitown are being targeted by phishermen, and they need my help to stop them in their tracks.
The problem

The police have asked for our assistance, and we’ve...

SQL Server 2025 Is Here – AI Just Changed Everything!

🔟 Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch #MicrosoftFabric #DataEngineering #TechUpdates #decodeites #mssqlfun

T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots on Pure Storage FlashArray, all from within SQL Server, no external tooling. SQL Server 2025...

SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!

They run, they return data. So what? Some SQL queries just waste your time and resources. Here’s what to stop writing – and the much smarter alternatives. Sure, your...

A New Word: Falesia

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to them may not necessarily match – that your best friend might only think of you...