Using PowerShell with SQL Server Management Objects (SMO)
I want to know how Windows PowerShell can help me as a SQL Server DBA.
2009-05-18
3,498 reads
I want to know how Windows PowerShell can help me as a SQL Server DBA.
2009-05-18
3,498 reads
SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.
2008-06-18
5,306 reads
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,039 reads
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
2007-11-13
2,997 reads
Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.
2007-10-26
2,873 reads
This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.
2007-10-23
2,594 reads
This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.
2007-10-19
2,740 reads
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
2007-10-16
2,744 reads
Part 3 of this series illustrates how to script PowerShell cmdlets and execute them. Scripting is essential for automation and executing repetitive tasks.
2007-10-08
2,957 reads
Part II of this series discusses more about PowerShell and its features in conjunction with SMO.
2007-10-05
3,170 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers