extending devops practices to sql server databases - using migration scripts - 21st march 17
TRANSCRIPT
![Page 1: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/1.jpg)
![Page 2: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/2.jpg)
Extending DevOps practices to SQL Server databases
![Page 3: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/3.jpg)
Get in touch
www.voiceofthedba.com
@way0utwest
Steve Jones
www.linkedin.com/in/way0utwest
![Page 4: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/4.jpg)
Get in touch
@ArnehEsk
www.linkedin.com/in/Arneh-Eskandari
Arneh Eskandari
![Page 5: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/5.jpg)
Agenda
• Intro to Redgate
• The challenge of integrating databases into DevOps processes
• The effects of poor database change management and deployments
• Benefits of DLM and Database DevOps
• How can Redgate help?
• Demo
![Page 6: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/6.jpg)
About RedgateOver 600,000 technology professionals worldwide use Redgate tools, including 91% of
fortune 100 companies.
Our philosophy is to design highly usable, reliable tools that solve problems commonly
faced by DBAs and developers. And learning and sharing is at the heart of what we do.
![Page 7: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/7.jpg)
The challenge of integrating databases into DevOps processes
• Business-critical data needs to be safely and correctly preserved
• Databases carry state that needs to be managed as part of rolling out
new or updating existing software
![Page 8: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/8.jpg)
Poor Database Deployment Effects
• Databases are out of pace with application development
• Little or no traceability of database changes
• Inability to roll back to the previous version of a database
• Databases become a bottleneck in agile delivery processes
• Releases are less frequent and more risky
• Manual database processes prevent you from utilizing CI and CD to their full extent
• Deployments require a lot of Dev and DBA hours
![Page 9: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/9.jpg)
Benefits of DLM & Database DevOps
• Repeatability of processes, giving:
• Greater predictability over releases
• Efficiency by eliminating the repetition of a range of manual activities
• Faster speed of response to change through:
• The automated deployment of smaller units of change
• Greater reliability of the release process by:
• Providing a series of automated test stages prior to deployment
![Page 10: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/10.jpg)
The Bottom Line
The 2016 State of DevOps report found that:
• IT performance strongly correlates with practices such as version control and
continuous delivery.
• High-performing IT organizations are more agile and reliable, deploying code 200
times more frequently with 3 times lower change failure rate.
• Firms with high-performing IT organizations are twice as likely to exceed their
profitability, market share, and productivity goals.
![Page 11: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/11.jpg)
How can Redgate help?
![Page 12: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/12.jpg)
![Page 13: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/13.jpg)
![Page 14: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/14.jpg)
Demo
![Page 15: Extending devops practices to sql server databases - using migration scripts - 21st march 17](https://reader033.vdocuments.us/reader033/viewer/2022051720/58ecb21a1a28abba7c8b45fb/html5/thumbnails/15.jpg)
Need help?
• Discover Redgate’s full Database DevOps solution
www.red-gate.com/solutions
• Join a one-day online Database DevOps training course
www.red-gate.com/training
• Get expert help with onsite consultancy from our partners
www.red-gate.com/training/find-a-consultant
Contact us: [email protected]