SQL Server Agent would not start: the request failed or the service did not respond in a timely fashion. SQLAgent.OUT showed why. Here is the fix.
SQL SERVER – Unable to cast object of type ‘System.DBNull’ to type ‘System.String’. (Microsoft.SqlServer.Smo)
Creating a database in SSMS gave me ‘Unable to cast object of type System.DBNull to type System.String’. Here is how I tracked down the cause and fixed it.
SQL SERVER – Script level upgrade for database master failed because upgrade step sqlagent100_msdb_upgrade.sql encountered error
Another cause of ‘Script level upgrade for database master failed’, this time from sqlagent100_msdb_upgrade.sql, and how I fixed it for a client.
SQL SERVER – Error Fix: Msg 13601 Working with JSON Structure
Msg 13601 showed up while I was working with JSON output: a property cannot be generated due to a conflict with another column name. Here is the fix.
SQL SERVER – FCB::Open failed: Could not open file Path for file number 2. OS error: 5(Access is denied.)
SQL Server would not start after a client moved database files from C to D drive: FCB::Open failed with OS error 5, Access is denied. Here is the fix.
SQL SERVER – Fix Error – 948 A downgrade path is not supported. The database cannot be opened because it is version.
Attaching a database gave me Error 948: a downgrade path is not supported. Here is why a database from a newer SQL Server version won’t open on an older one.
Pester the Tester: PowerShell Bugs, Beware! – Notes from the Field #129
Pester the Tester: Robert Cain shows how Pester, an open source testing framework for PowerShell, helps you catch bugs before they catch you.