Merry Christmas

I just wanted to take a moment to wish a Merry Christmas to you: people in the SQL Community; people I see at clients and the like; and especially those people I am incredibly privileged to have working at possibly the best SQL Consultancy in the world. To those who I have represent my brand: … Continue reading Merry Christmas

Retrieving N rows per group

Sometimes a forum response should just be a blog post… so here’s something I wrote over at http://dba.stackexchange.com/a/86765/4103. The question was somewhat staged I think, being from Paul White (@sql_kiwi), who definitely knows this stuff already. His question: I often need to select a number of rows from each group in a result set. For … Continue reading Retrieving N rows per group

Will 2015 be a big year for the SQL community?

In Australia, almost certainly yes. Australia recently saw two Azure data centres open, meaning that customers can now consider hosting data in Azure without worrying about it going overseas. Whether you’re considering SQL Database or having an Azure VM with SQL on it, the story has vastly improved here in Australia, and conversations will go … Continue reading Will 2015 be a big year for the SQL community?

Minimising Data Movement in PDW Using Query Optimisation Techniques

This is a white paper that I put together recently about APS / PDW Query Optimisation. You may have seen it at http://blogs.technet.com/b/dataplatforminsider/archive/2014/11/14/aps-best-practice-how-to-optimize-query-performance-by-minimizing-data-movement.aspx as well, but in case you haven’t, read on! I think the significance of this paper is big, because most people who deal with data warehouses (and PDW even more so) haven’t … Continue reading Minimising Data Movement in PDW Using Query Optimisation Techniques