CMU/MSR Mindswap on Privacy

As some of you may have noticed in some of my more recent blog postings, I have started writing about my interest in the field of privacy.  With all that is going on these days with tonnes of information floating on the web and the ability to join disparate data sources together to reveal interesting patterns (or individuals) – it will become imperative that we find ways to guarantee privacy of the individual if we are ever to find interesting patterns within our data.   The example that I had used with my most recent blog on the subject of…

Rate this:

Scalable Shared Databases

There have been some questions that have come to my attention concerning the concept of Scalable Shared Databases and comparing it within the context of Oracle RAC.    If you want to read the SSD vs. Oracle RAC comparison, you can refer to the link Comparing SQL Server 2005 and Oracle RAC.  As well, you can also refer to the SQL Server Books Online content on the subject of Scalable Shared Databases on the subject.   Saying this, the purpose of Scalable Shared Databases is to make use of SAN technology in order to allow you to attach a single read-only…

Rate this:

Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005

For any of you whom are considering using the ByTable (vs. ByAttribute) Processing Group property, I’ve propped up a blog called Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005 with help from Richard Tkachuk, Akshai Mirchandani, and Eric Jacobsen.  Basically, while using ByTable can at times be helpful, you really need to be careful on how you use it.  Read the blog for more info, eh?!     

Rate this:

Incorrect Impersonation Information may crash or hang Analysis Services

If you are processing your AS cube using impersonation mode, if you incorrectly place the impersonation information as MYDOMAIN/UserName instead of MYDOMAIN\UserName, you may crash or hang Analysis Services.  A quick cursory examination noted that with Sybase and DB2 relational data sources, AS ended up crashing.  If SQL Server or Oracle is your relational data source, then the processing is exceedingly slow to the point where the server was hanging; in the end eventually failing.   Thanks to John Lam, Nicholas Birke, and Wei Zhang    

Rate this:

Precision Considerations for Analysis Services Users Whitepaper now available

For those of you whom want to know a little more about precision considerations for Analysis Services users, please check out this recently released whitepaper at http://www.microsoft.com/downloads/details.aspx?familyid=bae8beec-9892-4ecd-a9db-292254895f9c&displaylang=en. This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due to the fact that Analysis Services caches query results and the imprecision that is associated with approximate data types. This white paper discusses how these issues manifest themselves, why they occur,…

Rate this: