SQL Server 2005 JDBC Driver 1.1 CTP June 2006

A quick post for my Java friends: Microsoft released SQL Server 2005 JDBC Driver 1.1 CTP June 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

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.

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.

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:

• The Press Release
• The Product's home page
  

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

• http://blogs.msdn.com/gertd/
• http://blogs.msdn.com/camerons
• http://blogs.msdn.com/rwaymi
• http://blogs.msdn.com/mattnunn
• http://blogs.msdn.com/thomas_murphys_agile_db_blog
• http://blogs.msdn.com/tsdatabl