Product learning

Posts by

Louis Davidson

I am a SQL Server professional with over 30 years of experience in data modeling, SQL Server coding and internals, and ETL.

I’ve been part of the SQL Server community for many years, as a speaker and writer, and have an equally long-standing enthusiasm for Dollywood and DisneyWorld, as a self-confessed roller coaster addict.

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

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

3 August 2017

3 August 2017

Using multiple custom SQL formatting styles in SQL Prompt

Louis Davidson shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease. Read more

20 June 2017

20 June 2017

The Louis Davidson custom style for SQL Prompt

Louis Davidson sticks his neck out and offers his take on a sensible SQL code formatting style, based on twenty-plus years of writing SQL. Starting from SQL Prompt's Default style, he customizes it based on his own list of personal preferences for how SQL code should look. The result is the Louis Davidson custom... Read more

8 June 2017

8 June 2017

How to implement a SQL formatting standard using SQL Prompt v8

Louis Davidson explains why your team needs a standard style for formatting SQL and how SQL Prompt will help make this happen. Read more

3 April 2017

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 15 different formats, since... Read more

SQL code formatting

SQL Prompt

Product learning

Posts by Louis Davidson

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

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

Using multiple custom SQL formatting styles in SQL Prompt

The Louis Davidson custom style for SQL Prompt

How to implement a SQL formatting standard using SQL Prompt v8

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

Posts by

Louis Davidson