Make test data generation reflect skew, row width, missing values, and key relationships so your SQL Server experiments expose realistic plan risks.
Interview Question of the Week #061 – How to Retrieve SQL Server Configuration?
A common interview question: how do you retrieve SQL Server configuration? Right-click and Properties is not enough. Here is the better answer.
SQL SERVER – Where is Rows Affected in Output?
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.
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.







