Redgate Hub

All products

Exploring and Refactoring Databases (20)

All databases

All levels

SQL Prompt logo

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

How to qualify object names, standardize the use of aliases, and make other instant changes that improve the quality and performance of your SQL code. Read more

SQL Prompt logo

Driving up database coding standards using SQL Prompt

A strategic view of how a development team can use SQL Prompt to establish and share coding standards, through code analysis rules, formatting styles and code snippets. Read more

SQL Prompt logo

How to Test SQL Server Functions and Procedures using SQL Prompt

Phil Factor shows how to create a table of input values versus expected results, and then use it to unit test your SQL stored procedures and functions and verify that they always produce the correct results. He uses SQL Prompt to make this task much simpler. Read more

SQL Prompt logo

Why your Development team needs SQL Prompt

While everyone knows SQL Prompt for its code completion and IntelliSense features, a lot of its extra value comes from features that allow the development team to standardize coding practices and drive up code quality. Read more

SQL Prompt logo

A day in the life of a developer with SQL Prompt

Write, refine, format and test a reporting query before lunch then refactor a database, and retest the new design, afterwards. All in a day's work for a developer armed with SQL Prompt. Read more

SQL Prompt logo

The SQL Prompt Functionality Finder

You have SQL Prompt, but are you aware of all the things it can do and how to get it to do it? Phil Factor provides a handy table to make it obvious. Read more

SQL Prompt logo

3 Results Grid features SQL Prompt brings to SSMS

SQL Prompt logo

SQL Prompt

Quick SQL Prompt tip – script objects as ALTER in two clicks

SQL Prompt logo

Quickly rename variables all at once with SQL Prompt

Grant Fritchey demonstrates a quick and easy way to rename all variables in a SQL script. Read more

SQL Prompt logo

Cleaning up common T-SQL coding issues with SQL Prompt

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

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

Driving up database coding standards using SQL Prompt

How to Test SQL Server Functions and Procedures using SQL Prompt

Why your Development team needs SQL Prompt

A day in the life of a developer with SQL Prompt

The SQL Prompt Functionality Finder

3 Results Grid features SQL Prompt brings to SSMS

Quick SQL Prompt tip – script objects as ALTER in two clicks

Quickly rename variables all at once with SQL Prompt

Cleaning up common T-SQL coding issues with SQL Prompt

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