Build Reliable Systems with SQL Server
Transactions and error handling are great, but they have some pitfalls that it helps to know about. This course will teach you how to work with transactions and error handling to make your system efficient, well-performing, and observable.
What you'll learn
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.
Table of contents
About the author
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