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.