Review trace flags worth knowing about in current SQL Server, distinguish session, global, and startup scope, and verify each flag’s support.
SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table
An interview question: how do you find a table row count without using T-SQL or opening the table? SSMS table properties show it on the Storage page.
The Blocked Process Report
The blocked process report shows the waiting session and blocker after a configured threshold, with Extended Events capturing the XML for review.
Encrypting Connections to SQL Server
Encrypting connections to SQL Server requires a trusted certificate, careful Force Encryption rollout, and tests with real drivers.
SQL Server on Virtual Machines: Settings That Matter
SQL Server on virtual machines needs deliberate CPU, memory, NUMA, and storage settings; learn what to inspect before blaming a slow query.
Named Instances and Default Instances
Named instances and default instances differ in connection strings, ports, SQL Browser discovery, and the operations each one needs.
Choosing Where to Put Data and Log Files
Choosing where data and log files live means checking storage behavior, capacity, install defaults, and a tested move procedure.