Tim Mitchell’s data lineage lesson explains why ETL needs traceability. A small SQL Server example shows why an aggregate can have several source rows.
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.
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.
SQL SERVER – Optimizing Tabular Models for Self-Service Reporting: Summarize By – Notes from the Field #123
Bill Anton explains how the Summarize By property helps you optimize Tabular Models for self-service reporting, where users build their own reports.
SQL SERVER – Skip “Save Changes to the Following Items?” Prompt in Management Studio (SSMS 2016)
Tired of the ‘Save changes to the following items?’ prompt when closing query windows? SSMS 2016 has a setting to skip it, and here is where to find it.