119 SQL Code Smells (github)

119 SQL Code Smells is a handy reference guide written with advice, help or contributions from over 25 SQL Server professionals. Discover 119 common SQL code smells, understand why they’re smells and the problems they may cause.

Topics included: Introduction

• Problems with Database Design

• Problems with Table Design

• Problems with Data Types

• Problems with Expressions

• Difficulties with Query Syntax

• Problems with Naming

• Problems with Routines

• Security Loopholes.