Can a primary key contain NULL values? No. Here is why primary key and NULL do not mix, and the simple interview question many candidates miss.
SQL SERVER – FIX: SQL Profiler Error – Cannot Retrieve Trace Definition for SQL Server Version
Profiler on SQL Server 2016 showed an empty message box, then ‘Cannot retrieve trace definition for SQL Server version’. How I fixed this SQL Profiler Error.
SQL SERVER – Understanding FAILOVERCLUSTERROLLOWNERSHIP with SQL Server Cluster Rolling Upgrade
I started to hunt in the blog and saw there were a number of posts around (FAILOVERCLUSTERROLLOWNERSHIP) the cluster that caught my eyes:
SQL SERVER – Data Lineage Tracking in ETL Processes – Notes from the Field #124
Tim Mitchell answers the question every ETL developer hears, ‘Where did this data come from?’, and shows how to add data lineage tracking to ETL processes.
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with error 0xd
SQL Server would not start, and ERRORLOG showed TDSSNIClient initialization failed with error 0xd, status code 0x10. Here is what I found.
SQL SERVER – Error Msg 5042, Level 16 – The File ‘tempdev02’ Cannot be Removed Because it is Not Empty
Removing an extra TempDB file gave me Error Msg 5042: the file ‘tempdev02’ cannot be removed because it is not empty. Here is how I got rid of it.
PowerShell – Backup SQL Server System Databases
A client visit showed me that basics like system database backups often get missed. Here is a PowerShell way to back up SQL Server System Databases.