Transactions and error handling are essential, but anyone who has worked with them knows the pain of performance and observability. In this course, Build Reliable Systems with SQL Server, you’ll gain the ability to develop real-world strategies to master the implementation of transactions in SQL Server to ensure data consistency across operations in a robust and observable way. First, you’ll explore getting error information out of a rolled back transaction. Next, you’ll discover what you can do with this information to make it more plainly available to the people responsible for maintaining the system. Finally, you’ll learn how to solve some common transaction performance challenges with some informed decisions on transaction architecture. When you’re finished with this course, you’ll have the skills and knowledge of transactions and error handling needed to create systems which tell you what was wrong and do so in a timely manner.
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
• Creating Observable Evidence with Transactions and Error Handling
  15mins
• Creating Effective and Well-performing Transactions and Error Handling
  15mins