Inventory orphaned data and log files by comparing data-folder contents with sys.master_files, then review candidates before cleanup.
SQL SERVER – T-SQL Script to Keep CPU Busy
Need to keep CPU busy for capacity planning or stress testing on a development server? I share an improved script, but never run it on production.
SQL SERVER – Shortcut to SELECT only 1 Row from Table
Developers often select only 1 row to peek at what a table holds, but typing SELECT TOP 1 again and again is slow. I share a quicker shortcut for it.
Restore a Database in SSMS: Step by Step
To restore a database in SSMS, right-click Databases, choose Restore Database, pick the backup file, name the destination and choose the recovery state. This post covers each page of the dialog, the tail-log error that stops overwrites, and the T-SQL for a full, differential and log restore chain.
Safe Dynamic SQL With sp_executesql and QUOTENAME
Write safe dynamic SQL with typed value parameters, validated object names, and allowed sort columns, then test hostile input.
Geo-Replication for Azure SQL
Geo-replication for Azure SQL protects against regional failure through readable replicas or failover groups; learn lag, routing, and drills.
SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed
A JDBC user got ‘The TCP/IP connection to the host localhost, port 1433 has failed’ even after checking the firewall. Here is the sqljdbc_auth.dll fix.