Twitter Updates

    follow me on Twitter

    Friday, June 23, 2006

    Checking the status of OLAP Cubes

    Running a full process of a shared dimension will bring down all the cubes that use that shared dimension. I needed a mecanism to check the status of all my cubes in an Analysis Services 2000 installation.

    So I came up with the following VBS script. It's quick and dirty but it works.

    'CubeStatus.vbs
    ServerName = "LocalHost"
    'Delimiter = Chr(9) 'Tab
    Delimiter = ";"

    Set dsoServer = CreateObject("DSO.Server")

    'Connect Analysis server
    dsoServer.Connect ServerName

    'Walk through OLAP DBs
    For Each dsoDB In dsoServer.MDStores
    'Walk through Cubes.
    For Each dsoCube In dsoDB.MDStores
    State = "Other"
    If dsoCube.State = 0 Then
    State = "OFFLINE"
    ElseIf dsoCube.State = 4 Then
    State = "Online"
    End if
    Wscript.Echo dsoDB.Name & Delimiter & dsoCube.Name & Delimiter & State
    Next
    Next


    To run it use the command below:

    cscript /NoLogo CubeStatus.vbs

    And this could be the result

    FoodMart;expenses;OFFLINE
    FoodMart;Inventory;Online

    Friday, June 09, 2006

    SQL Server Everywhere CTP is here

    The CTP of Microsoft SQL Server 2005 Everywhere Edition can be download here.

    Books online for thise nice new toy are here.

    Funny .... the documentation download is larger than the actual product download ;-)

    SQL Server 2005 Upgrade Technical Reference Guide

    Yesterday Microsoft published the SQL Server 2005 Upgrade Technical Reference Guide on the website. It's a + 350 pages document, so it should be enough to keep you busy during this sunny weekend.

    Also interessting is this best practices guide on Database mirroring.

    Saturday, June 03, 2006

    Visual Studio 2005 Team Edition for Database Professionals

    Earlier this week Microsoft announced Visual Studio 2005 Team Edition for Database Professionals. The product is expected to ship by the end of 2006, but there will be CTP release next week.

    More info:
    Some of the team members started blogging about this upcomming product on their blogs: