Friends of SQL Server, For Database Administrators, For Developers

SQT04 Introducing SQL Server Data Tools

12/11/2012

11:00AM - 12:15PM

Level: Introductory to Intermediate

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

Application developers just got a brand new database development environment! With the release of SQL Server 2012, the new SQL Server Data Tools (SSDT) serves as your primary development environment for building Windows and Web applications on top of 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 .NET application developer.

With SSDT, developers can finally enjoy building database 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 models 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 solution in Visual Studio. Don't miss out on this demo-centric information-packed session on the new generation of database tools for application developers!

You will learn:

  • The declarative model-based approach used in the new generation of SQL Server tools for developers
  • The various services that power the new tools (explorer, designers, schema compare, local database runtime, language services, debugging, and buffered editing)
  • See live demonstrations of how to design, test, and deploy on-premises databases, offline database projects, and SQL Azure databases in the cloud all from inside Visual Studio