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)

Presented by Andre Kamman at SQLBits IX
  • Downloads
  • SpeakerBIO
    André is a DBA and SQL Server Solutions architecht for He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW. 
    André is a Data Platform MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland
  • Video