SQLDiva

Lisa McCrary from Proclarity spoke at the NJ SQL Server Meeting on the February 21st. Lisa flew in from Atlanta, Georgia just for our User Group meeting(WOW!!!) She did a great job of providing our user group folks with an overview on OLAP and Microsoft Analysis Services 2005.  It was amazing to me that so many folks(5-6) had worked ...

I am currently in the process of working with sqlpass.org to set up the Northern NJ SQL User Group.  If you are interested in attending meetings or helping out with the User Group, please let me know. Thanks!!!  SQLDiva

I heard some good news from MSAS Microsoft Support last week. Service Pack 4(Projected Release 4th Quarter) may include a diagnostic tool that will enable you to check for Olap Database inconsistencies (Like, DBCC CHECKDB in SQL Server). In more complex, MSAS structures issues can arise in the indexes/aggregations that do not manifest into ...

I've been testing out MSAS Hotfix #931 and some additional developer builds from Microsoft. Everything was going pretty smoothly until I restarted the Analysis Manager on my test server and the list of my Analysis Server and the ''Register Server'' option was missing. My heart almost stopped… What the H#$@$ did I do!!! Anyway… ...

My company has a centralized Data Center complete with a set of Help Desk Brain Surgeons. We have recently transitions 2 applications to the centralized Data Center.   I am currently having 2 issues with Analysis Services Hot Fix #909: #1: It appears that the client software on the servers do not have the same version installed as the ...