SQLServerCentral.com Content tagged powershell, 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.

Create Normalised Databases with Powershell

Fri, 06 Jul 2012 06:00:00 UT

Database creation with powershell SMO objects

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

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.

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.

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...

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.

Powershell/SMO: Unload table schema, dri, perms & data.

Tue, 10 Jun 2008 06:00:00 UT

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

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.

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.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

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.

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.

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.

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.

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.