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

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

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

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

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

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

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

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

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

I was working on one the Enterprise customer Incident. The issue at hand was that we were unable to use Oracle Synonyms in a Four part naming query against a SQL-Oracle Linked Server. To probe the scenario, I had to set up a repro locally. Step 1 ...

Thinkweek is an open forum that enables any Microsoft Employee to share well formulated thinking in the form of carefully wrtitten papers circulated among the Microsoft Leaders. Ideas of the brightest minds can shape the future products of Microsoft and...

I had a customer who had this PROBLEM . He said " My Connection strings have changed! I don’t know how to get the right connectionstring in my application, and with .NET’s automatic garbage collection, I’m never quite sure what’s going on with database...

I ran into an issue creating a linked server on SQL 2005 64-bit. I was trying to connect to a 2000 32-bit server. The error I received was: OLE DB provider "SQLNCLI" for linked server "servername" returned message "Unspecified error". OLE DB provider...

Everybody is scared of computer ‘virus’ as it does harmful actions on our computer. But when we look into the virus programming, we may certainly come out with the conclusion that it requires intelligence to code a virus.so it hought i pen down an article...

Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. When this happens, SQL Server identifies the problem and ends the deadlock by automatically...