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.
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.
Moving TempDB to New Drive – Interview Question of the Week #077
A 1 AM call: TempDB was full on the C drive. Here is the popular interview question on moving TempDB to new drive, with the steps I use.
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.