OK, we’re finally past the newness of PowerShell and have some great scripts to apply directly to SQL Server. Trevor has a great show and tell lined up for us!
Description: This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of “recipes,” stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier. Despite the title, there will be value for database and business intelligence developers too!
Biography: Trevor Barkhouse is an Escalation DBA for Terremark Worldwide, Inc., a leading global provider of IT infrastructure services. His passions are automation, performance tuning, and troubleshooting. Trevor is very active in the community. In addition to recently finishing a term on the board of directors of the North Texas SQL Server Users Group, he has spoken at many user group meetings, three SQLSaturday events, and at the 2009 PASS Community Summit.
Web site: http://SQLServerSleuth.com/