Redgate Hub

All products

All topics

All databases

All levels

SQL Change Automation logo

Database Delivery with Docker and SQL Change Automation

Phil Factor demonstrates how to integrate SQL Change Automation into containerized workflows, such as are typical of a microservices architecture. He shows how to automate database builds into a Linux SQL Server container running on Windows, and then backup the containerized database and restore it into dedicated containerized development copies… Read more

SQL Toolbelt logo

A DBA's Journey towards Database DevOps

John Morehouse describes how a quest to help solve his organization's "deployment bottleneck" led them to a place where they could both deliver application and database changes into the wild at a pace to satisfy customer demand, and achieve a better work-life balance for the team, both of which are… Read more

SQL Change Automation logo

Running Linux SQL Server as a Container

Phil Factor starts a series of articles that will demonstrate the use of temporary SQL Server instances, running in Linux containers, into which we can deploy the latest database build, stocked with data, for development and testing work. This initial article shows how to set up a SQL Server instance… Read more

SQL Clone logo

SQL Clone on your Laptop

Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected. Read more

SQL Prompt logo

What's new in SQL Prompt 9.5: SSMS 18 and VS 2019 support, improved suggestions and more

Faris Hilmi presents the highlights of the latest SQL Prompt 9.5 release, including SSMS 18 and VS 2019 support, schema filtering for code completion suggestions, new code analysis auto-fixes and more. Read more

SQL Prompt logo

Refactoring Databases with SQL Prompt

Louis Davidson demonstrates how SQL Prompt can significantly lessen the pain involved in occasional, 'heavyweight' database refactoring processes, such as renaming modules, tables and columns (Smart Rename), or splitting tables (Split Table). Read more

SQL Prompt logo

Insert Statement Without Column List (BP004)

Many production databases have failed embarrassingly as a result of INSERT code that omits a column list, usually in mysterious ways and often without generating errors. Phil Factor demonstrates the problem, and advocates a 'defense-in-depth' approach to writing SQL, in order to avoid it. Read more

SQL Clone logo

SQL Clone for Unit Testing Databases

Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test. Read more

Redgate Monitor logo

Monitoring your Servers and Databases: SCOM and Redgate Monitor

With simple integration, SCOM and Redgate Monitor combine breadth and depth, infrastructure-wide observability plus SQL Server insight. The result is faster incident response, smarter use of DBA time, and monitoring that scales with growth and new technologies. Read more

SQL Change Automation logo

Static Data and Database Builds

Whichever way you wish to ensure that a database, when built, has all the data that will enable it to function properly, there are reasonably simple ways of doing it. Phil Factor explains the alternatives. 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 Test Data Manager

Redgate Hub

Database Delivery with Docker and SQL Change Automation

A DBA's Journey towards Database DevOps

Running Linux SQL Server as a Container

SQL Clone on your Laptop

What's new in SQL Prompt 9.5: SSMS 18 and VS 2019 support, improved suggestions and more

Refactoring Databases with SQL Prompt

Insert Statement Without Column List (BP004)

SQL Clone for Unit Testing Databases

Monitoring your Servers and Databases: SCOM and Redgate Monitor

Static Data and Database Builds

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 Test Data Manager

Cookies on red-gate.com