Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email Thank you for your patience.



Thank you to our sponsors




All 24 Hours of PASS registrants will automatically become PASS members. (membership is free!)





Database Development Patterns


Return to Session Listings

Presenter: Andy Leonard, Unisys Corporation


Session 02 (13:00 GMT on May 19)


Session Details

Designed for software developers tasked with database development, this practical session features:

  • Patterns and anti-patterns of database development
  • One way to build re-executable T-SQL deployment scripts
  • A method for using SqlCmd to deploy re-executable T-SQL deployment scripts
  • Fodder for a lively discussion about NULLs


About the Speaker

SQL Server MVP and PASS Regional Mentor Andy Leonard is an architect with Unisys Corporation, a SQL Server database and Integration Services developer, and an engineer. His background includes Web application architecture and development, Visual Basic, ASP, SQL Server Integration Services, and data warehouse development using SQL Server 2000, 2005 and 2008. He is a coauthor of Professional SQL Server 2005 Integration Services (Wrox) and SQL Server MVP Deep Dives (Manning Publications) and blogs for

Register now for 24 Hours of PASS!



Check out the speaker lineup!



Copyright 2013 by PASS | Terms Of Use | Privacy Statement | Login