Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.
SQL SERVER – History of SQL Server Database Encryption
Michael Coles, co-author of Expert SQL Server 2008 Encryption, let me share his history of SQL Server database encryption, starting from SQL Server 2000.
SQL SERVER – Information Related to DATETIME and DATETIME2
A reader comment explains the precision issue between DATETIME and DATETIME2: values lose precision when converted between types. Here is the workaround.
SQL SERVER – FIX ERROR 3702 Cannot drop database “MyDBName” because it is currently in use
Error 3702: cannot drop database because it is currently in use. Set it to SINGLE_USER WITH ROLLBACK IMMEDIATE, then drop it. Best kept for demo servers.
SQL SERVER – Get All the Information of Database using sys.databases
A handy script from Matteo that uses sys.databases to show plenty of database information, like status, data and log file counts and their sizes in MB.
CURRENT_DATE, || and Other Small T-SQL Changes in SQL Server 2025
Use CURRENT_DATE, string concatenation, optional SUBSTRING length and bigint DATEADD in SQL Server 2025 with clear examples and checks.
SQL SERVER – Get Database Backup History for a Single Database
A reader script by aasim abdullah to get database backup history for a single database: backup file, size, time taken, LSNs and the type of each backup.