I'll be presenting my session on Use PowerShell to Get the Most out of SQL Server twice today. This session is a one-hour intro to PowerShell and how to use it to connect with and manage SQL Server. Here's the full abstract:
PowerShell is the new scripting environment from Microsoft for managing server environments. Because PowerShell supports the .Net Framework, accessing SQL Server in a scripting environment is easier than ever before. Whether you need to access data or manage SQL Server, PowerShell makes it possible. This session will give an introduction to PowerShell, explain the basic ADO.Net objects required to connect with SQL Server, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective.
At 2pm Eastern Daylight Time, I'll be presenting it for the PASS DBA Virtual Chapter. You can sign up for it here: http://dba.sqlpass.org/.
At 9:45pm Eastern Daylight Time, I'll be presenting it for the Oregon SQL -developers group in Portland. You can sign up for this one here: http://osql-d.sqlpass.org/.
So, you've got two chances to get started with PowerShell today. If this whets your appetite for more, please consider signing up for my full-day pre-conference session at PASS, where I'll start with the basics of PowerShell, and then spend the day showing you how to effectively manage SQL Server with PowerShell. Check out the details here: PASS Summit PowerShell Pre-Con.
Allen