Database and Analytics

W04 Database Development with SQL Server Data Tools


8:00am - 9:15am

Level: Introductory to Intermediate

Leonard Lobel



Sleek Technologies, Inc.

SQL Server Data Tools (SSDT) is a powerful integrated development environment for designing, testing, and deploying SQL Server databases from within Visual Studio; whether you're working locally or remotely, connected or offline, or within the Microsoft Azure cloud. While SQL Server Management Studio (SSMS) continues to serve as your primary tool, SSDT plugs in to Visual Studio as a special database project type.

This session will describe the various difficulties you face, and demonstrate how SSDT can remedy those pain points. You will learn how to use features such as code navigation, IntelliSense, and refactoring with your database model– indispensable tools traditionally available only for application development in Visual Studio. You'll also cover the declarative model that lets you design databases offline and under source control right from within solution in Visual Studio, as well as how to deploy to SQL Database on Microsoft Azure. Don't miss out on this demo-centric information-packed session on the current generation of database tools.

You will learn:

  • The benefits of database development with SSDT's declarative model-based architecture
  • 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 Microsoft Azure SQL databases in the cloud all from inside Visual Studio