I started to hunt in the blog and saw there were a number of posts around (FAILOVERCLUSTERROLLOWNERSHIP) the cluster that caught my eyes:
Data Lineage Tracking in ETL Processes: Notes from the Field #124
Data lineage tracking in ETL processes answers one question: where did this value come from? Tim Mitchell’s Notes from the Field lesson is kept, and a tested SQL Server example now traces a total back to its source rows, forward from one sale, and across two load runs.
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.
List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070
In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.
SQL SERVER – Change Color for System Object Name in Text Editor (SSMS 2016)
SSMS 2016 shows system objects and DMVs in a color that is hard to read. Here is how I changed the system object color in the Text Editor back to the old style.