Transactions and Exception Handling
Using T-SQL transactions to manage the behaviour of queries is always a balance between data integrity and client concurrency. In order to build high performance, well behaving data logic layers it is important that we understand this topic. In this session we will look at isolation levels (including the row versioning levels), locking and deadlocking. We’ll also look at the exception handling capabilities in 2005 and how they can be used to manage transactions in stored procedures.
Eric has been working with SQL Server since version 6.5. He is currently working for IMGroup the MS Worldwide BI Partner for the last 3 years. Prior to this he managed development effort for a number of dotcoms and another consultancy. Eric has presented multiple sessions for UK SQL Server User Group events and written for a number of magazines including Enterprise Server Magazine.
The video is not available to view online.