SQL Server Database Provisioning Report

Survey on database provisioning requirements among SQL Server Professionals

What are the biggest challenges in database provisioning?

Should production data be used in test environments?
Which industry sectors don’t use production data in test environments?
What are the reasons for restricting the use of production data?

Find out the answers in this exclusive report

Database provisioning raises lots of questions and the answers are important because waiting until the point of release to see how software behaves is a key cause of chaotic or even catastrophic software releases.

Yet establishing production-like environments with realistic data sets for use in development and testing has long been a challenge for companies and organizations of every size in every sector.

The need to 'bake quality in' by ensuring realistic configurations and data sets are 'shifted left', has never been higher, and the DevOps movement has long recognized it. In Part III of The DevOps Handbook, for example, the authors write:

Our goal is to ensure that Development and QA are routinely integrating the code with production-like environments at increasingly frequent intervals…In other words, we will only accept development work as done when it can be successfully built, deployed, and confirmed that it runs as expected in a production-like environment.

The DevOps Handbook, by Gene Kim, et al

Database provisioning carries its own challenges, with characteristics which have not commonly been addressed by other provisioning toolsets. Some of these include concerns around data security and regulatory compliance, as well as infrastructure issues like storage space.

But what is the true picture? How important is database provisioning, who controls it, and how often is it needed?

To find out the answers, Redgate conducted a survey among nearly 500 SQL Server professionals. The resultant SQL Server Database Provisioning Report reveals how organizations currently provision databases, identifies the challenges faced by database teams, and offers a unique glimpse into database provisioning in the real world.

Get the full report

Download the report

Compliant Database DevOps

Redgate's Compliant Database DevOps solution gives you an end-to-end framework for extending DevOps to your database while complying with regulations and protecting your data.

Find out more

"It was really easy to use. In some cases, cloned machines were performing even better than real ones!"

Evaldas Buinauskas, Database Development Technical Leader, Euromonitor International

Read more about SQL Clone