TNWikiSummit15 Presentation: Error Handling in SQL Server 2012 and 2014

Let's dig into another session from last week's TechNet Wiki International Summit 2015!

 

Error Handling in SQL Server 2012 and 2014

Using Error Handling within the Transact SQL language needs a deep knowledge. It depends on the SQL Server version, there are various implementations for handling the errors in T-SQL. But if you use SQL Server 2012 or later versions, you can use the simplest and fully structured error handling.

Saeid Hasani showed how to implement such simple error handling in T-SQL. He showed this topic from a problem solving approach and particularly in SQL Server 2012 and the later versions. In this session, he covered some questions to providing a step by step tutorial for designing a structured error handling mechanism in SQL Server. 

This session is available for download using the following links:

Video:                                     

https://gallery.technet.microsoft.com/TN-Summit15-Structured-dfdcb9a5

 

PowerPoint:

https://gallery.technet.microsoft.com/TN-Summit15-Structured-118896bb

 

 

 

Original TN Wiki Article:

https://social.technet.microsoft.com/wiki/contents/articles/20002.structured-error-handling-mechanism-in-sql-server-2012.aspx

                                                                                                                                                    

Judges’ comments for the article are from TechNet GURU Awards - September 2013 :

 

Richard Mueller:

"Useful tutorial with lots of examples and very good links. Excellent comparison of THROW and RAISERROR." 

Jinchun Chen:

"Nice article. Thank you for the sharing."

Ed Price:

"Incredibly well formatted with images, code, and explanations. And great interactions in the comments, making the improvements suggested by Naomi. " 

DB:

"Useful, clear and accurate guidance on error handling" 

Samuel Lester:

"Great coverage of different techniques, challenges, pros/cons. Well done, very informative, and easy to read."

 

 

Thanks to Saeid for a great presentation on SQL Error Handling!

 

   - Ninja Ed