A SQL Server Blog
The impact of Gemini (Or the power of a simple question)
If you're reading this, you've probably heard about Project Gemini, the Self Service Analysis...
Date: 10/08/2008
Big news at the BI Conference. Are you coming?
Hi folks, It's been a while since I posted. I'm back in the Analysis Services team now where we've...
Date: 09/09/2008
Nsort is ready!
For the past few months, a few of us have had the pleasure of working with Ordinal to create an...
Date: 03/14/2006
Metadata tool and whitepaper for BI components
Hi again, Over the last few months a lot of you have expressed a need to do impact analysis and...
Date: 12/21/2005
Biztalk, SSIS, Indigo, SSB, AAAAA!
This is a FAQ that we get at least once every time we present. I got it last week doing launch...
Date: 11/14/2005
Finally!
As you know, we just declared SQL RTM earlier today. For those familiar with the changes in this...
Date: 10/27/2005
SSIS: Lookup from Text Files
Ever want to do a lookup on a text file without putting it in a database or using a merge join?...
Date: 10/24/2005
SSIS: Debugging foreach NodeList enumerators
Earlier today Fred S. asked a great question. "Using the following data I’m trying to get each node...
Date: 10/21/2005
SISS: Providing parameters when providers don't support them
This has come up a few times recently, and I couldn't find the information for them in the usual...
Date: 10/20/2005
SSIS Best Practices - Performance
We've been slowly creating a list of best practices. Simon asked me about these at the PDC a couple...
Date: 09/27/2005
"It is illegal to call out while inside message filter."
One of our ISVs ran into an issue that others writing managed code interoping with COM (nothing to...
Date: 09/27/2005
SSIS: Handling lookup misses
It's typical in data warehouse loads to have lookups that go against dimension tables. If the key...
Date: 08/04/2005
SSIS @ PDC
At PDC this year, Sergei and I will be presenting a session on how to extend Integration Services....
Date: 07/20/2005
Extending SSIS webcast later today
At 1PM PST today, I'll be doing an MSDN Webcast on how to extend Integration Services including how...
Date: 07/18/2005
New Blog Location
Hi there, I'm a member of the SQL Server Integration Services team and previously had a blog here:...
Date: 07/15/2005
SQL: Performance of incremental bulk insert
Bulk loading into a table that already has records is a common scenario. A lot of folks ask how can...
Date: 07/15/2005
SSIS: Logging in pipeline components
Ethan from AMB Dataminers had a great question about how to do logging through his pipeline...
Date: 07/15/2005