4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Should I Handle Errors in Transact SQL?

SQL Server 2012 brings a new capability for error handling - rethrowing the original error. Is the rethrowed error really the original one? Why you have to be careful with THROW?  What should I test if I implement tRY/CATCH error handling in SQL Server? Finally, should I handle Transact SQL errors at all?

In this session we will answer these questions and explain how SQL Server database engine handles errors. We'll discuss best practices and demonstrate common mistakes and misunderstandings in error handling.
Presented by Milos Radivojevic at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    milos_radivojevic.jpg

    Milos Radivojevic is a database developer and consultant, speaker, and trainer located in Vienna, Austria. He has been working with SQL Server over 12 years. He is Microsoft SQL Server MVP and MCT and specializes in SQL Server for application developers and performance and query tuning. Currently he works as senior database developer in bwin.party (the largest regulated online gaming company in the world) where he works with some of the largest SQL Server databases. He is co-leader of the SQL Server PASS Austria. He is a speaker in international conferences (SQLBits, SQL Saturday, SQLU Summit) and speaks regularly at SQL Server PASS Austria meetings. He has developed two courses: SQL Server For Application Developers and (for SolidQ) SQL Server 2012 for Experienced Developers and DBAs (Co-author with Herbert Albert and Gianluca Hotz). His Twitter handle is @MilosSQL.

    http://www.bwinparty.com http://milossql.wordpress.com/feed
  • Video
    The video is not available to view online.