38f9d00a_Code_Camp_3__Description
[Level] 300 [Title] Best Practices for Structured SQL Server Development [Speaker] Adam Machanic [Type] Presentation [Description] 
Traditionally it has been unnecessary for DBAs to observe development best practices -- and T-SQL certainly provides few constructs to assist those who have tried. As the line between DBA and developer continues to blur, structured database development becomes increasingly important. In this session you will learn best practices for ensuring stored procedure robustness with unit testing, how to implement a T-SQL-based assertion framework, and the basics of handling exceptions in T-SQL, including 2005’s TRY-CATCH syntax. We will also discuss how much onus to put on SQL Server for handling its own exceptions.
Code Camp 3
Description