Database and Analytics

VST07 Real World SQL Server Data Tools (SSDT)


11:00am - 12:15pm

Level: Intermediate to Advanced

Benjamin Day

Consultant & Trainer

Benjamin Day Consulting, Inc.

SQL Server Data Tools (SSDT) help you manage your database schemas under source control. However, every demo you've ever seen is just "Hello World." Your databases are just a bit more complicated. What if your databases have been around for a while and they're filled with deadSQL 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'll learn techniques for importing existing legacy SQL Server schemas with old, dead code.