Redgate Blog

Posts tagged with SQL Prompt

1 June 2017

How to style your SQL using SQL Prompt’s new formatting options

The ability to customize and refine formatting options has long been a feature of SQL Prompt. In the eighth major update to the tool, we’ve introduced a brand new formatting engine that lets you manage your formatting options like never before. Not only can you set your style exactly how… Read more

SQL Prompt

Louis Davidson

3 April 2017

Louis Davidson

3 April 2017

How to implement a T-SQL code formatting standard using SQL Prompt

To what extent should a team attempt to impose a uniform SQL coding format? It can sometimes seem like a futile task. All programmers have a preferred formatting style, to which they profess an unwavering attachment. Check the code of ten programmers, though, and you will likely discover at least… Read more

20 March 2017

20 March 2017

SQL Prompt to the rescue with tab coloring

When you’re hard at work, it’s all too easy to make a mistake as you rush to get a job done. Say, for example, you have a QA database you need to get rid of. You run a query to drop it and then… oh no! You’ve accidentally run it… Read more

16 March 2017

16 March 2017

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

SQL Prompt

SSMS Results Grid

Tom Crossman and Andrei Rusitoru

8 March 2017

Tom Crossman and Andrei Rusitoru

8 March 2017

How to customize your formatting styles with SQL Prompt Pro

SQL code formatting is a very popular SQL Prompt feature. For many years, it’s done a great job of transforming illegible SQL code into a layout that’s very readable for most users. That said, many users have been asking us for greater control over their formatting styles. Take a browse… Read more

SQL Prompt

Grant Fritchey

6 February 2017

Grant Fritchey

6 February 2017

Quick SQL Prompt tip – restore your tabs, even if you closed them by mistake

It’s sometimes too easy to close SQL Server Management Studio (SSMS) without saving your work. It’s also easy to get rid of tabs and scripts that you later wish you had back. SQL Prompt can help with both these problems. Take a look at the Options for SQL Prompt and… Read more

SQL Prompt

Steve Jones

30 January 2017

Steve Jones

30 January 2017

Quick SQL Prompt tip – picking the columns you need for speedy results

One of the poor practices that I see so many people doing in code is using SELECT *. This is poor practice because it takes more time to complete for clients, it’s an unnecessary use of resources on the client, server and network, and it can fill the buffer cache… Read more

SQL Prompt

Steve Jones

26 January 2017

Steve Jones

26 January 2017

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

SQL Prompt

Brent McCracken

18 January 2017

Brent McCracken

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