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: March 2012

Why I am excited about SQL Server 2012 (Part 2)

Earlier this month I published a blog entry on this same subject.  In honor of the local Minneapolis launch event, I decided to expand the list.  You can find five more reasons I am excited out on Magenic’s blog. Here is the link and enjoy SQL Server 2012. http://magenic.com/Blog/WhyIAmExcitedaboutSQLServer2012Part2.aspx

Read more

0 comments, 684 reads

Posted in DataOnWheels on 28 March 2012

X on XMLA: ii. Basic Structure of XMLA

The second post in the XMLA series focuses on the basic structure of XMLA.  At its heart, XMLA is XML.  As a result it is usually not a comfortable work environment for most database developers or administrators.  It is no different for Analysis Services developers or administrators.  While a discussion…

Read more

2 comments, 677 reads

Posted in DataOnWheels on 27 March 2012

PASS for Today (and Tomorrow)

I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate (@stratesql) are teaming up to bring you “Choose Your Own Adventure – Performance Tuning”. Join us at the Microsoft Technology Center in Edina, MN or online for this great adventure.…

Read more

0 comments, 576 reads

Posted in DataOnWheels on 20 March 2012

Why I am excited about SQL Server 2012

By now many of you have had the opportunity to hear or see something about the next release of SQL Server.  It is later on March 7, launch day.  I have enjoyed a number of sessions on the SQL Server Launch site.  Many people have talked about what they look…

Read more

0 comments, 665 reads

Posted in DataOnWheels on 8 March 2012

Oracle Tips for MSBI Devs #1: Executing an Oracle Stored Proc with No Parameters in SSIS Execute SQL Task

Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those of us who are delivering Microsoft Business Intelligence solutions using Oracle in some way. The Solution: In an Execute SQL Task the proper syntax for executing an Oracle stored procedure…

Read more

0 comments, 562 reads

Posted in DataOnWheels on 4 March 2012