Monthly Archives: November 2010

Windows Azure learning resources

Want to learn about Azure, Microsoft’s cloud platform? You could do worse than to head on over to Buck’s place for his Windows Azure Learning Plan series of posts.

Posted in Uncategorized | Tagged | Leave a comment

Microsoft white paper on Columnstore Indexes in SQL Server Denali

Here is a white paper by Microsoft describing how the new columnstore indexes in SQL Server 11 (codenamed Denali) can massively improve Data Warehouse query performance. Microsoft mentions the main business benefit is to allow you to encourage your users … Continue reading

Posted in News | Tagged , , , , , | Leave a comment

BISM and the SSAS Roadmap- the Microsoft response

At PASS Microsoft unveiled details of their big new addition to the Microsoft BI stack: BISM. It has caused quite a stir in the community, primarily because of concerns about where this leaves OLAP cubes and MDX. Here is the … Continue reading

Posted in News | Tagged , , , , , | Leave a comment

Cubes/MDX on their way out… BISM to replace them?

The latest news from the PASS summit is that Microsoft are starting to prepare SSAS for the retirement home, in favour of a young gun by the name of BISM. BISM (BI Semantic Model) is an attempt to unify the … Continue reading

Posted in News | Tagged , , , , | 3 Comments

SQL Server Denali CTP and Parallel Data Warehouse RTM

I was very excited yesterday about the announcements at SQLPASS re: the next version of SQL Server, codenamed Denali, newly released as a CTP. For more details check out SQLPASS 2010 Keynote. Now the dust has settled, the important bits … Continue reading

Posted in Conferences, News | Tagged , , , , , | Leave a comment

Optimising a complex query in MySQL: avoid derived tables!

Recently I had to optimise a query that was part of some slow-running ETL: it was taking longer than its allocated load window, and when run it would bring the source systems to their knees. Here’s how I solved it- … Continue reading

Posted in Solutions | Tagged , , , , | 2 Comments