For a WAIT FOR test in MySQL, I use SLEEP with a bounded delay. A customer asked for the corresponding command.
SQL SERVER – List All Available TimeZone
sys.time_zone_info lists timezone names and their current offsets. My SQL Server 2019 environment returned 141 rows.
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.