Offline Database Development and Unit Testing with SSDT

Discover offline database development and unit testing techniques for Microsoft SQL Server using SQL Server Data Tools (SSDT) in this 48-minute conference talk from PASS Data Community Summit. Learn how to create test projects, write unit tests for T-SQL code, and define various test conditions for stored procedures and functions. Explore the unit test structure, understand the process of database deployment, and gain insights into debugging unit tests. Delve into advanced topics such as extending built-in test conditions and creating customized extensions in C#. Master the art of integrating unit testing into your database development workflow, enhancing code quality and reliability.

Intro
Technical Assistance
Offline Database Development
Database Deployment
Deployment Scripts For Inserting Data
Database Unit Testing
Unit Test Flow
Debugging in unit tests
Custom unit test conditions