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 to the processes. Not to mention, you’re missing out on all of the fast-paced fun. Even though DevOps and source control may seem like great ideas, 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! You don’t have to be the bottleneck anymore… AND you can actually have more fun! 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 the SQL Server Data Tools (SSDT) to model an existing project, commit changes to source control, build those changes, and automatically deploy them to an existing development database. I’ll demonstrate what is happening at each stage, discuss the configuration options that matter most, provide solutions for overcoming common problems in the build environment, and show you what to do once the release is ready for production. 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