SQL Server Support end dates belong in upgrade planning before the deadline. My original post followed the July 2019 support transition.
Listing Non-Default Server Settings From sys.configurations
Inventory non-default server settings with a versioned baseline, compare configured and active values, and keep the review read-only.
SQL SERVER – Installation Failure – Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed
A client’s second clustered SQL Server instance failed to install: Specified instance via transform is already installed. Here is what I found and the fix.
Tagging Personal Data Columns With ADD SENSITIVITY CLASSIFICATION
Add sensitivity classification to reviewed columns, inspect stored labels, and keep discovery separate from encryption and access controls.
SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator
A developer creating a table in SSMS got a pop-up: You are not logged on as the database owner or system administrator. Here is what the message means.
How Many Foreign Key Can You Have on A Single Table? – Interview Question of the Week #096
How many foreign key references can you have on a single table? I said 253 at SQLPASS, but my answer was not complete. Here is the full answer.
How to Get Started with SQL Server 2016? – Interview Question of the Week #086
A candidate asked me in an interview: how do I get started with SQL Server 2016? Here is my answer for anyone who has not tried it yet.