Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

If you’ve spent any time tuning SQL Server, you’ve probably heard “Turn...

SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS

Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now runs successfully on Docker Desktop for macOS without needing OrbStack.

Startup scripts in SQL Server containers

I was messing around performing investigative work on a pod running SQL Server 2025 in Kubernetes the other day and noticed something…the sqlservr process is no longer PID 1...

Three Ways to Use Snowflake Data in Microsoft Fabric

Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting governance. With Fabric OneLake and open table formats like Iceberg and Delta, there are now...

SSMS 22 still inserting tabs instead of spaces

I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to...

Who’s the Winningest Coach (with AI Help)

I was listening to the radio the other day and the hosts were discussing the NFL playoffs in 2026. Someone mentioned the winningest coach was Nick Sirianni of the...

Deploying an Updated Model with SQL Compare 16

In a previous post, I deployed a model to a database using SQL Compare 16. This used a new feature in that connects to Redgate Data Modeler. In this...

Getting Your Data GenAI-Ready: The Next Stage of Data Maturity

I remember a meeting where a client’s CEO leaned in and asked me, “So, we have tons of data… Why can’t we just add AI and call it a...

Looking Back at the Redgate 2026 Company Kickoff

Last week I spent a few days in Cambridge, UK for the Redgate Company Kickoff. I landed at 1130a Monday and flew away at 1215p Thursday. I wish I...

Runing tSQLt Tests with Claude

Running tSQLt unit tests is great from Visual Studio but my development workflow isn’t just write tests, run tests, fix tests, run tests anymore, it is 2026 and...