Plan rebuilding system databases with Setup when master has no usable backup, then restore logins, jobs, and configuration.
What Is Replication in SQL Server?
Replication in SQL Server copies chosen tables to other servers and keeps them current. Publisher, distributor and subscriber in plain words, the three kinds, and why replication is not high availability or a backup.
Database Security Basics for a Small Business
Database security basics for a small business cover patching, off-site backups, strong logins, limited access, and encryption that works.
SQL SERVER – Simple Trick to Backup Azure Database with SkyDrive
SQLBackupAndFTP 9 can send backups to SkyDrive or Box. Here is how to backup Azure database with SkyDrive and keep your backups in free cloud storage.
SQL SERVER – Database in RESTORING State for Long Time
Database stuck in restoring state after you restored every backup? Usually the last log was restored without RECOVERY. Here is how to bring it online.
ZSTD Backup Compression in SQL Server 2025
Test ZSTD backup compression in SQL Server 2025, compare recorded sizes and algorithms, and check restores before changing defaults.
Log Shipping to a Readable Standby: Restores vs Report Users
Configure a readable standby for log shipping, balance restore jobs with report users, and measure copy and restore delay.