Product learning

Posts by

Louis Davidson

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

Louis Davidson

11 February 2020

2 Comments

Louis Davidson

11 February 2020

2 Comments

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

Louis Davidson

13 November 2019

2 Comments

Louis Davidson

13 November 2019

2 Comments

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

Louis Davidson

23 April 2019

Louis Davidson

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

Louis Davidson

12 June 2018

4 Comments

Louis Davidson

12 June 2018

4 Comments

SQL Prompt Hidden Gems: The SSMS Results Pane

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 hidden Prompt gems (Open in Excel,... Read more

Louis Davidson

14 March 2018

Louis Davidson

14 March 2018

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

Louis Davidson explains how he uses the SQL Prompt refactoring 'Actions' to qualify object names, standardize the use of aliases, and make other instant changes that improve the overall quality of his SQL code. Read more

Louis Davidson

17 November 2017

Louis Davidson

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

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product learning

Posts by

Louis Davidson

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

SQL Prompt Hidden Gems: The SSMS Results Pane

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

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

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Posts by Louis Davidson

Posts by

Louis Davidson