Month: January 2019

First published on MSDN on Jan 24, 2018

You may want to know what registry keys will be added to system for a SQL server installation. If you use some registry snapshot tool to compare the window registries change of before and after t… Continue reading SQL Setup ToolSuite Introduction (3) – SQL Registry Viewer Version 2.2→

First published on MSDN on Jan 24, 2018

Oftentimes when I worked on a setup case I hope I have a simple tool to tell me the detailed installed product properties and patch information. In Windows control panel I can find all installed … Continue reading SQL Setup ToolSuite Introduction (2) – Product Browser→

First published on MSDN on Jan 24, 2018

If you have encountered missing cached MSI/MSP issues during SQL server setup, you may have knew below article:

How to restore the missing Windows Installer cache files and resolve problems … Continue reading SQL Setup ToolSuite Introduction (1) –FixMissingMSI→

First published on MSDN on Jan 16, 2018

I have come across an interesting scenario recently while working on one of the customer issues. The SSIS package fails during the execution, even though the Test Connection and Preview Dat… Continue reading TLS Issue with SSIS package while accessing OData Source like Dynamics AX Online→

First published on MSDN on Dec 29, 2017

I came across an interesting issue related to Flat file connection manager which doesn’t work for rows containing “Embedded Qualifiers”. I have worked with two different partners and both were ha… Continue reading Flat file connection manager doesn’t work for rows containing “Embedded Qualifiers”→

First published on MSDN on Dec 21, 2017

Multisite availability groups allow customers to deploy copies of business data across multiple sites, for disaster recovery and/or for reporting purposes, offering near real-time changes ava… Continue reading Analyze Network Latency Impact on Remote Availability Group Replica→

First published on MSDN on Dec 01, 2017

Recently we ran into an interesting scenario where we had a SSIS package that contained a script task and inside the script task, we were making connections to Azure File Storage and pulling the … Continue reading SSIS packages executed through SQL Agent Job scheduler fails while connecting to Azure File Storage Path→

First published on MSDN on Dec 01, 2017

Understanding of the issue:

Adding the scale out worker to the master shows successful but this does not show up in the SQL Server integration services – Manage Scale Out (IS… Continue reading SSIS Scale Out worker is not showing up in Worker Agents→