<Updated> This Part of my life is called “Designing”

Dated : November 2012 – Unified Diagnostic Ecosystem Campaign Unified Diagnositcs Iniative is driven by a combination of dedicated and virtual team engineers such as the Diagnoistcs leadership team consiting of engineers world wide within CSS, CTS, PFE, the Managed Inovation Team, & GIO in Patener ship with PQO and MSIT.  The core goles are…


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 Project based issue. In this situation, customer was unable to debug stored procedures on a remote SQL Server using Visual Studio. The SQL Server was running on a Virtual Machine that was in a different domain than the domain…


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 information , I felt like I was at a dead end for a few hours.  I was trying to edit the connection string to point the application to a different SQL Server. The Excel form application had that…


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 developer.  The main issue was that we were unable to run the SSIS package that contains a execute process task calling a batch file stored on a remote server machine (without being prompted by a warning window). The following warning…


Error while trying to create a New SSIS project using BIDS 2008

It’s not everyday that a Business Intelligence Studio Developer runs into an Issue which he cannot troubleshoot and fix it all by himself. My friend called into my cell number on a Sunday night , while I was relaxing on my couch watching the Latest episode of Dexter. From his frustrated voice on the other…


A short story about the "SSIS Service that Failed to start ".

<! This is a short story about a how technical support engineer (Mr. Y)  saved the day for one of his Enterprise customer (Mr. X) > One fine morning Mr. X logged into his PC to start working on his pending SSIS project. He wanted to make sure his machine has all the necessary settings…


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 Assistant ). In this video you’ll see the basic architecture of SSMA and different SSMA versions that are available out there in the market. Keep watching this space for more video’s in the near future… [View:http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-01-19-47/8030.ScreenCapture_5F00_09_2D00_10_2D00_2010-19.39.22.wmv]     


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 named instance from a Remote client machine via a asp.net application. The Server instance that he was connecting to already had a TCP alias on the client machine. In the connection string he was specifying “Network Library…


"How to" guide

I was planning to write a pending blog post with different “how to” questions answered. Not limiting the post to any specific Microsoft product / technology , I will keep updating this one as and when I find time to spare. So then , lets get started…. How to check which Domain contoller the Current…