dbatools

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(…)

Build SQL Server audit reports with Powershell

Introduction When you are tasked with conducting an audit at a client’s site or on the environment you manage, you might find it necessary to automate the audit process in order to save time. However, it can be challenging(…)

dbachecks: how to add your own checks

As a DBA I used more and more the dbachecks at customer place to validate environments. It became part of our DBA toolkit at the same place than its famous brother the dbatools.My colleague Steven Naudet did(…)

Patch a SQL Server instance automatically with PowerShell

In my last blog post I explained how to automatically download the last Service Pack and Cumulative Update for all versions of SQL Server.Here I will show you how to patch your SQL Server instances automatically with some(…)

How to automatically download last SQL Server SP and CU with PowerShell

One of my customer asked me some days ago to create a PowerShell script to patch its SQL Server instances. After a reflection time, the first step will be to download the last Service Pack and the last Cumulative(…)

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(…)