Set up FileTable prerequisites, create a Windows-accessible file namespace, query stored file metadata, and compare simpler path storage.
Keeping a Patch Test Environment Honest
A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.
Moving From LocalDB to a Real Instance
Moving from LocalDB to a server instance takes a tested backup and restore, new connection strings, mapped logins, and a collation check.
Upgrading With Log Shipping for a Short Cutover
Upgrading with log shipping stages a newer secondary with NORECOVERY, applies logs in order, and leaves a short, rehearsed final cutover.
Moving a Database to New Hardware With Little Downtime
Moving a database to new hardware with little downtime uses early restore, a maintained log chain, final synchronization, and a tested client switch.
Resetting a Test Database With Database Snapshots
Resetting a test database with SQL Server snapshots gives a fast baseline for repeatable tests; create, revert, and manage sparse files safely.
SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup
A reader’s database backup got much smaller with no code change. The reason was the compressed backup setting at the server level. Here is the story.