Redgate Hub

Product: SQL Prompt

Write, format, and refactor SQL effortlessly

All topics

All databases

All levels

SQL Prompt logo

Managing, Editing and Comparing SQL Code Analysis Settings

If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed. Read more

SQL Prompt logo

How to Compare Two SQL Prompt Styles

A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code. Read more

SQL Prompt logo

Creating and Maintaining a SQL Code Snippet Library

How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard. Read more

Flyway logo

Creating Idempotent DDL Scripts for Database Migrations

How to write idempotent DDL scripts that Flyway can run several times on a database, such as after a hotfix has already been applied directly to the production database, without causing errors. Read more

SQL Prompt logo

Sharing SQL Code Snippets with Coworkers, The World and Yourself

Louis Davidson explains how he manages and shares several different sources of SQL Prompt code snippets, in a single Snippet library, using Dropbox and source control. Read more

SQL Prompt logo

Managing SQL Snippet Collections using JSON and PowerShell

Maintain your favorite SQL snippets and queries centrally, using PowerShell to save and update each snippet collection, in JSON, and then converting them into SQL code snippets for SQL Prompt. Read more

SQL Prompt logo

Managing Cross-Database Object References (EI016, EI026, EI027)

Phil Factor explains cross database and cross-server references, how to find them in your code, and when it's better to avoid hard-coding these references and use synonyms instead. Read more

SQL Prompt logo

Creating a SQL Code Snippet in SQL Prompt and SSMS

Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets. Read more

SQL Prompt logo

Questions about SQL Prompt you were too shy to ask

Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool to find other nuggets of hidden treasure. Read more

SQL Prompt logo

SQL IntelliSense and Autocomplete in SSMS

Phil Factor reviews the major features of SSMS IntelliSense and autocomplete and then explains how SQL Prompt fills in the gaps, and how to use to use the two in tandem to 'get the best of both worlds'. Read more

Previous Next

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

Product: SQL Prompt

Managing, Editing and Comparing SQL Code Analysis Settings

How to Compare Two SQL Prompt Styles

Creating and Maintaining a SQL Code Snippet Library

Creating Idempotent DDL Scripts for Database Migrations

Sharing SQL Code Snippets with Coworkers, The World and Yourself

Managing SQL Snippet Collections using JSON and PowerShell

Managing Cross-Database Object References (EI016, EI026, EI027)

Creating a SQL Code Snippet in SQL Prompt and SSMS

Questions about SQL Prompt you were too shy to ask

SQL IntelliSense and Autocomplete in SSMS

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

Product: SQL Prompt

Cookies on red-gate.com