Trace a data load error to its source row with raw staging, TRY_CONVERT, stable row identifiers, and a rejection report that supports a safe retry.
SQL SERVER – DBA or DBD? – Database Administrator or Database Developer
My poll asked if you are a Database Administrator or Database Developer. Of 694 voters, 63.4% chose developer, so maybe DBD earns a dictionary spot.
How to Practise SQL Without a Real Database
You can practise SQL with small invented tables, generated rows, and repeatable exercises without access to a company's production database.
SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage
My SQL puzzle: which queries create the most TempDB IO and grow its size? Answer with any DMV, and all valid answers get published here with credit.
Where a Self-Service Report Actually Gets Its Data
Trace self-service BI numbers through source data, transformations, refresh schedules, credentials, gateways, and the owner of each step.
SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology
I went back to my alma mater, Nirma Institute of Technology in Ahmedabad, to deliver a session on database performance and career. It felt wonderful.
SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution
A friend could not delete, truncate or drop a table at 11 PM because of open transactions. Here is my quick and dirty way to identify blocking query.