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.
SQL SERVER – SQL Agent Not Starting. The EventLog Service has Not Been Started
After a server hardening script, a client’s SQL Agent would not start because the Eventlog Service had not been started. Here is how we traced and fixed it.