SSMS showed the rows affected message, but SQLCMD on one instance did not. Here is the configuration option behind it and where you can change it.
SQL SERVER – Unable to start SQL Server Agent – Failed to Initialize SQL Agent log
My friend changed SQL Agent parameters and then the service would not start: failed to initialize SQL Agent log. Here is where to look and how we fixed it.
Interview Question of the Week #060 – What is the Difference Between EXCEPT Keyword and NOT IN?
Even 11 years after SQL Server 2005, few people I interview know the EXCEPT keyword. Here is how EXCEPT differs from NOT IN, with simple examples.
SQL SERVER – 2016 – Check Value as JSON With ISJSON()
Before you store JSON sent from the front end, make sure it is valid. Here is how the ISJSON() function in SQL Server 2016 checks a value as JSON.
A T-SQL Formatting Style Guide for Teams
Adopt a short T-SQL formatting style with clear columns, joins, aliases, semicolons and comments, and keep review focused on query behavior.
SQL SERVER – How to Start SQL Server Service Without tempdb?
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.