Import saved connections from SSMS 21 to SSMS 22

This blog post is a guide for migrating saved connection details from SQL Server Management Studio 21 to SSMS 22

Ignite announced SQL Server 2025 and Fabric SQL GA

I’m guessing you’ve seen posts, blogs and social media activity in the last year on both Fabric SQL databases and rumours around SQL Server 2025. Today, Microsoft announced that both of…

My SQL Server Management Studio 22 configuration

SQL Server Management Studio 22 just went GA this week, so I figured I'd document my new configuration in a blog post.

Microsoft Patch Tuesday, November 2025 Edition – Krebs on Security

Insert Location Matters in Dynamic SQL

I'm working on optimizing a stored procedure for a client and converting a lot of it to dynamic SQL to better handle the branching logic in the WHERE clause. As part of this stored procedure, there's heavy use of temporary tables, so I played around with inserting the data from the queries into them. And some of the inserts are quite large, with hundreds of thousands or even millions of rows each. As part of my testing, I had the insert statement both inside the dynamic SQL... DECLARE @SQL NVARCHAR(MAX) SET @SQL = 'insert into #table select ...' exec sp_executesql