Redgate logo
  • Products
    • All products
    • Redgate Flyway
    • Redgate Monitor
    • Redgate Test Data Manager
    • SQL Toolbelt Essentials
    • SQL
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • Redgate Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
    • .NET
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Performance Profiler
      • ANTS Memory Profiler
      • SmartAssembly
    • All products
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Memory Profiler
      • ANTS Performance Profiler
      • Data Compare for Oracle
      • Data Masker
      • Redgate Flyway
      • Redgate Test Data Manager
      • Schema Compare for Oracle
      • SmartAssembly
      • Source Control for Oracle
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • Redgate Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
      • SQL Toolbelt Essentials
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Protect
      • Automate
      • Monitor
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • U.S. Federal
      • Australian Government
      • Healthcare
      • Managed Service Providers (MSP)
    • Case studies
    • Insights
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Newsroom
    • Leadership
  • Support
  • Learning & community
    • Learning & community | Redgate Hub
    • Product articles
    • University
    • Events
    • Forums
    • Community
    • Simple Talk
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart
  • Products
    • All products
    • Redgate Flyway
    • Redgate Monitor
    • Redgate Test Data Manager
    • SQL Toolbelt Essentials
    • SQL
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • Redgate Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
    • .NET
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Performance Profiler
      • ANTS Memory Profiler
      • SmartAssembly
    • All products
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Memory Profiler
      • ANTS Performance Profiler
      • Data Compare for Oracle
      • Data Masker
      • Redgate Flyway
      • Redgate Test Data Manager
      • Schema Compare for Oracle
      • SmartAssembly
      • Source Control for Oracle
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • Redgate Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
      • SQL Toolbelt Essentials
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Protect
      • Automate
      • Monitor
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • U.S. Federal
      • Australian Government
      • Healthcare
      • Managed Service Providers (MSP)
    • Case studies
    • Insights
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Newsroom
    • Leadership
  • Support
  • Learning & community
    • Learning & community | Redgate Hub
    • Product articles
    • University
    • Events
    • Forums
    • Community
    • Simple Talk
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart

Redgate Test Data Manager

Improve your release quality and reduce your risk, with the flexibility to fit your workflow

Redgate Flyway

Bring stability and speed to database deployments

Redgate Monitor

Understand server performance in an instant with fast deep-dive analysis

See all our products

Overview

Redgate's end-to-end Database DevOps solutions

Protect

Reliable test data management, automating repetition out of the process

Automate

Automate and accelerate your database change management workflow

Monitor

Monitor your cross-database, multi-platform estate to ensure optimal performance

NEW REPORT 2025 State of database landscape cover

2025 State of the Database Landscape − download the report

Redgate Hub

  • Product articles
  • University
  • Events
  • Forums
  • Community
  • Simple Talk

Product articles
SQL Prompt
Exploring and Refactoring Databases

  • SQL Prompt
  • SQL Code Completion and IntelliSense
  • SQL Code Analysis

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
  • Query Performance
  • SQL Formatting and Styles

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
  • SQL Formatting and Styles
  • Exploring and Refactoring Databases

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
  • Exploring and Refactoring Databases

3 Results Grid features SQL Prompt brings to SSMS

You may not have heard about it yet, but three helpful features were recently added to SQL Prompt that are activated when you right-click on the Results Grid in SQL Server Management Studio (SSMS). 1. Copy as IN clause This feature is available when you have values from a single column selected. You can select Read more

  • SQL Prompt
  • SQL Prompt

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

Working in a large database can be difficult at times. While many of us might learn the meanings and definitions of most objects, it’s easy to forget the exact ways in which some objects work, or what the behavior is in certain calls. This is one place where having tools that assist you like SQL Read more

  • SQL Prompt
  • SQL Prompt

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
  • Exploring and Refactoring Databases

Cleaning up common T-SQL coding issues with SQL Prompt

Some SQL coding habits are just annoying. Commas in front of column names? No way! Others are actively harmful; they’ll make your code error prone, harder for others to read and understand, and even harder to edit without making mistakes. This article covers five harmful problems that I see regularly in T-SQL code, and shows Read more

Products

  • SQL Dependency Tracker
  • SQL Prompt
  • SQL Search
  • SQL Toolbelt Essentials

Filter by level

Previous
  • 1
  • 2

Redgate Hub

  • Product Articles

    Product Articles

    Tips and how-to guides for Redgate products

  • University

    University

    Easy to follow video courses

  • Events

    Events

    Join us online, or get sponsored

  • Forums

    Forums

    Ask, discuss, and solve questions about Redgate's tools

  • Community

    Community

    Develop your skills and meet Redgate Advocates and Friends

  • Simple Talk

    Simple Talk

    In-depth articles and opinion from Redgate's technical journal

Products

  • Standardize
  • Automate
  • Monitor
  • Test Data Management

Support

  • Forums
  • Contact product support
  • Find my serial numbers
  • Download older versions

Solutions

  • Overview
  • Protect
  • Automate
  • Monitor
  • Maturity Assessment

Our Company

  • Careers
  • Contact us
  • Redgate Blog
  • Our values

Community & Learning

  • Product Learning
  • University
  • Events & Friends
  • Simple Talk
  • Books
  • Forums

Partners

  • SQL Server Central
  • Resellers
  • Consulting partners

Trust Center

  • License agreement
  • Privacy and cookies
  • Modern slavery statement
  • CCPA - Limit the use of my sensitive personal data / do not sell my data

Follow us

Redgate on Twitter Redgate on LinkedIn Redgate on YouTube
  • Copyright 1999 - 2025 Red Gate Software Ltd