Extend DevOps to Your SQL Server Databases

Extend DevOps to Your SQL Server Databases

• 1.
  Extend DevOps to YourMicrosoft Data Platform Databases Azure webinar series
• 2.
  Intro slide
• 3.
  Meet our speaker GrantFritchey Microsoft Data Platform MVP PASS Immediate Past President Redgate Advocate
• 4.
  Meet our partner
• 5.
  Learn about thebenefits of DevOps for the DBA Understand the capabilities of the Azure DevOps infrastructure in support of the Data Platform See how Redgate Tools makes DevOps easy Goals
• 6.
  Communication is everything All codein source control Shift Left Automated Tests Automated Deployments Monitoring DevOps fundamentals
• 7.
  Every database is code Morebackups is better Recovery is hard An “undo” button in a database Source Control is a Backup
• 8.
  29% 23% 47% 44% 21% 30% Version Control No Version Control 1%or less of deployments have defects 2-10% of deployments have defects More than 10% of deployments have defects Best result Worst result Frequent deployers using version control report lower defect rates Source: Redgate State of Database DevOps Report 2020
• 9.
  “Shift Left” addsprotection Earlier testing Faster failure Frequency of deployment Self-service means learning
• 10.
  37% 20% 28% 45% 43% 39% 19% 37% 33% Easy to geta code review Difficult to get a code review No code review 1% or less of deployments have defects 2-10% of deployments have defects More than 10% of deployments have defects Best result Source: Redgate State of Database DevOps Report 2020 Early code review for database changes is associated with lower production defect rates
• 11.
  Automated testing protectsproduction • When something breaks deploying in dev, build a test • When something breaks deploying in CI, build a test • When something breaks deploying to QA, build a test • Every test improves protection for production • Testing combined with “shift-left” improves production safety
• 12.
  No script should runfirst in production Every deployment is a test Practice is fundamental to mastery “Shift-left” makes practice deployments mean more All this adds to protection for production Frequent deployments means practice
• 13.
  37% weekly or better 40%weekly or better 49% weekly or better 0% 10% 20% 30% 40% 50% 60% 2018 2019 2020 Once or a few times a year Once or twice a Month Daily, Weekly, or on Demand Production database deployment frequency is increasing Source: Redgate State of Database DevOps Report 2020
• 14.
  Monitoring ensures behavior Understand behaviorprior to deployment Know when deployments occur Understand behavior after a deployment Monitoring drives innovation Protection starts with monitoring
• 15.
  Communication is everything All codein source control Shift Left Automated Tests Automated Deployments Monitoring DevOps fundamentals
• 16.
  Redgate SQL ChangeAutomation Gets your database code into and out of source control Deploys your changes through Azure DevOps Ensures repeatable process Provides mechanisms for testing
• 17.
  Today you saw
• 18.
  Get started withRedgate Your next steps Contact our team Request a demo: www.redgate.com/contact Find out more Redgate solutions: www.redgate.com/solutions Join us for a free webinar Upcoming events: www.redgate.com/webinars
• 19.
  Q&A
• 20.
  Thank you forjoining us.