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

Content with tags Stairway Series, powershell Rss

   Items 1 to 12 of 12   
 

Stairway to SQL PowerShell Level 8: SQL Server PowerShell Provider

In this level we continue our journey into the SQL Server space by looking at the SQL Provider that comes with modules for PowerShell. You saw a little bit of the provider for SQL 2008 R2 in Level 2 of this Stairway.  Read more...
By Ben Miller 2014/10/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,998 reads

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,906 reads

Stairway to SQL PowerShell Level 6: PowerShell Modules

In this level, we will walk through creating and using modules for PowerShell. Modules are simply a collection of functions that are most likely related to each other and packaged in a way that allow you to import them as a group.  Read more...
By Ben Miller 2014/04/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,793 reads

Stairway to SQL PowerShell Level 3: Input and Output with PowerShell

This level will cover some of the Input/Output operations you can use with PowerShell.   Read more...
By Ben Miller 2013/10/23 (first published: 2012/08/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,546 reads

Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config

Now that you know how to get started with PowerShell, it is time to configure PowerShell for SQL Server use. This level covers the components you'll need and how to configure them.  Read more...
By Ben Miller 2013/09/25 (first published: 2012/08/15) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,854 reads

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool.  Read more...
By Ben Miller 2013/09/04 (first published: 2012/08/08) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 30,125 reads

Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks

You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.  Read more...
By Ben Miller 2013/03/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,554 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2012/10/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,878 reads

Stairway to SQL PowerShell Level 3: Input and Output with PowerShell

This level will cover some of the Input/Output operations you can use with PowerShell.   Read more...
By Ben Miller 2013/10/23 (first published: 2012/08/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,546 reads

Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config

Now that you know how to get started with PowerShell, it is time to configure PowerShell for SQL Server use. This level covers the components you'll need and how to configure them.  Read more...
By Ben Miller 2013/09/25 (first published: 2012/08/15) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,854 reads

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool.  Read more...
By Ben Miller 2013/09/04 (first published: 2012/08/08) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 30,125 reads

Stairway to SQL PowerShell

PowerShell is a powerful scripting tool that allows you to automate routine tasks, and script administrative tasks, allowing you to automate a lot of the routine work in a SQL envirionment. Ben Miller's Stairway Series introduces PowerShell from the beginning, guiding you through how to configure and get started with the framework before working towards more advanced scripting.  Read more...
   Items 1 to 12 of 12   
 
Tags
objects (1)    
powershell modules (1)    
smo (1)