Home / Education / Dbas are you being too defensive again?

Dbas are you being too defensive again?

On October 25, 2018

At 4:03 pm

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.

defensive programming

BUSINESS	CITY JOB RESOURCES	MIDWEST JOB RESOURCES	SOUTH JOB RESOURCES	WEST JOB RESOURCES
Industrial Supply Deals	Chicago Job Resource	Kansas Job Resource	Alabama Job Resource	Alaska Job Resource
Office Supply Deals	Washington, DC Job Resource	Illinois Job Resource	Arkansas Job Resource	Arizona Job Resource
EDUCATION	SPECIAL JOB RESOURCES	Indiana Job Resource	Delaware Job Resource	California Job Resource
Back To School Mall	Diversity Job Resource	Iowa Job Resource	Florida Job Resource	Colorado Job Resource
SHOPPING	First Job Resource	Michigan Job Resource	Georgia Job Resource	Hawaii Job Resource
Health Care and Fitness	Freelance Job Resource	Minnesota Job Resource	Kentucky Job Resource	Idaho Job Resource
Just Best Gifts	Intern Job Resource	Missouri Job Resource	Louisiana Job Resource	Montana Job Resource
Just Clearance Sales	Seasonal Job Resource	Nebraska Job Resource	Maryland Job Resource	Nevada Job Resource
Just Comparison Shopping	Senior Job Resource	North Dakota Job Resource	Mississippi Job Resource	New Mexico Job Resource
Just Outlets	Volunteer Job Resource	Ohio Job Resource	North Carolina Job Resource	Oregon Job Resource
Luxury Matters	TARGETED JOB RESOURCES	South Dakota Job Resource	Oklahoma Job Resource	Utah Job Resource
Tradin Stuff	Blue Collar Job Resource	Wisconsin Job Resource	South Carolina Job Resource	Washington Job Resource
Value Buyers	Executive Job Resource	NORTHEAST JOB RESOURCES	Tennessee Job Resource	Wyoming Job Resource
TECHNOLOGY	Finance Job Resource	Connecticut Job Resource	Texas Job Resource
FrontPage Help	Healthcare Job Resource	Maine Job Resource	Virginia Job Resource
MCDBA Directory	IT Job Resource	Massachusetts Job Resource	West Virginia Job Resource
Retired DBA	Pink Collar Job Resource	New Hampshire Job Resource
SQL Server Directory	Sports Job Resource	New Jersey Job Resource
Transact SQL Directory	White Collar Job Resource	New York Job Resource
		Pennsylvania Job Resource
		Rhode Island Job Resource
		Vermont Job Resource

Dbas are you being too defensive again?

Advertisers

Programmer Solutions Inc Websites

BUSINESS

CITY JOB RESOURCES

MIDWEST JOB RESOURCES

SOUTH JOB RESOURCES

WEST JOB RESOURCES

EDUCATION

SPECIAL JOB RESOURCES

SHOPPING

TARGETED JOB RESOURCES

NORTHEAST JOB RESOURCES

TECHNOLOGY