Product learning

Posts by

Louis Davidson

24 April 2022

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

23 February 2021

23 February 2021

Reusing Query Results in SSMS

Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove... Read more

5 November 2020

5 November 2020

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

Louis Davidson

25 June 2020

Louis Davidson

25 June 2020

SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies

Louis Davidson provides a pair of SQL Prompt snippets that will help you deal with dependencies, whenever you need to drop columns or tables. Read more

11 February 2020

11 February 2020

Using SQL Prompt Code Snippets for Repetitive Tasks

Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries. Read more

13 November 2019

13 November 2019

Finding Correlated Rows Using EXISTS or COUNT

Should you always use EXISTS rather than COUNT when checking for the existence of any correlating rows that match your criteria? Does the former really offer "superior performance and readability". Louis Davidson investigates. Read more

23 April 2019

23 April 2019

Refactoring Databases with SQL Prompt

Louis Davidson demonstrates how SQL Prompt can significantly lessen the pain involved in occasional, 'heavyweight' database refactoring processes, such as renaming modules, tables and columns (Smart Rename), or splitting tables (Split Table). Read more

Louis Davidson

27 March 2019

Louis Davidson

27 March 2019

Refactoring a Batch or Object with SQL Prompt

Louis Davidson reveals some useful Prompt features for refactoring individual code blocks or modules during development, which will improve code quality, reduce tedium, make testing simpler, or sometimes all three. Read more

Louis Davidson

9 January 2019

Louis Davidson

9 January 2019

How to Apply Non-Standard SQL Formatting Using SQL Prompt

SQL Prompt not only will format your code exactly as you want, but will also help you switch quickly to an alternative style, or to apply exceptions to certain parts of a SQL script, where your preferred style isn't what's required. Read more

SQL code formatting

Louis Davidson

14 March 2018

Louis Davidson

14 March 2018

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

How to qualify object names, standardize the use of aliases, and make other instant changes that improve the quality and performance of your SQL code. Read more

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product learning

Posts by

Louis Davidson

Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform

Reusing Query Results in SSMS

Sharing SQL Code Snippets with Coworkers, The World and Yourself

SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies

Using SQL Prompt Code Snippets for Repetitive Tasks

Finding Correlated Rows Using EXISTS or COUNT

Refactoring Databases with SQL Prompt

Refactoring a Batch or Object with SQL Prompt

How to Apply Non-Standard SQL Formatting Using SQL Prompt

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Posts by Louis Davidson

Posts by

Louis Davidson