Establishing T-SQL Formatting Standards in Your Organization

Jared Kuehn

Ever been asked to update a SQL query for performance or business reasons, only to spend two days just trying to read what you were sent?

The blessing and curse of the SQL language is that it offers flexibility in formatting, and coding standards for the language are loosely defined. So how do we prevent the above scenario from occurring?

In this session, I’ll showcase a formatting standard that not only make SQL SELECT queries easier to read, but also provide functional benefits when modifying queries. This will include base queries and supporting CTEs. Finally, I’ll showcase how certain Copilots can help when trying to establish coding standards in SQL.