Category Archives: No Category
2012 in review
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: 4,329 films were submitted to the 2012 Cannes Film Festival. This blog had 39,000 views in 2012. If each view were a film, this blog would power 9 Film Festivals Click here to see the complete report.
Estimated File Size in BISM Multidimensional(SQL Server 2012)
One property that has changed in the latest release of SSAS, now called BISM Multidimensional, is the Estimated Size of the cube database in Management Studio. This property no longer tells the whole story about the cube database size. Start Management Studio and connect to your SSAS service. Expand the databases folder and righ click …
Power View in Excel 2013 Part Two: Maps
This is my second blog post about the functionality in Power View for Excel 2013 that will show you have easy it is to create map visualizations in Excel 2013. I start with the basic model with relational data from the Adventure Works database with country, calendar year and internet order quantity. What you can …
The Data Warehouse Value Proposition
This is a slide that I am working on tryng to present what the customer pays for compared to running canned reports directly on top of source systems. I do try to avoid details from a customer perspective This is what I have in my mind trying to explain what I am doing …
My Quick Guide to SSAS Query Tuning Part One
The intention of this blog post is to write a practical introduction to SSAS Query tuning with the SQL Server Profiler tool. I think that SQL Server profiler can be very usefu but it also have its issues with delivering too much information and in a very unclear way. I hope that this post can …
SQL Server 2012 Books
With a big release like SQL Server 2012 it can be expected to see some new book titles on the shelf next year. Here is the list that I have found so far: The SQL Server RDBMS Microsoft SQL Server 2012 High Performance T-SQL Using Windows Functions(MS Press 30 April 2012): SQL Server 2012 TSQL …
When Analysis Services 2008 R2 Wakes Up
This is the start of a small series about SSAS performance scenarios that might help in everyday performance discussions with users and customers. The first post is about why SSAS initially can be perceived as slow after a restart of the SSAS service and when the first user connects after the restart. It does not …
SQL Server DENALI Short BI Guide
A lot on my plate for the moment so I had limited time to blog but since I am back in consulting expect to see more posts here after the end of September. SQL Server Denali is a big release from the BI perspective and I will add my own reflections here but Denali has …
Performance and Query tools for SSAS
SSAS consultants and management experts are starved with good tools for analyzing MDX queries. We have nothing. Please vote on connect to make a change to this on this link. This is VERY IMPORTANT.
MVP for the third year
I have got the email yesterday that I am awarded as SQL Server MVP for the third year. This is a great honour and I will work hard during the next 12 months. My blog has moved from Live Spaces to here since MS will not continue with LS. After the migration a lot of …
