SQL Server

Data Platform Virtual Summit 2022 –  Day 2

Today the Data Platform Virtual Summit begin at 03:30 am for us… It’s a little bit early but better than yesterday. My schedule for the day: D2B1 – HYDRA – Overview of SQL Server 2022 – Intermediate – Bob Ward(…)

Data Platform Virtual Summit 2022 –  Day 1

Today the Data Platform Virtual Summit begin at 00:30 am for us… It’s a little bit early but when we like our work and like to learn, we stay up with plaisir. My schedule for the day: After the login,(…)

SQL Server 2022 – Azure Synapse Link

Why is this feature interesting? The Azure Synapse Link for SQL Server 2022 will enable you to replicate your operational data into Azure Synapse Analytics dedicated SQL pool. Azure Synapse is an enterprise analytics service that accelerates time to insight(…)

Data Platform Virtual Summit Pre-con 2022

Thanks to dbi services to let me the opportunity to follow this week and next week, the Data Platform Virtual Summit beginning with the Pre-con. I subscribe the session of Guy Glantser about The Performance(…)

SQL Server 2022 security: Do you know Ledger?

You probably hear or view that on the security point of view, the next version of SQL Server: SQL Server 2022, has a feature named Ledger. It’s already used in Azure but what is Ledger? In 2 points, I will(…)

SQL Server Deadlock on UPDATE with Serializable isolation level

Recently I spent some time on a recurring Deadlock problem on a customer’s site in a high concurrency environment. It was only after finding the solution on my own that I discovered that this particular problem is already well documented(…)

SQL Server Security: Check if the guest is active on all user-databases through the CMS

Today, a customer asks me to have look on each SQL Server instance to control if the user-database Guest is active or not. The easiest way is to go through the CMS (Central Management Servers) with a query but witch(…)

First look at SQL Server 2022 Contained Availability Groups

Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by providing the(…)

SQL Server 2022 Parameter Sensitive Plan optimization

Introduction The Intelligent Query Processing (IQP) feature family is extended with SQL Server 2022.One of the most anticipated features is the Parameter Sensitive Plan optimization. I started to test this new feature. In this post, you will find some(…)

SQL Server 2022 public preview available

This is a small blog post to share that the SQL Server 2022 public preview is available for download. The Microsoft announcement blog post and a summary of the new feature are available here : Announcing SQL Server 2022(…)