provisioning

External Article

Automated Database Provisioning for Development and Testing

  • Article

If your development team needs to work on anonymised copies of the current production database, and if changes are being delivered rapidly as well, that could mean a lot of time and routine DevOps work copying databases. SQL Clone was designed for tasks like this. Grant Fritchey investigates whether you save time, effort and scripting over the more traditional approach, and at what point it makes sense to use it.

2017-10-10

4,465 reads

SQLServerCentral Article

Quick Testing with SQL Clone Images

  • Article

Steve Jones explains how SQL Clone can be used to create multiple copies of a database for different testing scenarios, while using just a fraction of the disk space. For example for developers to experiment in sandbox environments, with full copies of large databases, without the hassle and delays of restoring backups or copying database files.

You rated this post out of 5. Change rating

2017-02-14

906 reads

External Article

SQL Server Database Provisioning

  • Article

Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.

2017-01-11

4,829 reads

Blogs

Azure Networking: Designing for Change

By

Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...

The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3

By

Like any good mystery, some SQL Server problems look spooky on the surface but...

Using Customer Docker Compose File Names

By

As I use containers more and more to run various things, I decided I...

Read the latest Blogs

Forums

SQL Server authentication vs. Trusted connection

By Rod at work

I maintain an application written years ago, where the database is on a Windows...

The Duplicate Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Duplicate Cursor

Concerns over AI Chat Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Concerns over AI Chat Privacy

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers