I came across this little gem which I haven't noticed so far. A nice summary of the 10 things you should do to optimize the UDM query performance. The best one is kept for last - scale out when you can no longer scale up. So true, if I could only convince customers to do so J
Read articleSQL Magazine published the first part of my article Protect UDM with Dimension Data Security in its July issue. This article explains the fundamentals of dimension data security. I am working on making the article available for public access (as of now, it requires subscriber-level access). The article code can be downloaded from the publisher's website and from my website. I am currently writing the…
Read articleIf you use VS.NET deployment to deploy your SSAS project from one domain to another, you may get the following obscure error message on deploy. The trust relationship between the primary domain and the trusted domain failed. This may happen even if your workstation and the deploy server are on the same domain. The most likely reason for this error is that you have added…
Read articleBack to my When (null) is not Null post, there is a undocumented breaking change in SQL Server 2005 SP2 which you should be aware of. In response to the customer demand, SP2 treats aggregate rows as detail rows. As a result, if the report doesn’t use the Aggregate() function, the report will show all rows. For those using the Aggregate function, there will be…
Read articleI am back from an one-week vacation to Clearwater, Florida followed by TechEd 2007 US in Orlando. Overall, nothing earth – shattering on the BI arena from TechEd 2007. Product groups are between releases so most of the content was SQL Server 2005-based with a few sneak previews of some of the good stuff to come in Katmai. My presentation attracted a fairly large crowd.…
Read article
