SQL Server

SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption

In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server. It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10(…)

SQL Server Installation Wizard error : Failed to retrieve data for this request

Today I faced a strange issue when I tried to install a new SQL Server instance : Failed to retrieve data for this request This error occurred just after clicking on “New SQL Server stand-alone installation…”(…)

SQL Server: Change Availability Group Endpoint Ownership

I’m doing some cleaning on my customer’s instances. I want to delete the login of a previous DBA for 2 reasons; this person does not work anymore in my customer’s company and all DBA are members of a group(…)

Introduction to Azure SQL Database Auto-failover groups

SQL Azure Database by default offers a 99.99% availability SLA across all its service tiers. This means that for any database, the downtime should not exceed 52 minutes per year. Using Zone redundancy increases availability to 99.995% which is(…)

How to create an Azure SQL Database using Azure PowerShell

In this blog post, I’ll go through the steps to create an Azure SQL Database using Azure PowerShell. Introduction to Azure SQL Database The SQL database services provided by Microsoft on the cloud are now grouped under the(…)

SQL Server: Synchronize logins on AlwaysOn replicas with dbatools

The SQL Server environment  I worked with today has dozens of SQL Server instances using AlwaysOn Availability Groups for High Availability.When a login is created on the Primary replica of an Availability Group it is not synchronized automatically on(…)

SQL Server: Quickly clean backup history with dbatools

I just had to restore a database in production for my customer. Before doing the restore I have the habit to query the msdb.dbo.backupset table to get an overview of the last backups. When running my query, I felt it(…)

SQL Server: Collect Page Split events using Extended Event session

Earlier this week someone tried to show me how to capture page split events using Extended Events (XE) but unfortunately, the demo failed. This is a good opportunity for me to refresh my knowledge about page split and set up(…)