• Title Defensive Database Programming with SQL Server
• Author(s) Alex Kuznetsov
• Publisher: Red Gate Books (May 31, 2010)
• Paperback 301 pages
• eBook 3.16 MB
• Language: English
• ISBN-10: 190643445X
• ISBN-13: 978-1906434458
• Share This:  

Book Description

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings.

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.

• Alex Kuznetsov has been working with object oriented languages and databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on sqlblog.com, mostly about database unit testing, defensive programming, and query optimization. Alex has written multiple articles on simple-talk.com and devx.com, and contributed a chapter to "MVP Deep Dives" book. Currently he works with DRW Trading Group in Chicago, where he leads a team of developers, practicing agile development, defensive programming, and database unit testing every day. In his leisure time Alex prepares for and runs ultramarathons. .

• Amazon

• Miscrosoft SQL Server
• Sybase SQL Server
• Database, Data Warehouse and Data Management
• Data Management White Papers
• Microsoft Windows and .NET

• Defensive Database Programming with SQL Server (Alex Kuznetsov)

• Learn T-SQL Querying (Pedro Lopes, et al)
• SQL Performance Explained: Everything Developers Need to Know
• SQL Server Concurrency: Locking, Blocking and Row Versioning