DBAs who care about the quality of their work, with the world on their shoulders and no budget, who want to keep their jobs but also keep their jobs interesting.
You should know extremely basic PowerShell such as what a variable and a loop is. But we’re also going to boost everything to the next level with templates that even world-class experts will appreciate.
Are you accountable for databases or database servers? Do you fix problems only to see them pop up again months or years later in slightly different scenarios? Have you been called at 2am and asked to “health check” hundreds of servers for an issue that nobody in the world has ever documented before and wished there was an easy mode to do that or even avoid the problem in the first place?
If so then Operational Validation can help you. In this session you’re going to get:
- A mindset on how to handle your day to day duties in a way that keeps you efficient, honest to yourself and to others, while covering your posterior.
- Free tools to fix things and make sure they stay fixed over time. Really free. As in you couldn’t pay for them even if you wanted to.
If you work with one instance you’re going to learn how to manage five hundred instances. And if you work with five hundred instances you’re going to learn how to have fun doing it.
We’re going to learn:
- Jenkins, a cool web application you can install on your workstation to provide orchestration and reports.
- How to integrate PowerShell with Jenkins and multi-thread efficiently in the background with PoshRSJob using ready-to-go templates so you don’t need to worry about how it works.
- Then we’re going to write some tests. They’re not going to be beautiful tests. We’re going to be testing some of the scummiest, most crapulent edge cases SQL Server has to offer. Please bring tissues because there will be tears. If you’ve ever said, “I don’t know what to test”, I’ll make you regret it.
- I’ll also discuss a few other PowerShell modules like CimSession and DbData and why you might want to use them for reliable and scalable tests.
By the end of the session you should be bouncing off the wall and reconsidering your life. I want you to start screaming about Operational Validation from the rooftops, and have the tools and know-how to quickly start on your own.
You’ll also get pretty cool web-based graphs like this:
Why I Want to Present This Session:
I’ve seen things no DBA should see, watched C beams glitter in the dark near the Tannhauser gate, and hundreds of SQL Server patches die simultaneously. I work at scale. Microsoft tools work great one server at a time in a clean little demo, but I’m going to show you real world guerrilla warfare tools for use in the jungles of unreliable and unpredictable environments.
But don’t get me wrong – I’ve never felt the warm embrace of an MVP award. I don’t work for Microsoft or a well-known vendor. I’ve written hundreds of in-depth technical articles and have a good half decade of community contribution. Maybe getting my name out there will change that?
Latest posts by Cody Konior (see all)
- Operational Validation of SQL Server at scale with PowerShell and Jenkins - December 1, 2016