Monday, June 26, 2006
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.
To run it use the command below:
cscript /NoLogo CubeStatus.vbs
And this could be the result
FoodMart;expenses;OFFLINE
FoodMart;Inventory;Online
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
Tuesday, June 13, 2006
Visual Studio Team Edition for Database Professionals CTP is here
As announced last week, Microsoft released the first CTP of Visual Studio Team Edition for Database Professionals. The CTP can be downloaded here.
Friday, June 09, 2006
SQL Server Everywhere CTP is here
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.
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:
More info:
Some of the team members started blogging about this upcomming product on their blogs:
Subscribe to:
Posts (Atom)