Chaos Engineering for SQL Server | Andrew Pruski | Conf42 Chaos Engineering 2020

Conference: Conf42 Chaos Engineering 2020

Year: 2020

Andrew Pruski SQL Server DBA @ Channel Advisor Slides: https://580d9e60-4356-475f-aa71-085d1b84e2cf.filesusr.com/ugd/f3e158_da0c445802b346f08f85bef1310bd909.pdf LinkedIn: https://www.linkedin.com/in/andrewpruski/ In this session we’ll look at how Chaos Engineering can be implemented with regard to SQL Server. SQL has various different high availability solutions but can we be sure that they’ll react as expected to a real world issue? Has the HA architecture only ever been tested in a planned maintenance window? We’ll explore SQL Server’s built-in high availability features and take a look at Kubernetes, a brand new platform for SQL Server. We’ll also have some fun by looking at KubeInvaders, a chaos engineering tool for Kubernetes…using Space Invaders! — 0:00 About me 0:45 Session Aim 1:47 Agenda 2:39 Identifying Weaknesses - Incident Analysis 4:04 Likelihood - Impact Map 12:10 Defining and Experiment 13:15 Running an Experiment 14:45 Demo 22:50 SQL Server running on Kubernetes 24:14 KubeInvaders 28:08 Resources — 🥇 Gold Sponsors: ChaosIQ PagerDuty — Website 🚀🪐 https://www.conf42.com Reach out 📧📭 mark@conf42.com Conf42 Discord 🧑‍🤝‍🧑💬 https://discord.com/invite/dT6ZsFJ5ZM LinkedIn 👨‍💼💼 https://www.linkedin.com/company/49110720/ Twitter 🎵🐦https://twitter.com/conf42com Conf42Cast @ Spotify 🎧 https://tinyurl.com/bnyj6a8y