Throwback Thursday: May 8, 2025
Today's edition of Throwback Thursday is all about scripting major SQL Server operations like backing up, cloning databases, and server migrations.
With over a million words scattered across more than 1,500 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
All Hail Ola!
If you’re managing SQL Server and you’re not using Ola Hallengren’s scripts, then you’re doing it wrong.
Mike Wolfe
Save $3,500 by Creating Scheduled Backups Using SQL Server Express
You don’t need to spend big bucks to get automated database backups with SQL Server. This simple step-by-step process is nearly foolproof.
Mike Wolfe
Cloning a SQL Server Database
The fastest, simplest, and cheapest way to clone a SQL Server database for debugging or testing. Even works with SQL Server Express!
Mike Wolfe
SQL Server Migration Steps
My SQL Server migration philosophy consists of two priorities: (1) Avoid disasters and (2) Minimize production downtime.
Mike Wolfe
Scripted SQL Server Migrations
Use this batch file to automatically backup a database on one instance of SQL Server and restore it on a different instance of SQL Server.
Mike Wolfe
Wisdom from Around the Web
Brent Ozar Unlimited - SQL Server Consulting and Training
Brent Ozar Unlimited’s specialized experts focus on your goals, diagnose your tough database pains, and make Microsoft SQL Server faster and more reliable.
SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave
SQL Server Performance Tuning Expert
Pinal Dave
Developer Humor
Top answer to how much SQL knowledge is adequate for obtaining a job
by u/Flintor in ProgrammerHumor
Cover image generated by Ideogram
