Technical skill is mastery of complexity, while creativity is mastery of simplicity.
Unable to do remote SQL Stored Procedure debugging from VS2010
This post describes an interesting scenario that I came across when working with on Visual Studio...
Date: 10/22/2011
Unable to edit the connection string information in Excel 2003 Forms
Last week while i was trying to edit an Excel form based application to modify the connection string...
Date: 07/23/2011
An issue that occured when a SSIS Execute Process task was calling a remote batch file.
This post describes an interesting scenario that I came across when working with a SSIS package...
Date: 07/23/2011
Microsoft SQL Server Migration Assistant - Video Series - #1
This is a short video series on Microsoft's new Data Migration utility : SSMA ( SQL Server Migration...
Date: 10/09/2010
Connectivity to SQL server fails when "Network Library = dbmssocn" is used in addtion to having a TCP alias
I recently came across this interesting issue : The end customer was trying to connect to SQL server...
Date: 08/25/2010
"How to" guide
I was planning to write a pending blog post with different "how to" questions answered. Not limiting...
Date: 07/01/2010
Linked server SQL <->Oracle and a revelation about using Oracle Synonyms in Four part query
I was working on one the Enterprise customer Incident. The issue at hand was that we were unable to...
Date: 06/15/2010
Think Week Poster Designs
Thinkweek is an open forum that enables any Microsoft Employee to share well formulated thinking in...
Date: 06/09/2010
small talk about Database Connections
I had a customer who had this PROBLEM. He said " My Connection strings have changed! I don’t know...
Date: 05/16/2009
Creating a Linked Server from SQL 2K5 64-bit to SQL 2K5 32-bit
I ran into an issue creating a linked server on SQL 2005 64-bit. I was trying to connect to a 2000...
Date: 05/12/2009
Deadlock issues in Sql Server
Deadlocking occurs when two user processes have locks on separate objects and each process is trying...
Date: 02/16/2009