Interesting blog about an updated version of a free Redgate booklet by Phil Factor (real name withheld to protect the guilty): SQL Code Smells
Some good points by Phil Factor in these 6 major areas DBAs should be smelling:
- Problems with Database Design
- Problems with Table Design
- Problems with Data Types
- Problems with expressions
- Problems with naming
- Problems with routines
Here’s where to get the latest copy of SQL Code Smells: Learn about common SQL code smells – and see how SQL Prompt can help you find them in your code
DBAs don’t hold your nose to smelly SQL code. Fix your older smelly SQL code now! And only you can prevent new smelly code before you deploy to production.
Advertisement
Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa
Chase Checking - Open your Chase checking account and get a bonus!
Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.
Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.
Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!
Discover - Get a bonus when you open an eligible Discover account.
Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!
Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.
Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.
Xfinity - Open an Xfnity mobile or internet account and get a bonus