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

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

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…

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.…

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…

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…