Generating test data in JSON files using SQL Data Generator

Phil Factor shows how to use SQL Data Generator to produce as much pseudonymized data as you are likely to need for your testing, and then convert it to JSON so that you can also use it to test your MongoDB and Azure Cosmos databases, or to test out a new web service. Read more

SQL Server Database Provisioning: Getting Started with SQL Clone

Tony Davis takes a ‘first look’ at cloning databases with SQL Clone, reviewing some of the database provisioning challenges that we seek to overcome, explaining briefly how SQL Clone works, and then walking through a simple example of creating a clone from a live database. Read more

SQL Clone Quick Tip: Offloading DBCC checks

If you guard against database corruption by restoring backups to secondary server, licensed as per production, and then running DBCC CHECKDB integrity checks, then you might save a lot of restore time, and disk space, by offloading this task to a clone. Read more

How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory

Describing SQL Compare's built-in Active Directory Authentication mode, which makes it easier and more secure to, for example, deploy schema changes from version control to an Azure SQL Database. Read more

How to record T-SQL execution times using a SQL Prompt snippet

Phil Factor shares a SQL Prompt snippet called timings, which he uses as a standard testbed for getting execution times for procedures and functions. Read more

SQL Monitor Quick Tip: Using the SQL static code analysis performance rules

This quick tip illustrates SQL Monitor's built-in set of Performance Rules for static code analysis. These rules are designed to highlight SQL syntax that could potential cause performance problems, and so indicate ways to improve the overall quality and performance of the workload, over time. Read more

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

Database provisioning from backups using SQL Clone

A step-by-step guide to creating an image from a database full backup, or from a full backup plus differential backup. Read more

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

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. Phil Factor shows how to control this behavior, for the times when you need it to be a little less intrusive, such as when working through more intricate coding problems that require careful thought. Read more

Using multiple custom SQL formatting styles in SQL Prompt

Louis Davidson shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease. Read more

Redgate Test Data Manager

Redgate Flyway

Redgate Monitor

Overview

Protect

Automate

Monitor

Product articles