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

Author: ajaykumarks 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...

Author: ajaykumarks 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...

Author: ajaykumarks 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...

Author: ajaykumarks 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...

Author: ajaykumarks Date: 08/25/2010

"How to" guide

I was planning to write a pending blog post with different "how to" questions answered. Not limiting...

Author: ajaykumarks 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...

Author: ajaykumarks Date: 06/15/2010

Think Week Poster Designs

Thinkweek is an open forum that enables any Microsoft Employee to share well formulated thinking in...

Author: ajaykumarks 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...

Author: ajaykumarks 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...

Author: ajaykumarks 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...

Author: ajaykumarks Date: 02/16/2009