Redgate Hub

All products

All topics

All databases

All levels

SQL Prompt logo

Finding Correlated Rows Using EXISTS or COUNT

Should you always use EXISTS rather than COUNT when checking for the existence of any correlating rows that match your criteria? Does the former really offer "superior performance and readability". Louis Davidson investigates. Read more

SQL Clone logo

SQL Clone PowerShell Scripting: The Basics

Phil Factor demonstrates some simple examples of how to use SQL Clone's PowerShell library to pass objects between cmdlets, and simplify common tasks, such as creating and deploying clones from various images. He then documents the objects and cmdlets, and illustrates their inputs and outputs. Read more

SQL Clone logo

Unwrapping, Unboxing and Installing SQL Clone

If you are evaluating a tool such as a text editor or spreadsheet, it is easy: you just install it, you run it, you decide whether you need it. Job done. However, a similar 'unboxing' or 'unwrapping' of SQL Clone, and installing across a network, is not so quick and… Read more

SQL Prompt logo

SQL Productivity with SQL Prompt

SQL Compare logo

SQL Compare 14.0: A Command Line Interface on Linux and support for SQL Server 2019

SQL Change Automation logo

Recreating Databases from Scratch with SQL Change Automation

Phil Factor starts with the basics how to rebuild a set of development database from scratch, using SQL Change Automation, and then demonstrates how to check for any active sessions before rebuilding, import test data using BCP, and secure passwords if connecting to the target with SQL Server credentials. Read more

SQL Compare logo

Using the SQL Compare command line with Argfiles

Phil Factor demonstrates how using XML argfiles to pass parameters to SQL Compare cuts out a lot of the tedious scripting involved in modifying a database schema comparison and deployment process, as required for each target database. Read more

SQL Compare logo

Automating Schema Comparisons with SQL Compare Projects and PowerShell

A simple way of automating SQL Server database schema comparison and deployment tasks for multiple databases, by saving the options and configuration settings for each deployment in a project file and executing them from a PowerShell script. Read more

SQL Compare logo

Comparing and Deploying SQL Server Databases using the SQL Compare Command Line on Linux or Windows

SQL Compare now includes a Linux-based command line interface (CLI), as well as a Windows-based one, for doing schema comparison and deployments of SQL Server databases. This article offers worked examples of CLI scripts for various schema comparison tasks, to get you up and running with either version. Read more

SQL Compare logo

Handling Tricky Data Migrations during State-based Database Deployments

This article demonstrates how to use a 'state' approach to database source control, when the nature of the database changes cause you to hit difficulties with migrating existing data. These difficulties happen when the differences are such that it is impossible for any automated script to make the changes whilst… Read more

Previous Next

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Assistant

Redgate Hub

Finding Correlated Rows Using EXISTS or COUNT

SQL Clone PowerShell Scripting: The Basics

Unwrapping, Unboxing and Installing SQL Clone

SQL Productivity with SQL Prompt

SQL Compare 14.0: A Command Line Interface on Linux and support for SQL Server 2019

Recreating Databases from Scratch with SQL Change Automation

Using the SQL Compare command line with Argfiles

Automating Schema Comparisons with SQL Compare Projects and PowerShell

Comparing and Deploying SQL Server Databases using the SQL Compare Command Line on Linux or Windows

Handling Tricky Data Migrations during State-based Database Deployments

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Assistant

Cookies on red-gate.com