Start documenting SQL Agent jobs with owners, steps, readable schedules and retained run outcomes, then save a reviewed inventory document.
SQL SERVER 2016 – InMemory OLTP LOB Datatype Enhancement
SQL Server 2016 brings InMemory OLTP LOB datatype support to memory-optimized tables and natively compiled procedures. Here is what I found exploring it.
SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion
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.
How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078
Lost or corrupted your log file? Learn how to attach an MDF data file without the LDF log file, using T-SQL or SQL Server Management Studio.
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.