SQLServerCentral.com Articles tagged SMO

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Tue, 14 Aug 2012 06:00:00 UT

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

Using SMO 2012 to trouble shoot support issues

Thu, 26 Jul 2012 06:00:00 UT

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.

Automated Script-generation with Powershell and SMO

Tue, 28 Feb 2012 07:00:00 UT

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

Little Love Lost for SMO

Mon, 28 Nov 2011 07:00:00 UT

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.

Configuring Database Mail with Powershell and SMO

Mon, 15 Aug 2011 06:00:00 UT

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

Is Microsoft neglecting SMO?

Mon, 07 Mar 2011 07:00:00 UT

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?

Moving Indexes with Powershell and SMO

Thu, 30 Sep 2010 06:00:00 UT

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

SSIS Package to Script All SQL Server Jobs to Individual Files

Tue, 06 Jul 2010 06:00:00 UT

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

The T-SQL Hammer

Tue, 23 Feb 2010 07:00:00 UT

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

Transfer database schema objects and data to another server/database with SMO

Wed, 06 Jan 2010 07:00:00 UT

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.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Getting started with SQL Server Management Objects (SMO)

Fri, 04 Sep 2009 06:00:00 UT

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.

Using PowerShell with SQL Server Management Objects (SMO)

Mon, 18 May 2009 06:00:00 UT

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

Using SQL Management Objects to create and restore SQL Databases.

Wed, 18 Jun 2008 06:00:00 UT

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

Backing Up a Database with SMO

Wed, 05 Mar 2008 07:00:00 UT

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.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

SQL Server Management Objects: Lessons from the Wild

Tue, 13 Nov 2007 07:00:00 UT

Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 9

Fri, 26 Oct 2007 06:00:00 UT

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

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8

Tue, 23 Oct 2007 06:00:00 UT

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

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 7

Fri, 19 Oct 2007 06:00:00 UT

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

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4

Tue, 16 Oct 2007 06:00:00 UT

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

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 3

Mon, 08 Oct 2007 06:00:00 UT

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

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part II

Fri, 05 Oct 2007 06:00:00 UT

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

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part I

Thu, 04 Oct 2007 06:00:00 UT

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.

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 6

Wed, 05 Sep 2007 06:00:00 UT

Part 6 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to backup databases.

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 5

Wed, 22 Aug 2007 06:00:00 UT

Part 5 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to create databases.

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4

Tue, 24 Jul 2007 06:00:00 UT

Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.

SQL Server Management Objects

Wed, 18 Jul 2007 06:00:00 UT

A good article on using SMO in SQL Server 2005.

SQL Server Management Objects

Mon, 18 Jun 2007 06:00:00 UT

In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks.

Alert-based Transaction Log Backups using SMO

Mon, 07 May 2007 06:00:00 UT

Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.

PowerSMO at work part 2

Mon, 02 Apr 2007 06:00:00 UT

Dan Sullivan continues his exploration of the versatile PowerSMO tool with coverage of how to control logins, monitor server activity and create standalone administrative scripts.

Backing Up a Database with SMO

Wed, 05 Mar 2008 07:00:00 UT