SQL FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’

Online Microsoft Data Platform Lunch Sessions

SQL FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’

2021-05-19 Past SQL Friday Sessions 0
Date:2021-05-21
Time:12:00 Central European Time (10:00AM UTC)
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’

Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straightforward as one may wish, but it is marred with inconsistencies and surprises. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you don’t. The session presents a recipe for writing CATCH block where focus is on keeping things simple and you will learn why it is not a good idea to make your error handling “”fancy””, although it may seem to be a good idea in theory. The session also covers a few things to think of on client level.

About Erland Sommarskog

Erland Sommarskog is an independent consultant based in Stockholm. He has worked with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and he has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

http://www.sommarskog.se