We use certificates while setting up database mirroring for two partners that are in a workgroup or in non-trusted domains.   The idea is to create a certificate on each partner, export it to the other and then setup a login to use that certificate ...read more

When we create a linked server to a database Other than SQL server, like Sybase , Oracle , DB2 etc ,we see some errors and we are not sure whom to contact for support. Should we contact Microsoft support or the third party support. In such an ambiguous ...read more

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

My name is Angshuman Nayak and I am a part of SQL Developer support in Microsoft and work mostly around connectivity and data access technologies. As one of my activities I am helping customers and partners to move from various data bases like Oracle ...read more