Database Administration & Monitoring, Development & Performance, SQL Server, Technology Survey Data Platform Virtual Summit Pre-con 2022 13.09.2022 by Stéphane Haby 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(…)
Database Administration & Monitoring, Database management, SQL Server, Security, Technology Survey SQL Server 2022 security: Do you know Ledger? 15.08.2022 by Stéphane Haby 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(…)
Database Administration & Monitoring, SQL Server SQL Server Deadlock on UPDATE with Serializable isolation level 10.08.2022 by Steven Naudet 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(…)
Database Administration & Monitoring, SQL Server, Security SQL Server Security: Check if the guest is active on all user-databases through the CMS 08.08.2022 by Stéphane Haby 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(…)
Database Administration & Monitoring, SQL Server First look at SQL Server 2022 Contained Availability Groups 09.06.2022 by Steven Naudet 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(…)
Database Administration & Monitoring, SQL Server SQL Server 2022 Parameter Sensitive Plan optimization 01.06.2022 by Steven Naudet 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(…)
Database Administration & Monitoring, SQL Server SQL Server 2022 public preview available 31.05.2022 by Steven Naudet 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(…)
Database Administration & Monitoring, SQL Server SQL Server: Find who forced a plan in Query Store with this new XEvent 22.04.2022 by Steven Naudet The latest Cumulative Update for SQL Server 2019 has been released this week on Monday. It brings many bug fixes and some small improvements. One of these improvements is the addition of an extended event to identify the(…)
Database Administration & Monitoring, SQL Server SQL Server: Automatic Soft-NUMA and uneven CPU load 20.04.2022 by Steven Naudet SQL Server has CPU limitations depending on the Edition. If your VM is not configured properly you can reach these limits very easily. In a previous post, I described the effect VM misconfigurations can have on performance because not(…)
Cloud, Database management, SQL Server, Technology Survey Striim, real-time data integration 11.04.2022 by Stéphane Savorgnano In my first blog-post about Striim, I showed you how to create an Initial Load from an on-premise database to an Azure SQL DB. In this second blog post I will create an application which will stream Data(…)