SQLBits 2018

tSQLt Tests: Unit Test Your SQL Server Code and Sleep Better

You are responsible for writing or deploying SQL Server code, and want to avoid unleashing catastrophe in your databases. In this session you will learn how to install and use the tSQLt testing framework to run automated repeatable tests.
You are responsible for writing or deploying SQL Server code, and want to avoid unleashing catastrophe in your databases. In this session you will learn how to install and use the tSQLt testing framework to run automated repeatable tests. You will gain an understanding of test driven development in the context of SQL Server to isolate and test the smallest unit of code. Some simple techniques can catch bugs early when they are cheapest to fix and make your development life-cycle far more robust. Remove that stomach churning feeling at release time wondering what will break and when your phone will start ringing ominously. Replace that nightmare with an optimism that your changes have been fully tested and are production ready. Relax, sleep well and get it right first time every time.