Discovering your MetaData

December 29, 2007

I have recently discovered a brand tool to help me better understand my work. It's a free tool from the Microsoft SDK. Specifically, I'm talking about the Rowset Viewer. The Rowset Viewer was intended for you to "view and manipulate OLE DB rowsets, with the added ability to call and manipulate other OLE DB methods from the data source, session, command, rowset, transaction, and notification objects supported by any OLE DB provider." I found myself using the tool so as to understand what was problematic in my cube. Basically,...

Cumulative update package 5 for SQL Server 2005 Service Pack 2

December 23, 2007

Cumulative update 5 was released last week (18th of December 2007). Cumulative update 5 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2. For more details please read the knowledgebase article. More importantly, to download it, please submit a request to Microsoft.   As always, the release of one cumulative package, also means another one is in the works. And this time is no exception…

A PowerShell Provider for Analysis Services

December 6, 2007

  Well I admit I never thought I'd be interested in PowerShell, but I guess it's time for me to learn something new. Darren Gosbell has developed a great new tool: PowerSASS, which is just as the title states, a PowerShell provider for Analysis Services. The tool actually gives you the ability to look at the information from the AMO library as if it was a drive. You can look just as easily at the Roles you defined in your cube or at the Server properties. As I am still learning it all, so for further information I would recommend...

BIDS Helper

I know this means I'm quite late writing about it, but I only came about to learn about this Visual Studio.Net add-in quite recently and I wanted to study it for a bit before writing about it. The BIDS Helper is an excellent extension to the BI Development Studio which comes with SQL Server 2005. Though my main uses for it are for the SSAS part of my BI project, the newly released version also has features for SSIS. Among other features for SSAS, the BIDS Helper enables you to: Validate aggregations – checking whether the calculations you defined...

SQL Server 2008 Books Online

So just in case you're one of the many people who downloaded SQL Server 2008, well now would be a great time for you to update your local copy of the Books Online file. The file was updated November 2007 and it includes information relevant for the first CTP up till the last one, CTP 5, which was released itself during November. BOL includes information about: the set up and installation of SQL Server 2008, the sample databases, tutorials to guide you through all the new tasks and a lot more goodies. The download is available – so go try...
no comments