Windows PowerShell is a .NET based command shell and scripting language that is being built into all major Microsoft products including SQL Server 2008 (CTP6). PowerShell can be used to administer SQL Server via Server Management Objects (SMO). Using PowerShell to access SMO removes the need to write .NET based applications. PowerShell and SMO bring an increased level of automation to managing SQL Server environments. This session will introduce PowerShell and demonstrate how to administer SQL Server programmatically and interactively at the command line. The PowerShell provider in SQL Server 2008 will (hopefully) be used as well as scripts. The session is demonstration heavy and concentrates on the practical side of using these technologies.
Presented by Richard Siddaway at SQLBits II