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 – Scoped Firewall Rules Instead of Disabling the Firewall
A firewall rule should permit the required SQL Server or management connection narrowly. My original automation case needed remote access.
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?
dbatools installs as a PowerShell module on a Windows management machine. Rob Sewell, known as DBA with Beard, introduced me to it.
Delete Old Backup Files in SQL Express with PowerShell
SQL Server Express has no SQL Server Agent, so nothing runs to delete old backup files and the disk slowly fills. This post gives a PowerShell script that removes backup files older than a set number of days, tests it with a dry run, refuses to delete when any backup type has no recent file, and shows how to schedule it with Task Scheduler.