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

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] Date: 11/14/2005

Finally!

As you know, we just declared SQL RTM earlier today. For those familiar with the changes in this...

Author: Ashvini Sharma [MSFT] 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?...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] Date: 09/27/2005

DTS/SSIS and debugging mysterious relational engine deadlocks

Over the last few days I've learnt a lot in how to debug SQL hangs thanks to Sunil from the SQL...

Author: Ashvini Sharma [MSFT] Date: 08/15/2005

SSIS: Handling lookup misses

It's typical in data warehouse loads to have lookups that go against dimension tables. If the key...

Author: Ashvini Sharma [MSFT] Date: 08/04/2005

Adverts

It's finally that part of the release when you see the end of the tunnel and there seems a good...

Author: Ashvini Sharma [MSFT] Date: 07/28/2005

SSIS @ PDC

At PDC this year, Sergei and I will be presenting a session on how to extend Integration Services....

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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:...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] 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...

Author: Ashvini Sharma [MSFT] Date: 07/15/2005