Powershell in SQL 2008 - playing with ArrayList

By Rajib Bahar at November 25, 2008 13:50
Filed Under: SQL, .NET

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:\>

Long night ahead

By Rajib Bahar at November 25, 2008 11:54
Filed Under: SQL
One of my SQL Server crashsed. I have a long night ahead... yikes. :( 

Videos I watch for fun...

By Rajib Bahar at November 25, 2008 11:48
Filed Under:

Welcome

By Rajib Bahar at November 25, 2008 10:42
Filed Under:
Welcome to my blog site. Just restarting the blog...

Rajib interviews Matt Harding & Palbasha Siddique - KFAI - Pt. 3

By Rajib Bahar at November 12, 2008 18:00
Filed Under:


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

Rajib interviews Matt Harding & Palbasha Siddique - KFAI - Pt. 4

By Rajib Bahar at November 12, 2008 18:00
Filed Under:


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

Rajib interviews Matt Harding & Palbasha Siddique - KFAI - Pt. 1

By Rajib Bahar at November 12, 2008 18:00
Filed Under:


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

Rajib interviews Matt Harding & Palbasha Siddique - KFAI - Pt. 2

By Rajib Bahar at November 12, 2008 18:00
Filed Under:


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

Rajib interviews Matt Harding & Palbasha Siddique - KFAI - Pt. 5

By Rajib Bahar at November 12, 2008 18:00
Filed Under:


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

Rajib interviews Matt Harding & Palbasha Siddique - KFAI - Pt. 6

By Rajib Bahar at November 11, 2008 18:00
Filed Under:


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

Tag cloud

Month List