Using PowerShell to Get the Most Out of SQL Server (DBA)

Presenter: Allen White

Session Details

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 you an introduction to PowerShell, explain the new SQL Server PowerShell cmdlets, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective.

About the Speaker

Allen White is a SQL Server trainer for Scalability Experts, a leading provider of scalable solutions, training, and services based on Microsoft SQL Server. He's spent over 30 years in IT, including operations, development, telecommunications, network admin, and database design and administration. He has been using SQL Server since 1992 and is a certified MCITP: Database Administrator, MCITP: Database Developer, and MCT. Allen has been awarded Microsoft’s MVP Award for his work in the SQL Server community for the last two years. He is active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell. He maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.

Register now for 24 Hours of PASS!