Welcome back ForceMerge() AKA MultiCube()!
I have always been a big fan of the MultiCube() function that is available in Desktop Intelligence. I can still remember the first time I learned about the function. A colleague of mine at that time was struggling with a report with multiple data providers he had built. He was really annoyed, because he couldn’t get the measures to aggregate properly. Which is exactly the purpose of this function, so when he found out about the (proper) use of the function he was really excited he could make it work after all.
SQL Server 2008 R2 is RTM
A co-worker of mine told me the other day that SQL Server 2008 R2 had gone gold. A bit of research revealed that Ted Kummert, senior vice president of the Business Platform Division at Microsoft apparently announced the RTM status in a conference call. Customers will be able to get this latest version of SQL Server as of the 13th of May and MSDN adn TechNet will be able to download it the 3th of May. The free express edition can already be downloaded. Even though official prices haven’t been revealed yet, it is expected that they will rise by 15 to 25% in comparison to R1. Read more