Not an Azure Key Vault after all: a Recovery Services vault that would not delete. The AzureRM script is retired, and soft delete waits 14 days.
SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting
SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting. Let us fix that in this blog.
SQL SERVER – Setting ARITHABORT ON for All Connecting .Net Applications
SQL Server expert Tim Cartwright shares a way to set ARITHABORT ON for all connecting .Net applications, so they avoid the bad plans ARITHABORT OFF can cause.
SQL SERVER – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)
An automated SQL Server install meant we had to disable the firewall without logging in. Here are three ways to turn it off remotely: NetSh, PowerShell and PsExec.
SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure
SQL Server running under a gMSA would not start: the service did not start due to a logon failure, yet no password had expired. Here is the real cause.
PowerShell – Get Maximum Memory of Server with dbatools
Readers asked how to get started with dbatools. Here is a simple first step: finding the maximum memory of a server with one PowerShell command.
PowerShell – How to Install dbatools?
One of the most popular questions any PowerShell expert would receive is how to install the most popular dbatools based on Powershell scripts?