I just wanted to take a quick moment to let everyone know that yesterday I received the great news that I will be speaking about PowerShell at the 2010 PASS Summit! 🙂 Here’s what my session will be:
The Dirty Dozen: PowerShell Scripts for the Busy DBA
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. 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.
Senior Database Administrator
I owe a huge thanks to everyone who helped me make this a reality and I’ll write a post thanking many of them when I get some time.
That’s great news, Aaron. I enjoyed your presentation at SQL Saturday in Chicago, and hopefully I can get to the Summit to catch this one.
Thanks Tim and I’m glad you like what you saw in Chicago. I’m developing a new more indepth session as a follow-on but it won’t be ready until SQL Saturday in Nashville at the earliest and Raleigh at the latest.
The one at Summit will be a little longer with some more visualization demos and things like shoving data into tables as you collect it.
Since you’ve seen the session if you have any suggestions that you would like to add I would love to hear your feedback!