sys.time_zone_info lists timezone names and their current offsets. My SQL Server 2019 environment returned 141 rows.
CPU Running 100% – SQL in Sixty Seconds #185
I got lots of responses to this blog and people wanted me to create a video for this topic. Here, I have a video for CPU Running 100%.
SQL SERVER – Measure Index Performance
I measure index performance against the same workload before and after a change. A customer wanted to assess a new index.
SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist
One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal.
SQL SERVER – Source Database in Restoring State
A Source Database in Restoring State can follow a tail-log backup WITH NORECOVERY. A customer encountered this while restoring another copy.
distributor_admin Login: Why Renaming It Is a Bad Idea
Do not rename the distributor_admin login on a server that uses replication. This post shows how to check whether replication uses it, and a loopback demo with a throwaway login that shows what a rename breaks.
SQL SERVER – List of Trace Events
sys.trace_events lists available SQL trace events rather than only default-trace collection. Readers asked after my creation-date article.