6:00 – 6:30 Pizza and Networking
6:30 – 6:40 Announcements
6:40 – 6:50 Paul S. Waters: Upcoming Local and PASS SQL Events
6:50 – 8:15 Scott Currie: Techniques for Automating T-SQL Unit Tests and User Acceptance Testing  (UAT)
8:15 – 8:30 Closing remarks and give-a-ways.  Yes, we have SWAG!

Techniques for Automating T-SQL Unit Tests and User Acceptance Testing  (UAT)
In this informal talk, we will spend most of the time in development tools, implementing actual tests.  We will begin with unit test implementations using Visual Studio Team System for Database Professionals (VSTSDB).  While VSTSDB will be the focus, other unit test frameworks (T.S.T, TSQLUnit, utTSQL) will be discussed with examples.  There will be a brief discussion of code coverage and a walkthrough of how a system could be built to measure code coverage using the Sql Server Profiler.  Finally, we will examine an approach for creating and automating user acceptance tests using a simple Excel harness and rules that business analysts can write.  Expect an informal atmosphere with lots of Q&A.

Biography
Scott Currie is the founder and CEO of Varigence, Inc., which offers a comprehensive collection of tools and frameworks for the Microsoft Business Intelligence Platform.  By leveraging the latest technologies from application development and programming language compilers, Varigence revolutionizes the way enterprises build, manage, and use Business Intelligence across their entire organizations.
 
Prior to founding Varigence, Scott worked for 7 years at the Microsoft Corporation.  Scott was the Program Manager for managed interoperability in the Visual C++ Compiler and the 64-bit Just In Time (JIT) compiler for the .NET Framework.  He also lead several important customer connection initiatives for the Developer Division at Microsoft including product feedback, product preview (CTP) and early adopter (TAP) programs, online crash analysis, and customer satisfaction measurements.  Scott later created and served as the Product Unit Manager for the Detego team at Microsoft, which was responsible for leveraging agile application development methodologies in the development of Business Intelligence solutions.
 
Scott graduated from the University of Pennsylvania with undergraduate majors in economics, mathematics, and computer science and a master's degree in computer science.