Error 22022 says SQLServerAgent is not currently running so it cannot be notified of this action. Here is what causes it and how to fix it.
SQL SERVER – Are You Suffering from Unknown SSAS Performance Challenges? – Notes from the Field #109
Bill Anton explains how to tell if your app suffers from unknown SSAS performance issues, and why Analysis Services need not be a black box. Notes from the Field #109.
SQL SERVER – Unable to Start SQL Browser
The SQL Browser service on my VM went from Started back to Stopped every time. Here is what the Application Event Log showed and how I fixed it.
Geometry Datatype – Line String Behavior Enhancements
A developer saw slow performance with line strings in the Geometry datatype. I share what I found and the line string behavior enhancements that help.
SQL SERVER – Script: Remove Spaces in Column Name in All Tables
A reader wanted a script to remove spaces from every column name in all tables. Here it is, with a warning first: renaming columns can break your application.
SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS
My notes on the lesser used parts of Activity Monitor in SSMS, like Resource Waits, and how the tool builds them from sys.dm_os_wait_stats at each refresh.
SQL SERVER – How To Improve Performance by Offloading Backups to a Secondary Replica – Notes from the Field #108
Want more from two servers? In Notes from the Field #108, Eduardo explains how offloading backups to a Secondary Replica can make the primary server faster.