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:

http://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

Comments (6)

  1. Durval Ramos says:

    Congrats Saeid!!!

    You made an excellent presentation

  2. Saeid Hasani says:

    Thanks Andy!
    Thank you Ed for sharing this! 🙂

  3. You’re welcome, Saeid! Thanks for doing the presentation!

  4. Andy ONeill says:

    I’m definitely going to have to make the time to watch this one.
    Somehow.
    Most of my sql server experience is pre ummmmm.
    Fairly dated now.
    I need to brush up on some of that stuff.
    Right after I….

  5. Right after you…

    Forget what you were going to do? =^)

    Really, Saeid did an amazing job with this!

  6. Great presentation!! Thanks Saeid for your great contribution to the forums.

Skip to main content