Defensive Database Programming with SQL Server



Download free course Defensive Database Programming with SQL Server, pdf file on 389 pages by Alex Kuznetsov.
Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.

Too often as developers, we stop work as soon as our code passes a few basic tests to confirm that it produces the 'right result' in a given use case. We do not stop to consider what other possible ways in which the code might be used in the future, or how our code will respond to common changes to the database environment, such as a change in the database language setting, or a change to the nullability of a table column, and so on.

In the short-term, this approach is attractive; we get things done faster. However, if our code is designed to be used for more than just a few months, then it is very likely that such changes can and will occur, and the inevitable result is broken code or, even worse, code that silently starts to behave differently, or produce different results. When this happens, the integrity of our data is threatened, as is the validity of the reports on which critical business decisions are often based. At this point, months or years later, and long after the original developer has left, begins the painstaking process of troubleshooting and fixing the problem.

Would it not be easier to prevent all this troubleshooting from happening? Would it not be better to spend a little more time and effort during original development, to save considerably more time on troubleshooting, bug fixing, retesting, and redeploying?

This is what defensive programming is all about: we learn what can go wrong with our code, and we proactively apply this knowledge during development. This book is filled with practical, realistic examples of the sorts of problems that beset database programs, including:
- Changes in database objects, such as tables, constraints, columns, and stored procedures
- Changes to concurrency and isolation levels
- Upgrades to new versions of SQL Server
- Changes in requirements
- Code reuse
- Problems causing loss of data integrity
- Problems with error handling in T-SQL

In each case, it demonstrates approaches that will help you understand and enforce (or eliminate) the assumptions on which your solution is based, and to improve its robustness. Ultimately, the book teaches you how to think and develop defensively, and how to proactively identify and eliminate potential vulnerabilities in T-SQL code.

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
  • Concurrent Queries and Transaction Isolation Levels
  • Developing Modifications that Survive Concurrency
Pages : 389
Size : 8.6 MB
File type : PDF
Downloads: 114
Created: 2022-02-02
License: For personal or educational use
Author(s): Alex Kuznetsov
Defensive Database Programming with SQL Server

Others programming Tutorials

Professor Frisby's Mostly Adequate Guide to Functional Programming

Principles of Programming Languages

Programming Persistent Memory

OOP - Learn Object Oriented Thinking and Programming

Certified Programming with Dependent Types

Others related eBooks about Defensive Database Programming with SQL Server

Spring MVC Framework

Download a free training document material about the Framework Spring MVC ,this pdf tutorial is a complet reference guide to Spring Framework features under 904 pages designated to all student level....

Android video game tutorial

With this tutorial you will learn how to create an android video game and the basics of android applications development, free training document on 34 pages by Nikhil Yadav....

Introduction to (Java Server Page) JSF

With this PDF tutorial you will learn how to write Your own JSF Components.Free training document for download....

Think Python: An Introduction to Software Design

Python for Software Design is a concise introduction to software design using the Python programming language. Intended for people with no programming experience, this book starts with the most basic concepts and gradually adds new material. Some of the ideas students find most challenging, like r...

Fortran 90 for Beginners

Download free Fortran 90 Programming language course material, tutorial training, a PDF file by Tadziu Hoffmann & Joachim Puls....

Graph Algorithms

Learn how graph algorithms can help you leverage relationships within your data to develop..., download free Algorithms tutorial in PDF (256 pages) created by Mark Needham ....

Learning iOS eBook (PDF)

Download free IOS tutorial course material and training in PDF file 1131 pages....

Essential Android

This book written to provide clear and concise explanation of topics for programmers both starting to learn the Android programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

Essential Ruby On Rails

This book written to provide clear and concise explanation of topics for programmers both starting to learn the Ruby On Rails programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

Data Parallel C++

Learn how to accelerate C++ programs using data parallelism. This open book enables C++ programmers to be at the forefro.....