Write a reproducible script with minimal tables, synthetic rows, the failing query, expected results, and the exact SQL Server version.
SQL Server Management Studio – New Feature – Object Explorer Query Tracking
Object Explorer Query Tracking exposed SSMS queries while expanding nodes in the historical release. I used its Output window for investigation.
How to Allow Only Alphabets in Column? – Interview Question #136
Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.
SQL SERVER – 3 Different Usage of DBCC SQLPERF
DBCC SQLPERF can report log usage or reset cumulative wait and latch statistics. I separate reporting from resetting the baseline.
SQL SERVER – Cluster Patching: The RPC Server is Too Busy to Complete This Operation
A cluster patch failed with The RPC server is too busy. The real cause was a stopped Remote Registry service on the other node, and why it was off.
Azure SQL Hyperscale: When the Database Outgrows One Server
Evaluate Hyperscale by separating compute and storage needs, testing read replicas, and checking migration, recovery, and current limits.
SQL Server – Configuration Manager Console Running Very Slow and Time Out
A Compatibility Level change helped one customer’s Configuration Manager Console. I keep that incident separate from a universal repair recommendation.