Database and Analytics

W11 Real World SQL Server Data Tools


1:30pm - 2:45pm

Level: Intermediate to Advanced

Benjamin Day

Consultant & Trainer

Benjamin Day Consulting, Inc.

Go beyond the basics and learn you how to use SSDT in complex real-world scenarios.

SQL Server Data Tools (SSDT) help you manage your database schemas and let you do it under source control. Every demo you've ever seen though is just "Hello World." What if your databases are complicated? What if your databases have been around for a while and they're filled with dead, garbage SQL structures? What if your databases reference other databases? How about managing lookup values and doing automated deployment? This session will go beyond the basics and show you how to use SSDT in complex real-world scenarios. From taming that old legacy database to representing complex relationships between databases to deployment scenarios—this session will teach you how to really use SSDT to make your coding and deployment life better.

You will learn:

  • Techniques for importing existing legacy SQL Server schemas with old, dead code. Basically, how do you take the kind of messy, not-well-maintained databases that I see at customer sites and bring it into SSDT without losing your sanity and giving up?
  • About real enterprise application databases that often have references across database boundaries, and how to identify and variable-ize these database objects and deal with cross-database and cross-SSDT project references.
  • How to handle incremental automated deployment scenarios from the command line or TFS Build and manage 'lookup' data as part of these deployment scenarios.