Redgate Hub

Product: SQL Prompt

Write, format, and refactor SQL effortlessly

All topics

All databases

All levels

SQL Prompt logo

One-click SQL Prompt Using a Stream Deck

SQL Prompt is full of features that make it easier to write and maintain SQL, improve code quality, and keep team coding standards consistent. But when you're busy writing code, can you always remember the shortcut you need, right when you need it? If not, a Stream Deck can turn… Read more

SQL Prompt logo

Mastering AI Prompts: How to Get the Best Out of SQL Prompt AI

Most frustrations with AI tools stem from unclear prompts. This article uses realistic SQL examples to show how to get more predictable, useful results with SQL Prompt AI in day-to-day work, from writing reporting queries to improving the performance of existing SQL. Read more

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

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

SQL Prompt logo

SQL Prompt Safety Net Features for SSMS: Tab Coloring

The Tab Coloring component of SQL Prompt’s SSMS Tab management could save you from accidentally doing something apocalyptic on a production server, ever again. Read more

SQL Prompt logo

Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform

SQL Prompt users can now share formatting style or code snippets in designated Team spaces on the Redgate Platform. Louis Davidson explains how it works. Read more

SQL Prompt logo

Exploring New SQL Prompt Features in SQL Toolbelt and SQL Toolbelt Essentials

Roseanna Whitelegg explores new SQL Prompt functionality that has been added to SQL Toolbelt and SQL Toolbelt Essentials to help teams increase their productivity, improve code quality, and make collaboration easier. Read more

SQL Prompt logo

Bulk Formatting of the SQL Server SQL Files

How to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch. Read more

SQL Prompt logo

SQL Prompt ALT S Magic

Use the SQL Prompt Command Palette to find and execute 'hidden' SQL Prompt functionality, plus any of the common SSMS commands, as well as search for database objects. Read more

SQL Prompt logo

Exploring Auto-fix in SQL Code Analysis

Phil Factor presents a useful but slightly flawed 'table report' script as an adventure playground for exploring SQL Code analysis issues. He demonstrates use of the auto-fix feature, to arrive at a pristine script free from wavy green underlines. Read more

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

Product: SQL Prompt

One-click SQL Prompt Using a Stream Deck

Mastering AI Prompts: How to Get the Best Out of SQL Prompt AI

SQL Prompt AI Versus Smart Quotes

The Importance of Access Checks and Controls in Database Development

SQL Prompt Safety Net Features for SSMS: Tab Coloring

Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform

Exploring New SQL Prompt Features in SQL Toolbelt and SQL Toolbelt Essentials

Bulk Formatting of the SQL Server SQL Files

SQL Prompt ALT S Magic

Exploring Auto-fix in SQL Code Analysis

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

Product: SQL Prompt

Cookies on red-gate.com