Redgate Blog

Posts tagged with SQL Prompt

18 January 2017

Faster SQL Server troubleshooting using SQL Prompt snippets

A good DBA will automate repetitive tasks, but sometimes you need to troubleshoot a problem ‘live’, with people standing over you, and the pressure on. This is something that can’t be automated. SQL Prompt snippets have helped me out in this sort of situation numerous times. Built-in SSMS query shortcuts… Read more

SQL Prompt

Grant Fritchey

30 November 2016

Grant Fritchey

30 November 2016

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

Steve Jones

18 November 2016

Steve Jones

18 November 2016

Quick SQL Prompt tip – using the CDB snippet

SQL Prompt includes a number of snippets by default that can help you quickly write T-SQL code. These are templates of code that users use regularly. One of the more popular snippets is the ‘cdb’ snippet that helps with quickly creating a new database for development work. This can also… Read more

SQL Prompt

Carly Meichen

19 October 2016

Carly Meichen

19 October 2016

5 shortcuts in SQL Prompt you didn’t know about

When writing SQL, you can use SQL Prompt to quickly jump to some really handy formatting and refactoring actions. This little button right here is called the Actions List and it contains over 20 functions and snippets you can use in just a few keystrokes. Simply highlight your block of… Read more

SQL Prompt

Grant Fritchey

3 October 2016

Grant Fritchey

3 October 2016

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… Read more

SQL Prompt

Steve Jones

27 September 2016

Steve Jones

27 September 2016

Quick SQL Prompt tip – using the ii snippet

SQL Prompt includes a number of snippets by default that can help you quickly write T-SQL code. These are templates of code that users use regularly. One of the more popular snippets is the “ii” snippet that helps with inserting data into a table. If I type “ii” and hit… Read more

SQL Prompt

David Atkinson

21 September 2016

David Atkinson

21 September 2016

How to format a set of SQL scripts using SQL Prompt

Any database developer or DBA who spends much of their working week staring at SQL code quickly becomes set in their ways. They like to see the code laid out in a very particular way. They will struggle to look at, let alone digest and understand, code formatted in a… Read more

SQL Prompt

Steve Jones

14 September 2016

Steve Jones

14 September 2016

Quick SQL Prompt tip – why you should expand the wildcard

One of the great things about SQL Prompt is that it quickly removes the need to use so many keystrokes. That’s helpful and handy, but to become a really efficient T-SQL coder, you’ll want to practice incorporating a few tricks into your routine. Here’s a good one. Often I run… Read more

SQL Prompt

Carly Meichen

28 April 2016

Carly Meichen

28 April 2016

SQL Prompt 7.2 released – SQL Server Management Studio 2016 support & new features

We’ve just released SQL Prompt 7.2 with new SSMS 2016 support, features and fixes. If you’re new to SQL Prompt try it for free. If you already use it, just ‘check for updates’ in SQL Prompt to upgrade to the new version. For more detail on what’s new, read on.… Read more

SQL Prompt

Alasdair Daw

26 August 2015

Alasdair Daw

26 August 2015

SQL Prompt 7’s new snippet manager

During the development of SQL Prompt 7, we overhauled the snippet manager to make it more powerful and customizable. The snippet manager documentation lives here but there are some subtleties that I wanted to cover in in this post. Everyone writes SQL differently and we want SQL Prompt to work… Read more

snippet manager

SQL Prompt

Previous Next

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 Blog

Posts tagged with SQL Prompt

Faster SQL Server troubleshooting using SQL Prompt snippets

Quickly rename variables all at once with SQL Prompt

Quick SQL Prompt tip – using the CDB snippet

5 shortcuts in SQL Prompt you didn’t know about

Cleaning up common T-SQL coding issues with SQL Prompt

Quick SQL Prompt tip – using the ii snippet

How to format a set of SQL scripts using SQL Prompt

Quick SQL Prompt tip – why you should expand the wildcard

SQL Prompt 7.2 released – SQL Server Management Studio 2016 support & new features

SQL Prompt 7’s new snippet manager

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

Posts tagged with SQL Prompt

Cookies on red-gate.com