Robust Transact-SQL coding practices dictate proactive planning for anticipated and unanticipated errors that might occur during code module execution. SQL Server’s flavor of Transact-SQL provides several commands that can be used to properly handle errors in your code and this course will cover the fundamental commands you’ll need to know, as well as effective error handling techniques that will help you properly handle issues for high throughput, mission-critical data tiers. This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward, with some emphasis on new SQL Server 2012 commands.
Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL
Database product team at Microsoft, with a focus on query processing. With
over 19 years of experience in the industry, Joe is an author and speaker,
specializing in performance tuning and optimization.