Andre Kamman
andrekamman.com
André is a Data Platform MVP. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, Azure DevOps, Python, Azure DW and Databricks. He loves to tinker with 100TB+ databases.
SQLBits 2011
RoboDBA
I'll explain how to manage a large environment of 400+ instances in such a way that it's also useful if you have only 5 instances. Expect 50% processes and war stories and 50% demos and scripts (lots of PowerShell of course, but not everything)
How do you manage a large environment? I was a DBA for more than 400 instances.
- Did I do all that by myself?
- Was the whole environment standardised ?
- Did nothing ever go wrong?
- Did I look through all the error logs on a daily basis by hand?
Of course the answer to all these questions is a big fat NO.
I'll explain how managing a large environment like this works, and I'll do it in such a way that even if you have 5 instances, this should still be useful.
Expect 50% processes and war stories and 50% scripts and demos (lots of PowerShell of course, but not everything)