Subscribe to this blog
DataOnWheels
Steve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. He also provides insights from the field on his blog at http://dataonwheels.wordpress.com.
Archives: September 2012
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012 in this area are phenomenal. They solve a myriad of issues including calculating running totals with SQL. Check it out if you want to learn more and get some simple…
0 comments, 312 reads
Posted in DataOnWheels on 26 September 2012
X-XMLA: vi. Processing and Out-of-Line Bindings in XMLA
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to incremental process with out-of-line bindings. This will provide you with additional samples to examine the results of partition processing with XMLA. Note: these examples use the Adventure Works DW 2008R2…
0 comments, 257 reads
Posted in DataOnWheels on 19 September 2012
SQL Saturday #149 and CodeMastery–Minnesota Events
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference sessions on September 28. In case you haven’t heard, we are having the main event on a Saturday. Yes, the precons are on Friday this year. Check out the details…
0 comments, 207 reads
Posted in DataOnWheels on 18 September 2012