Redgate Blog

Posts tagged with SQL Prompt

24 February 2021

SQL Templates and Code Snippets in SSMS and SQL Prompt

Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide. Read more

10 February 2021

10 February 2021

Customer tips for improving productivity with Redgate products

We recently invited our customers to share their top tips for improving productivity in the first Redgate Tool Tips Swap. This post outlines their hints for using Redgate products to boost productivity and includes relevant training resources to further your learning. SQL Prompt Share formatting settings across your team to… Read more

27 June 2018

27 June 2018

Improving legacy code using SQL Prompt code analysis

SQL Prompt code analysis, introduced in v9.2, provides a quick and easy way to assess the overall health and quality of your SQL scripts. It will help the team prevent technical debt from entering the code base, to remove it from existing code during code reviews, and to ensure that… Read more

18 April 2018

18 April 2018

Avoid use of the MONEY and SMALLMONEY datatypes (BP022)

Use of the MONEY and SMALLMONEY datatypes can lead to unintentional loss of precision, due to rounding errors, during calculations. It is generally far better to use the DECIMAL, a.k.a. NUMERIC, type. Read more

23 January 2018

23 January 2018

How to Test SQL Server Functions and Procedures using SQL Prompt

Phil Factor shows how to create a table of input values versus expected results, and then use it to unit test your SQL stored procedures and functions and verify that they always produce the correct results. He uses SQL Prompt to make this task much simpler. Read more

1 December 2017

1 December 2017

How you can improve your SQL with code analysis in SQL Prompt

You could think of SQL Prompt code analysis as a machine-assisted code review. The rules that are used to check your code point out questionable areas that might be missed during regular testing. Read more

17 November 2017

17 November 2017

SQL Prompt Hidden Gem: Auto-fill the GROUP BY clause

Writing GROUP BY clauses is a very common, but tedious, activity for a SQL programmer. SQL Prompt will fill it in for you, with all non-aggregated columns returned by the query. Read more

23 October 2017

23 October 2017

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

Andrei Rusitoru

25 September 2017

Andrei Rusitoru

25 September 2017

How we used your feedback to improve parentheses formatting in SQL Prompt 8.1

After we released SQL Prompt 8, our priority was to continue to support the new formatting engine by fixing any bugs and reviewing feedback from users. One of the recurring patterns we noticed in your feedback regarded parentheses formatting. Some of you told us you couldn’t format the parentheses exactly… Read more

parenthese formatting

SQL Prompt

Phil Factor

18 September 2017

Phil Factor

18 September 2017

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

Intellisense

SQL code formatting

SQL Prompt

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 Blog

Posts tagged with SQL Prompt

SQL Templates and Code Snippets in SSMS and SQL Prompt

Customer tips for improving productivity with Redgate products

Improving legacy code using SQL Prompt code analysis

Avoid use of the MONEY and SMALLMONEY datatypes (BP022)

How to Test SQL Server Functions and Procedures using SQL Prompt

How you can improve your SQL with code analysis in SQL Prompt

SQL Prompt Hidden Gem: Auto-fill the GROUP BY clause

A day in the life of a developer with SQL Prompt

How we used your feedback to improve parentheses formatting in SQL Prompt 8.1

The SQL Prompt Functionality Finder

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

Posts tagged with SQL Prompt

Cookies on red-gate.com