sys.trace_events lists available SQL trace events rather than only default-trace collection. Readers asked after my creation-date article.
When a Table Was Created: Find It With Metadata and Traces
To find when a table was created, read create_date from sys.tables. This post adds the default trace and an Extended Events session for the question of who created it, and tests what a rename or an ALTER does to the date.
NOCHECK CONSTRAINT: Loading Data and Trusting Foreign Keys Again
Use NOCHECK CONSTRAINT carefully, distinguish enabled from trusted foreign keys, validate old rows, and restore optimizer assumptions.
SQL SERVER Agent Missing from SSMS
Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.
CPU Scheduler Waiting on Disk: Read Pending Disk IO
A CPU scheduler waiting on disk shows pending disk IO on its scheduler. This post reads sys.dm_os_schedulers once and in a short sampling loop, then confirms the result with file latency.
SQL SERVER – Troubleshooting High CPU
We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.
SQL SERVER – NOLOCK with DMVs
NOLOCK with DMVs is not a blanket reassurance against monitoring waits. A customer asked about omitting the hint.