Sunday Surprise: Let’s catch the errors


There are many great SQL Server articles in TechNet WiKi. The easiest way to find them is to check them from the portals such as Transact-SQL Portal, SQL Server Integration Services Portal, SQL Server Reporting Services Portal, SQL Server 2012 Portal. I suggest you to explore these portals and also, in case you come up upon an article which is not yet added to the appropriate portals, go ahead and add it.

In this blog post I want to introduce two recent additions to SQL Server articles in TechNet WiKi which were inspired by the TechNet Guru Competition.

The first article is a very thorough and comprehensive analysis of SQL Server Error Handling mechanism written by Saeid Hasani Structured Error Handling Mechanism in SQL Server 2012. As you know, the structured error handling mechanism in SQL Server was introduced in SQL Server 2005.  In SQL Server 2012 one important addition was put into the language – ability to throw the error back to the calling application / procedure. Saeid dives deep into examining the error handling mechanism, what errors can be caught by CATCH statement (as we know, not every error can be properly caught in SQL Server even with the structured error handling). So, this article is a very enjoyable and helpful reading if you want to learn all details about error handling in SQL Server. No surprise, this article won September’s TechNet Guru competition in T-SQL section. 

And the second article is All-at-Once Operations in T-SQL – another TechNet Guru Contribution by Saeid Hasani which won a bronze medal in the October’s TechNet Guru Competition.

This article explains the most important concept in SQL Server about logical order of operations, and that all the work is done on the set. Saeid illustrates the important points of the article with the simple to understand code samples and very nice images.

So, in conclusion, I want to tell that TechNet Guru Contribution brought many great articles to TechNet WiKi and to SQL Server side of it in particular. I hope you’ll enjoy these articles as much as I enjoyed reading them.

Comments (13)

  1. Saeid Hasani says:

    Thanks Naomi,

    TechNet Guru Contribution is a great program. I always enjoy to be part of it.

    I will add several articles in Error Handling context. Some examples will be:

    Xact_Aboart option (a soldier with two missions)

    Error Handling in Tiggers

    Error Handling in CLR procedures

    Handling Error in Dynamic SQL and its difficulties!

    etc.

    I currently work on their draft.

    I hope they will be interesting because the Error Handling concept in T-SQL is an interesting concept.

  2. Thanks Naomi for highlighting these excellent articles. I'm looking forward to more from Saeid.

  3. Thank you, Naomi! This is an excellent example of how valuable the TechNet Guru awards have been. And plus, since I work on SQL Server, I'm personally very excited to see great content like this come from Saeid, you, and other vital community members.

    Thank you, Saeid, for your dedication to quality in your articles. And I also look forward to these new articles you are planning!

  4. Durval Ramos says:

    Naomi is right, this article of Saeid is great.

    Saeid was inspired and created with quality content. For this reason, I choose to translate this article his and certainly I will end up translating others articles.

  5. Saeid Hasani says:

    Thanks Richard,

    Hope that I will spend enough time to provide more texts.

  6. Saeid Hasani says:

    Thank you Ed for providing this great program (TN guru awards)!

  7. Saeid Hasani says:

    Thanks Durval,

    It's my pleasure to see you translate my writings!

  8. Shanky_621 says:

    Totally agree with Naomi…Saeid keep up the spirit let more articles flow…

  9. Saeid Hasani says:

    Thank Shanky for your encouragement!

  10. Saeid , Thanks for good articles .

  11. Saeid Hasani says:

    Thanks Sathya, and welcome back!

  12. Sathya, we still need you to make your first blog post. =^)

Skip to main content