Recent posts
Recent comments
Author: Rajib
Calender
<<  July 2010  >>
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
Blogroll

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



    Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkListFacebook

    This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

    Be the first to rate this post

    • Currently 0/5 Stars.
    • 1
    • 2
    • 3
    • 4
    • 5
    rajib.bahar , Posted At 11/25/2008 11:54:00 AM
    One of my SQL Server crashsed. I have a long night ahead... yikes. :( 

    Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkListFacebook

    This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

    Be the first to rate this post

    • Currently 0/5 Stars.
    • 1
    • 2
    • 3
    • 4
    • 5
    rajib.bahar , Posted At 11/25/2008 11:48:00 AM


    Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkListFacebook

    This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

    Be the first to rate this post

    • Currently 0/5 Stars.
    • 1
    • 2
    • 3
    • 4
    • 5
    rajib.bahar , Posted At 11/25/2008 10:42:00 AM
    Welcome to my blog site. Just restarting the blog...

    Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkListFacebook

    This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

    Be the first to rate this post

    • Currently 0/5 Stars.
    • 1
    • 2
    • 3
    • 4
    • 5