In this show SQL Server MVP Adam Machanic discusses advantages of using stored procedures as APIs and unit testing of SQL Server stored procedures.