SQL Server

SQL Server 2025 – Optimized Locking

Within the past few days I was investigating one of the new features of SQL Server 2025: Optimized Locking. I was curious about the capabilities, the behaviour and as well the limits of the feature. Optimized Locking is based on(…)

SQL Server 2025 – OPTIMIZED_SP_EXECUTESQL

Within the past few days I was investigating another new feature of SQL Server 2025: OPTIMIZED_SP_EXECUTESQL. I was curious about the capabilities and the behaviour. OPTIMIZED_SP_EXECUTESQL is a database scoped configuration which allows us to get rid of the overhead(…)

Contained Availability Group and login failed

A contained availability group is a special availability group which manages its owns logins, users, permissions, jobs… with a dedicated master and msdb system databases, more information here.At a customer place we found some unexpected “login failed” for the(…)

SQL Server: New SQL Server Management Studio (SSMS)  landing page

After the new connectivity and drivers landing page for SQL Server with .Net, Java, Python, C++, Go and PHP languages, you have a new landing page for SQL Server Management Studio (SSMS) : https://learn.microsoft.com/en-us/ssms You will see 6(…)

SQL Server 2025: Local SQL Server Container – Schema design preview

After my blogs about “SQL Server 2025: Local SQL Server Container without Docker Command” and “SQL Server 2025: Local SQL Server Container – Schema compare preview”, I continue to play & test it. One new feature in preview(…)

SQL Server 2025: Local SQL Server Container – Schema compare preview

After my blog about “SQL Server 2025: Local SQL Server Container without Docker Command”, I continue to play & test it. One new feature in preview is the “schema compare” in this last extension for Visual Code: I like(…)

SQL Server: New connectivity and Drivers landing page

You will find a new connectivity and drivers landing page for SQL Server with .Net, Java, Python, C++, Go and PHP languages: SQL Connectivity and Drivers – SQL Server | Microsoft Learn As you can see, you can download,(…)

Step-by-Step Guide to Enabling Copilot in SSMS

With the latest version of SSMS, SSMS 21, there is now integration with Copilot. In this blog post, we’ll go through the setup step by step, with screenshots, to get everything ready to use Copilot in SSMS.There is already(…)

SQL Server 2025: Local SQL Server Container without Docker Command

The last version of” MSSQL extension for Visual Studio Code” has in Preview “the Local SqlServer Containers” based on SQL Server 2025 with the following keys: Create and manage SQL Server containers locally without Docker commands Use SQL Server 2025(…)

Exploring the Future of Data at SQLBits 2025 in London

I’m looking back on three amazing days of interesting technical insights from the SQLBits event 2025 in London. It’s actually my first time having the pleasure of attending one of Europe’s biggest data platform events and I can sincerely say,(…)