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

Archives: May 2010

PowerShell Week at SQL University – Post 3

Providers

What are Providers?  Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive.  Why do you need them?  Well you quite possibly may not ‘need’ them per-say but they sure do make… Read more

0 comments, 278 reads

Posted in SQLvariant on 20 May 2010

PowerShell Week at SQL University – Post 3: Providers, PSDrive

Providers

What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive. Why do you need them? Well you quite possibly may not ‘need’ them per-say but they sure do make… Read more

0 comments, 649 reads

Posted in SQLvariant on 20 May 2010

PowerShell Week at SQL University – Post 2

Cmdlets, Functions and Snapins

So far we’ve learned how to open up PowerShell and add on to it with some modules; then we learned how to create a variable and populate it with anything from some numbers to an entire table.  Today we’re going to quickly look at another… Read more

0 comments, 529 reads

Posted in SQLvariant on 19 May 2010

PowerShell Week at SQL University – Post 1

Getting Started With PowerShell Variables

Yesterday we laid the ground work for PowerShell Week.  Today we will learn about Variables in PowerShell. You will notice that PowerShell variables work very differently from SQL Server variables.

The evolution of variables in SQL Server is pretty straight forward. In SQL Server 2000… Read more

0 comments, 513 reads

Posted in SQLvariant on 18 May 2010

PowerShell Week at SQL University – Post 0

Welcome to PowerShell Week at SQL University.  For regulars at SQLvariant, SQL University is something Jorge Segarra organized to get industry experts together to create learning courses around SQL Server.  These learning courses are in one week segments that focus on a specific area. 

When I began blogging about… Read more

0 comments, 498 reads

Posted in SQLvariant on 17 May 2010