Technical Article

Switch Databases

This script changes the physical, logical and file names of a database.  It stores the current database until the next time the script is run, and creates a dummy database for the next update.  The intent was to have minimal downtime even though the load (import, snapshot, etc.) may take a long time.  Three copies […]

You rated this post out of 5. Change rating

2007-02-22 (first published: )

629 reads

Blogs

SQL Server Source Control on a $0 Budget

By

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

CHOOSE’ing a Beer: #SQLNewBlogger

By

We recently published an article on CHOOSE at SQL Server Central. I thought it...

Don’t Treat Your Data Catalog Like a Data Museum

By

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...

Read the latest Blogs

Forums

What programming languages are useful for cybersecurity?

By princydeshmukh28

Programming languages play a crucial role in cybersecurity, helping professionals analyze threats, develop security...

Migrating mission critical database from SQL on Prem to Azure SQL

By Mikael Åkerblom

We are migrating our environments to Azure, it will be a mix of SQL...

The Inefficiencies of Kubernetes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Inefficiencies of Kubernetes

Visit the forum

Question of the Day

The Backup Space Needed

How do I calculate the amount of space needed for I/O buffers during a backup operation?

See possible answers