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

SMO can be a valuable tool for working with SQL Server when you don't have access to all the tools that come with the platform. In this article, SMO helps solve an issue with a SQL Server.  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...

SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.  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 provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.  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...

In this tip, I am going to show you how you can use SMO (SQL Server Management Objects) classes to transfer database objects and data to another server or database.  Read more...

In this tip, I am going to discuss how you can get started with SMO and how you can programmatically manage a SQL Server instance with your choice of programming language.   Read more...

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

SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.  Read more...

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

In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.   Read more...

Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.  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...