Merge join unpredictable behaviors

Today while on SSIS package, found very strange behavior where I will keep seeing rows coming for update but nothing would update because there was nothing to update.

Also would see rows that exist in destination but Merge join will bring them for insert. Strange!

After hours of research, found if you have "Sort" defined in one source in SSIS and order by defined in other source inside SQL Server then you will see all kind of unexpected behaviors.

Sort operation in SSIS is caSE Sensitive and it will NOT work right if there is data source that already is sorted in sql server.

So in short:
1. Dont mix sources with "Sort" in SSIS and with "order by" defined in sql server.
2. Sort operation inside ssis is caSE sensitive.
3. Keep one of the order by kinds. Either all from sql server or just defined inside SSIS.


HTH

Testing SSIS connectivity hangs...

Hi,

If you are experiencing "Testing Connectivity..." hang issue where the VS is just waiting then it is OK to kill the instance and review the packages using text editor.

In my case I had Connect Timeout = 0 and if server names were not present, the VS will never stop searching for it.

I had to open SSIS package in Textpad, search for Connect Timeout setting and change it 30(seconds) from 0.

OR

Other option would be to Work Offline.
But this option will only be set once the package open fully after Testing connectivity is done.

HTH.

Visual Studio 2019 - SSIS Project InCompatible

Hello, You will be surprised that Visual Studio itself will give you hint to disable SSIS extension.

and once you disable this extension, your SSIS project is not compatible with VS 2019 any more.
To fix this, you need to do re-enable it.

Choose Extensions > Manage Extensions. Go to Installed enable it there.

HTH

CosmosDB Emulaor won't work - Query Explorer keep on running...

If you getting this error or with similar string:

{"readyState":4,"responseText":"{\"code\":\"ServiceUnavailable\",\"message\":\"Service is currently unavailable.\\r\\nActivityId: 9c9f56f8-91f9-4fad-b592-0c6bd5bbd300\"}","responseJSON":{"code":"ServiceUnavailable","message":"Service is currently unavailable.\r\nActivityId: 9c9f56f8-91f9-4fad-b592-0c6bd5bbd300"},
"status":503,
"statusText":"error"}

There are few suggestions to fix this error like perform a "Reset Data" on the Emulator. 
Sometimes this doesn't even work.

Restarting PC have worked for me all the time. 

Please try and let me know if it fixed your issue!

How to get out of ~ (END) displayed in terminal window?

Press q in the window to be out.

HTH

View saved messages on Microsoft Teams

1. To view your saved messages on teams, click on picture icon on top right corner.
2. Click on Saved.

That's it.

Preview pane gmail (new version)

If you are like me who cannot find "Labs" in the settings, forget it because it is not there.

To enable outlook like reading pane feature,

1. Click on gear icon on top right corner.
2. Click on Settings
3. Choose Advanced Tab (3rd from right as of today)
4. Enable Preview option
5. Save Changes.

HTH