If you work with a development team to plan and implement database changes by hand or with third party tooling, you’ll love what Microsoft’s newest version of SQL Server Data Tools (SSDT) has brought to the table. This session is an introduction to SSDT and how you can effectively manage and deploy changes in your development environment and beyond, using tools you’re already familiar with.
I will spend some time reviewing the basics of DevOps and how it applies to database development, however, I will encourage viewers to find previous sessions that have covered DevOps in more depth.
As the DBA for an Agile, Sprint-based team, you may feel like the bottleneck at every turn. You’ve stuck with the existing processes and tools because it’s what you know. After all, “If it ain’t broke, don’t fix it!” Right?
I have good news! With only a few new skills and free tools from Microsoft, you can join the Agile & DevOps revolution to help accelerate your team, product, and data infrastructure.
In this session I’ll use the newest version of SQL Server Data Tools (SSDT) to model an existing database and then demonstrate each step from modification to a working, automated deployment. I’ll highlight the configuration options that matter most, provide solutions for overcoming common problems across environments, and show you what to do once the release is ready for production.
After seeing the possibilities, you’ll be ready to change those old processes. And in no time at all, you’ll be the talk of the team as they try to keep pace with you!
Why I want to present this session:
While Microsoft and others have been teaching that we can use SSDT to achieve DevOps nirvana, most demos skip over the nuts and bolts of the process, preventing users from achieving success once they leave the presentation. Over the last few months, I’ve had to dig through presentations and blog posts to learn how all of the pieces come together. I want to save users from this headache and give them the first steps for success.
I’d like to show viewers that the barrier to implementing a new workflow with SSDT isn’t very high, and how the change and excitement it produces can be contagious.
Latest posts by Ryan Booz (see all)
- The Agile DBA: A Guide To Database DevOps With SSDT - March 11, 2018