Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Oracle Tips for MSBI Devs #3: Choosing Drivers

When working with Oracle, drivers are truly a pain to get working correctly.  I will discuss my preferred choice and why for the following tools – SSIS, SSAS, and SSRS. SSIS Drivers Without much question, you should use the Attunity tools for working with Oracle data in the Data Flow…

Read more

0 comments, 470 reads

Posted in DataOnWheels on 24 April 2012

Great User Group Meeting Tuesday, Now on to Madison and SQL Saturday #118

Minnesota SQL Server User Group Meeting Review (4/17/12) First of all, I have to thank the awesome speakers who presented at our user group meeting on Tuesday night, April 17.  Mark Souza ( T | B ) for a great question and answer session.  He was open about SQL Server…

Read more

3 comments, 351 reads

Posted in DataOnWheels on 19 April 2012

Oracle Tips for MSBI Devs #2: Keyword compare between Oracle and SQL Server

While attending a recent Windows Azure Quick Start, the presenter, Mike Benkovich (@mbenko) happened to show a table on his site with this keyword comparison between SQL Server and Oracle so I wanted to pass it a long. The Solution: A list of comparable functions for SQL Server or Oracle…

Read more

0 comments, 332 reads

Posted in DataOnWheels on 17 April 2012

X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)

XMLA can be used to manage the structure of your multidimensional databases.  While many developers use Visual Studio (BIDS), to deploy changes, as systems move to production or need to be more clearly managed, XMLA comes into play. Some of the most common DDL type uses for XMLA including partition…

Read more

0 comments, 415 reads

Posted in DataOnWheels on 10 April 2012

I’m Speaking at SQL Saturday #118 in Madison Wisconsin

If you happen to be in the area on April 21, 2012, join us at Madison Area Technical College – Truax Campus, 3550 Anderson Str., Madison, WI, 53704. For more event details check out the event site for more info: http://www.sqlsaturday.com/eventhome.aspx?eventid=199 Follow this event on Twitter with hashtag #sqlsat118, and…

Read more

0 comments, 314 reads

Posted in DataOnWheels on 4 April 2012

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

The first tip I published discussed how to execute an Oracle procedure with no parameters.  In this tip, I will discuss a technique that works with IN parameters in an Oracle stored procedure. After many unsuccessful attempts at executing a stored procedure with parameters, the following pattern was developed by…

Read more

1 comments, 406 reads

Posted in DataOnWheels on 3 April 2012