
This is a review of a free e-book at red-gate.com: Defensive Database Programming by Alex Kuznetsov
According to Alex ‘the book teaches you how to think and develop defensively, and how to proactively identify and eliminate potential vulnerabilities in T-SQL code.’
I like the ‘What this book does not cover’ section. Alex explains ‘…the focus of this book is on writing resilient T-SQL code, not on the implementation of unit tests’. And he also says ‘The focus of this book is on very common … less publicized vulnerabilities…’. It does not cover SQL injection attacks that have been written about in many other articles.
Numerous code examples in the ebook can be downloaded (see ebook for URL).
Alex offers many examples of defensive database programming techniques, code vulnerabilities, data object change issues, code breaking from upgrades, reuse of T-SQL code, data integrity problems, etc.
A favorite section of mine is in Chapter 2 ‘SET, SELECT, and the dreaded infinite loop’. The entire Chapter 8 on Defensive Error handling is well worth the read!
Nicely done e-book that will make you smile at least a few times when you see some code that you have fixed in your past. You will learn some new defensive database programming techniques after reading this e-book.
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