Shall I compare thee to Management Studio?
Thou art more scriptable and consistent.
Those out-of-memory errors do tend to lose hours of work.
And I mean, SSMS doesn’t run from the command line.
Sometimes I get those line-endings errors,
Not to mention IntelliSense bombing out;
And figuring out which tab I was in can be confusing,
By chance, or accidental mouse click, or a wrong connection;
But thy eternal PowerShell shall not fade,
Nor lose possession of the security objects,
Nor shall an error bring down the entire environment,
When in eternal lines to Time thou runst.
So long as people can breathe, or eyes can see,
So long lives this, and this gives life to thee.
Visit dbatools.io today to leverage the power of shell scripting and .NET for SQL Server migrations and best practice implementations. Then get your hands on dbachecks to validate your SQL Server instances.
Share your best dbatools stories in the comments below.