Dipanjan's WeBlog

From Impossible to I-M-Possible

You may see weird behavior when using the SSIS Object Model from an ASP.NET application

SSIS comes along with a rich set of application programming interfaces (APIs) for programming the...

Author: Dipanjan Banik Date: 07/14/2011

Query Designer in SSIS 2008 builds bad query when column name is same as table name with SQLNCLI10 Provider

I was working on a case yesterday and an interesting issue came up. A customer was migrating an SSIS...

Author: Dipanjan Banik Date: 05/19/2011

You may see an instant timeout when connecting to a SQL Server Mirrored database from a .Net application

I can't take the credit for all this content as many of my colleagues were part of the investigation...

Author: Dipanjan Banik Date: 05/14/2011

Testing SQL Connectivity with Machine Account

Many times during troubleshooting SQL Server Connectivity, we face the challenge to test our...

Author: Dipanjan Banik Date: 03/07/2011

“SSPI handshake failed” could result when the security event log has reached the maximum log size

I see a lot of issues related to SQL Server connectivity. One common error I see in the SQL Server...

Author: Dipanjan Banik Date: 12/08/2010

SQL Server Query Performance when running query from a Windows 2008 Server

Recently I faced two cases in which we can see slow query performance when we run a SQL Server query...

Author: Dipanjan Banik Date: 06/09/2010