During a live demo, SQL Server refused to connect after a config change. Here is how to start SQL Server Service without tempdb. Never try this in production.
SQL SERVER – Scripting Tip: PowerShell to Identify Last Bootup Time
A friend from the networking team asked when his server was last started. Here is a quick PowerShell script to identify the last Bootup Time of a machine.
SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way
Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.
SQL SERVER 2016: Creating Simple Temporal Table
Want to see what your data looked like on a past date? Here is how to create a simple Temporal Table in SQL Server 2016, with its history table made for you.
Interview Question of the Week #057 – What is GO Statement in SQL SERVER?
Learn what the GO statement really does in SQL Server, why a variable vanishes after it, and the simple rules every script writer should know.





