Administering SQL Server 2008 and 2005 with Windows PowerShell

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
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Richard Siddaway is Microsoft Practice Leader for Centiq Ltd. With over 20 years experience in various aspects of IT Richard is currently concentrating on the Microsoft environment at an architectural level especially around Active Directory, Exchange, SQL Server and Infrastructure Optimisation much of his recent experience has involved migrating enterprises from Windows NT\Exchange 5.5 to Windows 2003\Exchange 2003. Richard has administration experience with several database systemsespecially SQL Server. His initial programming background is still usefulas Richard is a very experienced scripter always looking for the opportunity to automate a process. Having discovered PowerShell 18 months ago he has enthusiastically adopted it in preference to VBScript. Richard founded and currently leads the UK PowerShell User Group. Richard has presented on PowerShell to the Directory Experts Conference 2007, at various events at Microsoft UK, including the last Community Day, and for other UK User Groups.
  • Video
    The video is not available to view online.