In this series, Robert Sheldon introduces you to the basics of working with T-SQL, covering such topics as readability, accuracy, performance, standardization, and other factors. The series in not intended as a prescriptive how-to list that dictates what approaches you should take, but rather as a set of guidelines for evaluating the types of issues you should address when coming up with your own approach to T-SQL coding.

T-SQL Programming

Robert Sheldon in T-SQL Programming

The Basics of Good T-SQL Coding Style – Part 4: Performance

There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse…

31 July 2017 17 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to…

27 June 2017 17 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects

Technical debt is a real problem in database development, where corners have been cut in the rush to keep to…

02 June 2017 22 min read

T-SQL Programming

Robert Sheldon in T-SQL Programming

The Basics of Good T-SQL Coding Style

TSQL Code must work properly and efficiently. That’s not enough though. Unless you are working alone, have perfect memory and…

05 May 2017 20 min read