The Dirty Dozen: Windows PowerShell Scripts for the Busy DBA

Download

Right click “Save as…”

Slides (view online)
You’ve heard it said, “If you have to do it twice, automate it.” That’s great advice and PowerShell provides a simple but extremely powerful way to do it. PowerShell is the future of Windows scripting. Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day-to-day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of PowerShell to easily find servers short on space, script out tables and constraints across all of your databases at once and backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool. #TEDBI331
For more information, check out this course on Microsoft Virtual Academy:

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.