|
|
|
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
webmaster@sqlservercentral.com.
Contact the author
All Blogs
Feeds
Archives
for this blog
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
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
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
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
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
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
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
|
Subscribe to this blog
