Recent posts
Recent comments
Author: Rajib
Calender
<<  March 2010  >>
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
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