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…

12

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

6

Virus Programming

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 about basics of virus programing.LogicIt is easy to mess-up the…

4

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…

3

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…

3

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…

2

Think Week Poster Designs

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 throw might light in the direction of Next-Gen technologies. These posters were designed as a…

1

small talk about Database Connections

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 connections in my application. ” After my best effort to calm him down…

1

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 32-bit server. The error I received was: OLE DB provider “SQLNCLI” for linked server “servername” returned message “Unspecified error”. OLE DB provider “SQLNCLI” for linked server “servername” returned message “The stored procedure required to…

1