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...
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...
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...
Date: 05/14/2011
Testing SQL Connectivity with Machine Account
Many times during troubleshooting SQL Server Connectivity, we face the challenge to test our...
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...
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...
Date: 06/09/2010