Fuzzy Lexicon - a roadmap to blend art with technology
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