Declarative Database Development with SSDT

Database development is complicated by nature! Database engines are stateful, so data loss is always a risk; object dependencies determine the order in which changes need to be applied and the loosely coupled nature of the SQL language can result in unexpected runtime errors. These are just a small collection of examples why database development is hard. The SQL Server Data Tools (SSDT) development environment helps developers getting a better handle on database development, testing, deployment and migrations. The declarative nature lets the developer focus on the final state they want, instead of writing an imperative script on how to change the state of the database directly.
Presented by Gert Drapers at SQLBits X
  • Downloads
  • SpeakerBIO
    gert_drapers.jpg
    Gert Drapers is the Principal Group Program Manager for Project Juneau, the next version of SQL Server developer tooling shipping as part of SQL Server “Denali”. Gert's history with SQL Server dates all the way back to 1988. In 1996 he joined the SQL Server 7.0 engine team as a developer and since then has worked in many different roles, on many different things directly or indirectly related to SQL Server. Most prominent contributions are: SQL Query Analyzer, SQL Agent, SMO, DTS, System.Transactions, MS-DTC and XPSMTP.  In July of 2005 Gert started the “DataDude” project which led to the creating of Visual Studio Team System Database Edition, from there on it is all history…
    http://blogs.msdn.com/gertd
  • Video