As most of us know already, that powershell is the new shell around SQL 2008 to automate database related routines. It reminds me of the manpages in unix itlabs at the UofM. Anyways, I'll start posting few entries related to it. The example below, shows you how to manipulate .NET collection classes.
PS SQLSERVER:\> $c = New-Object "System.Collections.ArrayList"
PS SQLSERVER:\> $c.Add("test")
0
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("your")
1
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("mind")
2
PS SQLSERVER:\>
PS SQLSERVER:\> $c
test
your
mind
PS SQLSERVER:\>
PS SQLSERVER:\> $c | Select-Object -first 2
test
your
PS SQLSERVER:\> $c | Select-Object -last 2
your
mind
PS SQLSERVER:\>
One of my SQL Server crashsed. I have a long night ahead... yikes. :(
Welcome to my blog site. Just restarting the blog...
This is the interview part 3 of Matt Harding from "Where the hell is Matt?" and Palbasha Siddique by Rajib Bahar at KFAI Radio.
----
feel free to reach out to me at my blog:
http://www.rajib-bahar.com
Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5
Tags:
This is the interview part 5 of Matt Harding from "Where the hell is Matt?" and Palbasha Siddique by Rajib Bahar at KFAI Radio.
----
feel free to reach out to me at my blog:
http://www.rajib-bahar.com
Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5
Tags:
This is the interview part 2 of Matt Harding from "Where the hell is Matt?" and Palbasha Siddique by Rajib Bahar at KFAI Radio.
----
feel free to reach out to me at my blog:
http://www.rajib-bahar.com
Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5
Tags:
This is the interview part 1 of Matt Harding from "Where the hell is Matt?" and Palbasha Siddique by Rajib Bahar at KFAI Radio.
----
feel free to reach out to me at my blog:
http://www.rajib-bahar.com
Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5
Tags:
This is the interview part 4 of Matt Harding from "Where the hell is Matt?" and Palbasha Siddique by Rajib Bahar at KFAI Radio.
----
feel free to reach out to me at my blog:
http://www.rajib-bahar.com
Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5
Tags:
This is the interview part 6 of Matt Harding from "Where the hell is Matt?" and Palbasha Siddique by Rajib Bahar at KFAI Radio.
----
feel free to reach out to me at my blog:
http://www.rajib-bahar.com
Other sites of interest:
http://www.kfai.org
http://www.youtube.com/kfairadio
http://www.youtube.com/rajib2k5
Tags: