New blog post:
In which I show you how to easily migrate saved connection details from SQL Server Management Studio 21 to SSMS 22.
https://vladdba.com/2025/11/17/import-saved-connections-from-ssms-21-to-ssms-22/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell
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

VladDBA
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…

Reitse's blog
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.

VladDBA
When you create an ordered Non-Clustered Columnstore Index in SQL Server 2025, you need to do it single-threaded (MAXDOP = 1) to get a perfectly working Segment Elimination. The same also applies to Ordered Clustered Columnstore Indexes... #sqlserver #columnstore
Microsoft Patch Tuesday, November 2025 Edition – Krebs on Security

Spent most of this weekend working on a #SQLSaturday Wellington presentation.

#PostgreSQL for a #SQLServer DBA.

I could have been sitting doing nothing under this sky but I think my time was better spent.

ZSTD with level MEDIUM gives you the same runtime as the traditional MS_XPRESS algorithm, but the backup is around 14 GB smaller. The level LOW is really fast (203 sec. vs. 305 sec., and the backups are still smaller (58 GB vs. 50 GB). #sqlserver #zstd #compression #performance
When you create a 230 GB database in SQL Server 2025, just to be able to demonstrate ZSTD backup compression more seriously... #sqlserver
PostgreSQL has support for the native JSONB data type since version 9.4 - which was released in the year *2014*. SQL Server 2025 will provide a native JSON data type 11 years later... #SQLServer #PostgreSQL #postgres
Denny Cherry Blogged: Denny Cherry https://www.dcac.com/2025/11/13/insert-location-matters-in-dynamic-sql/ Insert Location Matters in Dynamic SQL #sqlserver
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

Denny Cherry & Associates Consulting