As the ratio of DBAs to supported instances and supported databases continues to drop, DBAs must look
to automation, to allow them to continue to improve or, in some cases, even offer the same level of service
to the business as they have historically. This book attempts to give DBAs the tools they need to implement
strategic automation solutions, using the Microsoft standard suite of tools, specifically, PowerShell, T-SQL,
and SQL Server Agent.
Some large enterprises will be lucky enough to have enterprise class monitoring and orchestration
toolsets at their disposal. Even if this is the case, DBAs should find the scripts and the ideas for automated
scenarios contained within this book useful, as they can be plugged into enterprise class toolsets, despite
this book focusing on DBA written orchestrations.