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...

Copilot Outside of SSMS Seems to Work

I read Brent’s first look at SSMS and Copilot in there. He didn’t have a great opinion of the tool, especially comparing it to Gemini or Claude. I haven’t...

KDA: Echoes of Deception - Case 1

Another KDA case: Digitown’s utility bills suddenly doubled for no good reason. With the election coming up, I got pulled in to figure out what went wrong. I’ve got...

Why Data Silos Hurt Your Business Performance

Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These silos lead to ineffective decisions from incomplete data, wasted resources through redundant efforts, and missed...

Deciphering Data Architectures: When to Use a Warehouse, Fabric, Lakehouse, or Mesh

As discussed in my blog and book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” (Amazon), organizations are often challenged with...

SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't just handy—it's crucial. Whether you’re making different data types play nice together or boosting query...