Look out world! Microsoft has finally given a pretty good roadmap for the next major release of SQL Server Denaliâ€.
SQL Server Denaliâ€ looks pretty interesting with a new thing called the BI Semantic Model. On the face of it, Microsoft has a very compelling Business Intelligence offering that truly unifies Relation data with Multidimensional (tables and cubes). What does that mean? Hopefully one query, one business question can get the consolidated, aggregated and calculated information or report instantly without any one needing to know if the data is stored in cubes or tables. Business people consuming reports don't really care where the data comes from do they? As long as they get is FAST!
FAST means fast query time and FAST development time. Building business models faster for faster consumption.
Chris Web raised an a couple of issues with this new version of SQL that were:
These issues have been put to bed and Chris explains here.
Now, the BI Semantic Model. Here is a picture to get started.
Basically it is an interface that offers:
I can't wait to get my hands on SQL Server Denaliâ€. The full version will have all the new functionality but the CTP's will have to do for now. Every new version will have a new feature turned on so it is something to wait for.
What about CALUMO and SQL Server Denaliâ€? It takes James our Software Development Manager about 4 minutes to spin up a new server using Microsoft HyperV and add it to CALUMO's fully integrated testing regime. We expect the next CTP to have the required features CALUMO needs to do some testing and development. SQL Server Denaliâ€ is very exciting for us at CALUMO. CALUMO will remain the one place to go to knowâ€.
If you want more information, please email me firstname.lastname@example.org or leave a comment.