Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.   Read more...

Database creation with powershell SMO objects  Read more...

Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.  Read more...

Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.  Read more...

Phil Fator, the self-confessed wild man of T-SQL, finally comes clean: he's a secret PowerShell user. But for the DBA, what is PowerShell without SMO? Is Microsoft giving the latter the care and attention it needs?  Read more...

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.  Read more...

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...  Read more...

I want to know how Windows PowerShell can help me as a SQL Server DBA.  Read more...

PSH script to unload table schema, dri, permissions and data to file(s).  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...