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.
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.
Read-Only Routing for Availability Group Replicas
Configure availability group read-only routing, listener connections, replica URLs, balanced lists, and verification after failover.