VSH19 Database Development with SQL Server Data Tools


3:00pm - 4:15pm

Level: Intermediate

Leonard Lobel



Sleek Technologies, Inc.

Don't miss out on this demo-centric information-packed session on the current generation of database tools!

SQL Server Data Tools (SSDT) is a powerful integrated development environment for designing, testing, and deploying SQL Server databases - whether you're working locally or remotely, connected or offline, or in the cloud on Windows Azure - all from right inside of Visual Studio. While SQL Server Management Studio (SSMS) continues to serve as the primary tool for database administrators, SSDT plugs in to Visual Studio as a special database project type designed specifically for the application developer.

In this session, Lenni begins by describing the various difficulties that developers face, and then demonstrates how SSDT can be used to remedy those pain points. You will learn how to use features such as code navigation, IntelliSense, and refactoring with your data-base model - indispensable tools traditionally available only for application development in Visual Studio. We'll also cover the declarative model that allows you to design data-bases offline and under source control right from within solution in Visual Studio, as well as how to deploy to Windows Azure SQL Database. Don't miss out on this demo-centric, information-packed session on the current generation of database tools for application developers!

You will learn:

  • The benefits of database development with SSDT's declarative model-based architecture
  • Understand the various SSDT features and capabilities (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 data-bases, offline database projects, and Windows Azure SQL databases in the cloud all from inside Visual Studio