An Introduction to SQL Server Data Tools for Visual Studio

General, 0

---

For years, database design and creation in the SQL Server community has largely been managed by expensive third-party tooling or many homegrown scripts specific to the task at hand. Even today, many development shops still haven't successfully migrated their database development to source control, forgoing the opportunity for true Agility and collaboration. It doesn't have to be this way! In this session I'll introduce you to SQL Server Data Tools (SSDT) for managing a database project in Visual Studio. SSDT database projects provide powerful tooling to increase your effectiveness and efficiency as a DBA. We'll spend the entire session in Visual Studio starting new projects and importing existing databases, demonstrating how the tooling works, reviewing the best tips and tricks to achieve success, and finish by showing you the most important options that will help to modernize your current processes. You'll leave the session ready to transform the way you manage SQL Server database development!