As promised, here are the slides and code samples from the Real World SQL Server Data Tools (SSDT) talk that I did this week at VSLive Orlando 2015.
Here’s the abstract:
SQL Server Data Tools (SSDT) help you manage your database schemas and let you do it under source control. Great. Got it. But every demo you’ve ever seen 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.