SQL Server

How to solve Stored Procedure parameter sniffing problems

Since Tuesday, I have the chance to follow the SQLBits 2022 conference. Sadly, I have to do it remotely this year but I promise next time I will come in-person 😉 SQLBits is one of the largest(…)

SQLBits 2022 – Levelling up my Performance Tuning skills

As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022.

What I really like about Percona PMM

Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we(…)

SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail

Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big… To see which table are so big, in SSMS, I select the msdb database, right-click, go in(…)

SQL Server: Cannot execute as the database principal “dbo” does not exist

By a customer this month, I see a very big big ErrorLog file (more than 1,5GB). When I open the file, every 5 seconds, the following message is added: The activated proc ‘[dbo].[IdentityServerNotificationCleanup]’ running on queue ‘<database>.dbo.IdentityServerNotificationsQueue’(…)

SQL Server: how to have the number of core-based licenses used on my environment?

This week, a customer asks me to find out how many SQL Server Standard licenses are used in their environment. The licensing is core based and to not be used for Sserver + Cals licenses. To have an idea,(…)

SQL Server – Granting SQL Server permission to service SID

Introduction We know that SQL Server itself is using it own SID NT SERVICEMSSQL$ and NT SERVICESQLAGENT$ to grant permission to the database engine and the SQL agent services. But the same method can be used for other application(…)

SQL Server database design – Moving table to new filegroups

Introduction A database is very often created without thinking of its growing and in the most cases that is not really an issue until the data volume is not increasing a lot. And most of the time when a high(…)

dbi Event Recap: SQL Server Automatic Tuning and Query Store

Earlier this month, dbi services hosted a free multi-technology event. Details are available on our website. I had the opportunity to present a session about the Query Store and the Automatic Tuning feature available on SQL Server and(…)

SQL Server: Is Fill Factor applied during INSERT?

The Fill factor setting controls the amount of space that is left available on the index data pages. The goal is to allow new rows to be inserted or existing ones to change size (UPDATE)  without resulting in(…)