How to create and refresh development and test databases automatically, using SQL Clone and SQL Toolbelt

  • Article

Phil Factor shows how a set of Redgate tools can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers. Before tearing down and rebuilding a database to a new version, we take care to save any DDL changes made to the existing copy.


Redgate Data Tools in Visual Studio 2017 Enterprise

  • Article

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.


5,294 reads


Scalar Valued Functions in SQL Server 2019


(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Globally Distributed Azure Cosmos DB


Let’s use the Azure portal to build a globally distributed  Cosmos DB.  Before doing...

Trailing Spaces in SQL Server


Watch this week’s episode on YouTube. A long time ago I built an application...

Read the latest Blogs


Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Query help

By jdc

I have to insert data into archive table called Archive_table from Table A based...

importing Cubes from SQL 2008 R2 into SSAS 2016

By datsun

Hello, I am trying to move off OLAP/SSAS cubes from SQL 2008 R2 into...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers