Wednesday, September 5, 2007

Manage your SQL server with PowerShell and SMO


There is an excellent six part article walk through on Database Journal website by Muthusamy Anantha Kumar (aka The MAK) on PowerShell and SQL Server 2005 SMO. Everything you need to know in order to operate on SQL. The first parts introducing PowerShell concepts and some cmdlets to work with. From part III and on, there are fine examples on connecting to SQL server, collecting server information from different servers, create and backup databases and a lot more. A must read!

Check it out:

PowerShell and SQL Server 2005 SMO – Part I 
PowerShell and SQL Server 2005 SMO – Part II
PowerShell and SQL Server 2005 SMO – Part III
PowerShell and SQL Server 2005 SMO – Part IV
PowerShell and SQL Server 2005 SMO – Part V
PowerShell and SQL Server 2005 SMO – Part VI

2 comments:

marco.shaw said...

Thanks! Last time I checked they were only at part II...

Unknown said...

Hi there. When I click on the links to the articles, they take me to the website but... unfortunately there is nothing by way of an article there! Can you please explain how to get to them? Thanks.