Database Doing DevOps
To Devops or not to Devops, that is the question. We’ve talked before about how the developers have all the cool new tools, but this is slowly changing. For those in development or dare I say agile (gasp!) environments there is more need for automation, but getting there can be a real challenge. In this episode, we chat with John Morehouse about how he actually put into practice automated deployments for the database, some of his challenges, and how long it took to get there.
Are you trying to implement continuous delivery for the database? Let me know in the comments below or by social media. I am very interested to hear your experiences.
Alex Yates blog post: http://workingwithdevs.com/delivering-databases-migrations-vs-state/
“One of things that has to change when it comes to Database Continuous Delivery is the DBAs have to get out of their chair and go talk to the developers.”
“Database Continuous Delivery is not something that you can install, flip a switch and woohoo, voila, you’re done!”
“The test process or framework is just as important as the application code or the database code.”
“Don’t notify me when things are successful. Notify me when things fail.”
“Communication is going to be a huge component of getting this into place.”
Listen to Learn
01:35 Compañero Shout-Outs
02:57 Intro to the guest and topic
05:18 DBA vs Developer roles
06:26 Get your database in source control
08:01 DBAs have to communicate with developers
11:46 What role am I going to play?
13:43 What is going to be best for this environment?
15:43 Who should lead the charge
19:09 Normal life still has to happen while you get things going
21:42 Dedicated models are a good idea and testing is critical
27:40 Security and who should have access to what
31:29 Why use a dedicated model?
33:19 Hopefully you have a good recovery strategy
34:52 SQL Family Questions
39:39 Closing Thoughts
John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. John lead the Omaha SQL Server user group for 7 years and is now a leader of the Louisville SQL Server/Power BI user group. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday as well as other conferences. In his spare time, you can usually find John on Twitter (@sqlrus) as well as chasing his two young sons around the house.
Meet the Hosts
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.