Session Details -
Administering SQL with SMO and powershell
|
|
Administering SQL Server with SMO and Windows PowerShell SMO is a set of .NET objects introduced with SQL Server 2005 that give programmatic access to the administrative functionality exposed in the SQL Server Management Studio. Windows PowerShell is the .NET based command line shell and scripting language that is being built into the latest Microsoft products such as Exchange 2007 and Operations Manager 2007.
Until recently SMO was only available to developers willing to write full blown .NET programmes but as PowerShell is .NET based it can access and utilise SMO from the command line as well as in scripts. This session will introduce Windows PowerShell, including its very powerful WMI capabilities, and SMO. There will be some slides during the introduction but the majority of the session will be demonstrations of the technologies in action including graphical, on screen representation of the data from with the command line environment.
|
|
|
Richard Siddaway
|
|
|
|
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.
|