SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


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…

Read more

0 comments, 888 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…

Read more

0 comments, 779 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…

Read more

0 comments, 501 reads

Posted in DataOnWheels on 18 September 2012