Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags powershell, SMO Rss

   Items 1 to 17 of 17   
 

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.  Read more...
By Ben Miller 2014/05/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,469 reads

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

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.   Read more...
By Daniel Calbimonte 2012/08/14 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 6,048 reads

Create Normalised Databases with Powershell

Database creation with powershell SMO objects  Read more...
By Patrick Viennot 2012/07/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 917 reads

Automated Script-generation with Powershell and SMO

Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.  Read more...
By Additional Articles 2012/02/28 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,606 reads

Configuring Database Mail with Powershell and SMO

Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.  Read more...
By Bruce Kastner 2011/08/15 | Source: SQLServerCentral.com | Category: database mail
Rating: |  Discuss |   Briefcase | 2,729 reads

Is Microsoft neglecting SMO?

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...
By Phil Factor 2011/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 494 reads

Moving Indexes with Powershell and SMO

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.  Read more...
By Zach Mattson 2010/09/30 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 3,998 reads

The T-SQL Hammer

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...  Read more...
By Chad Miller 2010/02/23 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 3,304 reads

Using PowerShell with SQL Server Management Objects (SMO)

I want to know how Windows PowerShell can help me as a SQL Server DBA.  Read more...
By Additional Articles 2009/05/18 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,837 reads

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

PSH script to unload table schema, dri, permissions and data to file(s).  Read more...
By Gordon-265412 2008/06/10 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 936 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 9

Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.  Read more...
By Additional Articles 2007/10/26 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,350 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8

This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.  Read more...
By Additional Articles 2007/10/23 | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,097 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 7

This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.  Read more...
By Additional Articles 2007/10/19 | Source: Database Journal | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,316 reads

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

This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.  Read more...
By Additional Articles 2007/10/16 | Source: Database Journal | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,295 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 3

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...
By Additional Articles 2007/10/08 | Source: Database Journal | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,486 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part II

Part II of this series discusses more about PowerShell and its features in conjunction with SMO.   Read more...
By Additional Articles 2007/10/05 | Source: Database Journal | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 2,710 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part I

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...
By Additional Articles 2007/10/04 | Source: Database Journal | Category: smo
Rating: (not yet rated)  Rate this |   Briefcase | 3,200 reads
   Items 1 to 17 of 17   
 
Tags
sql server 2005 (7)    
administration (1)    
backup (1)    
blogs (1)    
creation (1)    
database (1)    
database mail (1)    
database weekly (1)    
editorial (1)    
indexing (1)    
script (1)    
simple-talk series (1)    
sqlcmd (1)    
stairway series (1)