Basic Defence Database Programming Techniques

How to go about producing resilient TSQL code that works, and carries on working under stress.

Read the Article

You may also like

eBook

The Redgate Guide to SQL Server Team-based Development

This book shows how to use a mixture of home-grown scripts, native SQL Server tools, and Redgate tools to successfully develop database…

Video

How to split a column without data loss with migration scripts in SQL Server Management Studio

Technical author Owen Priestley explains how to deploy schema changes that involve data changes safely. He covers how to use migration …

eBook

45 Database Performance Tips for Developers

See the SQL Server performance tips and tricks recommended by some of the smartest minds in the Simple Talk community, including SQL Se…