Free 301 page ebook “Defensive Database Programming with SQL Server”, written by Alex Kuznetsov. The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected.
Book Description
Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.
This book describes a lot of specific problems, and typical approaches that will lead to more robust code, However, the main goal is more general: it is to demonstrate how to think defensively, and how to proactively identify and eliminate potential vulnerabilities in T-SQL code during development rather than after the event when the problems have already occurred.
Table of Contents
- Basic Defensive Database Programming Techniques
- Code Vulnerabilities due to SQL Server Misconceptions
- Surviving Changes to Database Objects
- When Upgrading Breaks Code
- Reusing T-SQL Code
- Common Problems with Data Integrity
- Advanced Use of Constraints
- Defensive Error Handling