Transactions help you manage the state of an operation, but don’t provide for complex flows beyond mere success or failure. In this course, Integrate Transactions and Error Handling in SQL Server, you’ll gain the ability to implement error handling to create sophisticated error handling flows. First, you’ll explore error handling for batch imports. Next, you’ll discover how to use error handling to support a complex update. Finally, you’ll learn how to manage schema updates in a way that allows reversion or continuing the process. When you’re finished with this course, you’ll have the skills and knowledge of integrating error handling and transactions needed to structure your SQL workflows in a robust and recoverable way.
Author Name: Chris Behrens
Author Description:
Chris B. Behrens is a writer, speaker and software developer, specializing in DevOps. He has been a developer and architect for more than twenty years focusing on small to medium size companies and the development changes they face. He focuses on his flavor of Fear Based Development, whereby a developer ranks their tasks in descending order of anxiety, and how to tackle them in that order. Chief among these anxiety-inducing processes is software deployment, a topic that Behrens focuses upon. He … more

Table of Contents

• Course Overview
  1min
• Handling Errors in a Transacted Bulk Import
  15mins
• Handling a Sensitive Update with Error Handling and Transactions
  13mins