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.
Flush Authentication Cache: Who Can Run DBCC FLUSHAUTHCACHE
Flush authentication cache entries with DBCC FLUSHAUTHCACHE. This post tests the command on SQL Server 2025, shows who can run it and that on SQL Server 2025 it ends no open session, and says what it is documented to do on Azure SQL Database.
Last Used Stored Procedure in SQL Server: When Did It Last Run?
To find the last used stored procedure, read last_execution_time from sys.dm_exec_procedure_stats. This post tests it on demo procedures, shows why a NULL does not mean never, and adds Query Store for a longer memory.
Checking Last Good DBCC CHECKDB Time With LastGoodCheckDbTime
Inspect LastGoodCheckDbTime for each database, flag stale or unavailable checks, and compare metadata with retained integrity-job evidence.
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.
Unix Timestamp in SQL Server: Converting Seconds and Milliseconds Both Ways
A Unix Timestamp counts seconds or milliseconds since 1 January 1970 UTC. This post converts it to datetime2 and back on SQL Server 2025, shows why datetime2(3) keeps the milliseconds, how to pass the year 2038 limit and how time zones and dates before 1970 behave.