PSH script to unload table schema, dri, permissions and data to file(s).  Read more...

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...

Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.  Read more...

This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.  Read more...

Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.  Read more...

This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.  Read more...

This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.  Read more...

This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.  Read more...

Part 3 of this series illustrates how to script PowerShell cmdlets and execute them. Scripting is essential for automation and executing repetitive tasks.  Read more...

Part II of this series discusses more about PowerShell and its features in conjunction with SMO.   Read more...

As you probably know, Windows PowerShell is the new command shell and scripting language that provides a command line environment for interactive exploration and administration of computers. In addition, it provides an opportunity to script these commands so that we can schedule and run these scripts multiple times.  Read more...

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...

PSH script to unload table schema, dri, permissions and data to file(s).  Read more...

This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.  Read more...