When SQL Server Agent is disabled, you cannot expand it in SSMS to see its jobs. Here is how to list all the SQL Server Jobs with a simple query instead.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing
A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.
ENCRYPTBYPASSPHRASE: Simple Encryption and Its Weak Spot
One function in, one function out, and then the real question: where does the passphrase live? A short tour with demos you can run.
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.
Transaction Log Backups Based on Log Size
Transaction log backups on a schedule can miss a burst of activity that fills the disk. This post builds a procedure that reads the log written since the last backup and takes a log backup once it passes a limit you choose. It also explains why the old habit of shrinking the log after each backup does harm.
SQL SERVER – SharePoint not Working After Failover to Another Node
After a SQL Server cluster failover, SharePoint users could not open any page, though all SQL resources were online. Here is what we found and how we fixed it.