DevOps for the database--you have probably heard the term if you work in an organization that is deploying code on a regular basis. The developers have this down to a science, and now it is the database's turn. The idea of deploying code and having a certainty it will run correctly instead of crossing your fingers and hoping you don't see the red error messages has a certain appeal. There are lots of tools out there now to help with this, but it seems like we still drag our feet.
I know I did. When I chatted with Cindy Bean from DBMaestro, I didn't have much database change automation experience. I had exposure to source control, but DevOps seemed more than that. After speaking with Cindy I created my first database project in Visual Studio. I definitely get the idea and hope to implement it fully in my environment. This episode is an introduction to the idea of database change automation and how you might get started.
You can see the shownotes from today's episode at
SQL Server 2016 has several new features and this episode explores the stretch database feature. One of the unique attributes of this feature is that it uses both the on premise instance and the Azure platform.
I chat with Anthony van Gemert, one of the product managers for stretch, about how the features works and under what scenarios organizations might use stretch technology.
Are you planning to use stretch database? Let me know via twitter. I am @CarlosLChacon. You can check out the show notes at