Working with JSON documents in SQL Server 2016? You can’t use FOR JSON inside an UPDATE statement, and trying gives Msg 13602. Here is how to work around it.
Documenting SQL Agent Jobs: Schedules, Steps and Owners in One Query
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.
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.






