Database developers, get ready for a brand new development environment! With the upcoming release of SQL Server 2012 (codename "Denali"), SQL Server Developer Tools (SSDT, codename "Juneau") will serve as your primary development environment for building applications with SQL Server. While SQL Server Management Studio (SSMS) continues to serve as the primary tool for database administrators, SSDT plugs in to Visual Studio as a new database project type designed specifically for the application developer. It also provides a new SQL Server node in Server Explorer for developing on-premises or cloud databases, as well as the new local database runtime (LDR) for offline testing and debugging.

With SSDT, developers can finally enjoy building applications without constantly switching between Visual Studio and SSMS. In this session, Lenni will demonstrate how SSDT can be used to develop for (and deploy to) on-premise and SQL Azure databases. In addition to replicating most of the functionality found in SSMS, you will learn how to use features such as code navigation, IntelliSense, and refactoring with your database model-indispensable tools previously available only for application development in Visual Studio. We'll also cover the new declarative model that allows you to design databases offline and under source control right from within your solution in Visual Studio. Don't miss out on this demo-centric information-packed session on the next generation of database development tools for SQL Server!