SQL Clone

How Redgate use SQL Clone internally to provision databases

A common thread behind the software we develop is a problem or issue we’ve come across in the software development process. We then adopt the software ourselves, which gives us a real understanding of the features that need to be developed further. To gain a deeper insight into SQL Clone, we spoke to Joseph Woodhouse, Read more

SQL Change Automation

How to import an existing database to SQL Change Automation

The Visual Studio extension of SQL Change Automation (SCA) allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with SCA, in Visual Studio, and chere I’m going to show to get up and running when there is already an existing development database. Read more

SQL Compare

How to examine differences with SQL Compare Summary View and SQL View

During the recent Redgate Hub Launch Livestream Steve Jones introduced the new Summary View, which is available now in SQL Compare. The brand new Summary View is a tab that sits alongside SQL View and provides a more concise breakdown of the differences between two objects. We have achieved this by getting rid of the Read more

SQL Prompt

The SQL Prompt Functionality Finder

You’ve got SQL Prompt, but are you aware of all the things it can do and how to get Prompt to do it? In this article, Phil Factor provides a handy table to make it obvious. As soon as you open SQL Prompt and start typing, its IntelliSense suggestion window will pop up, offering context-specific Read more

SQL Clone

Database provisioning from backups using SQL Clone

In a previous article, Getting Started with SQL Clone, I described how SQL Clone could remove much of the administrative burden from the database provisioning process, the advantages of a new, lightweight process to spin up ‘real databases’ for use in development and test work, and finally how to produce images and then clones, starting Read more

SQL Monitor

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn’t. But one particularly common culprit is when deployments go wrong: I don’t know a single DBA who hasn’t been burned by a bad release. To Read more

SQL Prompt

SQL Prompt Tip: how to control when the suggestion box pops up

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. In practice, when writing code, this means that the suggestion box pops up whenever SQL Prompt thinks it can make a useful suggestion, which is at virtually every keystroke. That isn’t the way that many of us want it to work. Sometimes, as programmers, Read more

SQL Clone

Bringing DevOps to the database – Moody’s Analytics and SQL Clone

Developers need copies of databases to successfully create new code, test programs and fix issues, but provisioning copies is time-consuming, and each one can take up large amounts of storage space – up to a terabyte and more in many cases. This challenge can potentially slow down extending DevOps to the database and ultimately hit Read more

SQL Provision

Protecting production data in non-production environments

This article was updated in November 2018 It now covers SQL Provision, incorporating both SQL Clone and Data Masker A traditional IT problem in many organizations is that the development and operations teams each work in their own silo, and each tends to regard the other as having different, and often conflicting, goals. Developers are Read more

SQL Clone

New permissions features brings access control to SQL Clone

Ever since its launch, SQL Clone has been attracting waves of interest. By allowing SQL Server databases or backups to be cloned in seconds, as well as saving up to 99% of disk space, it removes the burden of database provisioning. What about access, though? Let’s say you have a mixed team of database developers, Read more