Create Database Snapshot Dynamically

Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.

Automated Rapid Recovery during Database Code Releases using Snapshots

Leveraging snapshots across multiple databases simultaneously to allow for quick rollback in case of a problem deploying code

Alas Poor Snapshot, I Knew Him Well

Quick snapshot

Script enables a quick creation of snapshots for databases

Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot

Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the next question “Can we update the database snapshot?”

Initialize SQL Server replication using a database backup

You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.

Post Snapshot Script - SQL School Video

The post snapshot script in replication allows you to make changes to the subscriber after you complete a snapshot. Unaware of this feature? Watch this episode of SQL School.

Snapshots

A Reporting System Architecture

This article describes one method of implementing a reporting system in SQL Server 2005

A Question of Efficiency

Hi, All my SQL developments are for internet based systems and I was wondering which of the following 4 methods of querying is most efficient. 1) Build the query in Vb (.Asp) and send it straight to the Db. I.E Sql = "SELECT dbo.Customers.CustomerID," Sql = Sql & " dbo.[Order Details].UnitPrice," Sql = Sql & […]