Redgate Hub

Database: SQL Server

All products

All topics

All levels

Redgate Test Data Manager logo

Test Data Manager: One-click deployment on AWS cloud

Deploy Redgate Test Data Manager into your own AWS account with a single CloudFormation click. Get a secure, production-ready environment for classifying, masking, and subsetting database copies in under 30 minutes, no infrastructure project required. Read more

Control your dependencies in Flyway Desktop for Oracle and SQL Server Databases

SQL Prompt logo

SQL Prompt AI Versus Smart Quotes

SQL Prompt AI can repair certain types of broken SQL almost instantly, saving hours of clean-up time. Just prompt it clearly, check the results are exactly what you intended, and you're ready to run. Read more

Redgate Monitor logo

Cut SQL Server Licensing and Cloud Costs by Monitoring CPU Overallocation

Avoid paying for unused CPU power, on-prem or in the cloud. This guide shows how to use Redgate Monitor to identify overprovisioned SQL Server VMs, reduce licensing and compute costs, and ensure your workloads still run smoothly. Read more

Redgate Test Data Manager logo

Deterministic Data Masking in Redgate Test Data Manager

Redgate Test Data Manager is designed to provide secure, anonymized, and representative copies of production databases. This article focuses on the role of deterministic data masking, transforming PII consistently across tables, even when no logical relationship exists between them, and explains how it works. Read more

Flyway logo

The Importance of Access Checks and Controls in Database Development

This article illustrates the importance in any database development project of a 'multi-layered' approach to database access controls and security checks, based on the Principle of Least Privilege. It describes a security incident that was raised when databases related to a local development project were found to have been erroneously… Read more

Flyway logo

How to Manage Static Data in Existing Flyway Projects

How do we capture static data in our Flyway projects, and then track and deploy any changes to it, while also ensuring that our automated deployment process doesn't try to deploy static data to databases where it already exists, such as the production database? For new Flyway projects, it's quite… Read more

Flyway logo

Using SSDT and DACPACs with Flyway: a Demonstration

The aim of this article is simply to demonstrate that you can use two DACPAC files, representing the source and target versions of a SQL Server database, to create a migration file that can then be used in Flyway. Read more

SQL Toolbelt Essentials logo

The Essential Tools for Standardizing SQL Server Database Development

To achieve rapid delivery of database functionality, database development must both support craftsmanship and incorporate the ideas of standardization and automation that allow for 'mass production'. This article explains how to achieve this 'balance' using the specialist database development tools in SQL Toolbelt Essentials. These tools allow database experts to… Read more

Flyway logo

Flyway for SQL Server Data Tools Users

If you are using SSDT for authoring, building, debugging, and publishing a database project, how do you change to, or preferably migrate towards, a Flyway-based database development? Flyway doesn't need to replace any code part of SSDT, but if allowed to manage every release candidate, it does allow for much… Read more

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Hub

Database: SQL Server

Test Data Manager: One-click deployment on AWS cloud

Control your dependencies in Flyway Desktop for Oracle and SQL Server Databases

SQL Prompt AI Versus Smart Quotes

Cut SQL Server Licensing and Cloud Costs by Monitoring CPU Overallocation

Deterministic Data Masking in Redgate Test Data Manager

The Importance of Access Checks and Controls in Database Development

How to Manage Static Data in Existing Flyway Projects

Using SSDT and DACPACs with Flyway: a Demonstration

The Essential Tools for Standardizing SQL Server Database Development

Flyway for SQL Server Data Tools Users

2025 Stand der Datenbank-Landschaft

Einführung in PostgreSQL für den Datenprofi

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Database: SQL Server

Cookies on red-gate.com