August 2009 Blog Posts

SQL Saturday #23 in Louisville, KY

I'll be speaking at the SQL Saturday #23 event held in Louisville, KY on October 24th, 2009. I will be giving two sessions, the first of which will be on SQL Server 2008 R2 and Project Gemini: BI for the Masses. My second presentation will be on a topic very near and dear to me, Change Data Capture (CDC) with Attunity's lineup of great CDC products. Long ago (before CDC was commonplace) I was charged with creating a real-time ETL process. It was a challenging requirement but at the end of the day it was meet (albeit with some roadbumps but thats to...

SQL Server 2008 R2: Quick Tips from the Forums

Forums are a great place to help your peers as well as learn quick tips/points on various Microsoft technical products.I am participating in the SQL Server 2008 R2 pre-release forums as both a moderator and a answerer. I will kick-off this post with some of the more valuable quick-tips I have come across regarding SQL Server 2008R2 in the pre-release forums, going forward I hope to keep this post current with new findings. Note: Some of these tips may seem obvious to SQL Server experts, however for more typical users of the product these are more valuable/applicable: Windows...

SQL Server 2008 R2: Gemini Opening Up New BI Doors

I have been tracking the progress of Gemini and SQL Server 2008 R2 for quite some time now. I've been able to recently experiment with the tool inbetween my mainstream work and community activities. Here are some of my thoughts about the new self-service BI technology and its potential impact on the industry... Gemini is a powerful tool for empowing the Information Worker (IW) in their ad-hoc analytical needs. IWs no longer require someone like me for their ad-hoc analytics and they can build these ad-hoc models with relative ease. Gemini is also a very performant solution both in terms of developing the ad-hoc...

Addressing the MSFT BI Naysayers

Update: Check out Richard's (he posted a comment on this post) about his own thoughts on MSFT BI Delivery and Leadership Topics here: http://thoughtsonbi.blogspot.com/ . I agree with just about everything he states. Overall, could MSFT BI be a better story (see ProClarity)? YES. Does MSFT need a better, unified platform vision for it's BI story? YES. All that being said, the MSFT BI software products are good platforms for building an enterprise BI solution on top off. As Richard mentions, 90%+ of an actual implementation's success depends upon the people involved (both consultants and customers).   Every so often, I receive...

Attunity Receives Readers Choice Award for Oracle-CDC for SSIS

If you have not yet checked out Attunity and their line up of data integration components for SSIS your missing out! Attunity is without question one of the elite SQL Server Integration Services (SSIS) 3rd Party Providers and the company's recent award of a Reader Choice Award from Visual Studio Magazine is yet another sign of the company's commitment to SSIS Excellence. This award was in reference to Attunity's recently released Oracle CDC for SSIS product (a personal wish list item of mine). The full press release can be here: http://www.attunity.com/press_releases.aspx?newsId=1262 Happy Data Integration! Derek

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski