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.
Zip Files in SSIS With a Script Task and ZipFile
To zip files in SSIS you don’t need a third-party tool. This guest post by Kevin Hazzard shows how a Script Task and the .NET ZipFile class zip a whole folder in a few lines of C#, and which errors to expect.
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.
Tail-Log Backup: Saving the Last Transactions Before a Restore
Take a tail-log backup before an approved restore, understand NORECOVERY and damaged-database options, and rehearse the full recovery chain.
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.