When permitted by the vendor, we upgrade test to the latest available. The next version is probably there when testing is over in some scenario's

Do you have the full ODAC installed or the xcopy only?

I always install the 64-bit odac first and later on the 32-bit (for visual studio) in a different home

1. 64-bit...

If you have a support contract you can send the dump to MS. Perhaps you hit an unknow bug.

Try to get a testbest and verify your backup/restores.

As it had no patching, you should patch it to the latest cumulative pack.

You should surely be concerned.

Is the instance up to date (CU 14?)

You could join a date-table with your information.
pseudocode:

select mydate,sum(rate) total
from datetable
inner join ratetable
on  datetable.datekey>=ratetable.startdate
and  dataetable.datekey<=ratetable.enddate
group by mydate

Didn't try...

Awesome article. Starting to comprehend failover clusters.

Thanks for the update

Why did you pick data lake storage gen 1 instead of gen 2?

If you move to the cloud, cross database queries are even slower. (less control where the databases are placed)

Does the VM has Vmware Guest tools installed? Otherwise the VM is slow because the VMWare host has to emulate everything (hardware etc) with cpu power. Installing the tools:

Thanks for the article.
The code about create or alter , just before the nocount section, mentions "drop if exists" instead of "create or alter"

You may find a lot of articles made by Koen Verbeeck.
Like trying out the auto adjust buffer size https://www.mssqltips.com/sqlservertip/4221/improving-data-flow-performance-with-ssis-autoadjustbuffersize-property/

my goto place for oracle is http://www.orafaq.com/
Quite a responsive forum when you provide the necessary information

An active blog: http://www.oaktable.net/feed/blog-rss.xml

Pro's of seperating ssrs from database server:
More resources available for the database
More control of resources used. Resource management in SSRS is limited
Possible to reboot SSRS without impacting...