Alternately, you could use windowing functions to sum the decals column like:

SUM(decals) OVER (PARTITION BY a.FSTRJURISDICTION, d.fstrFormattedID, inv.flngNumItems, ar.fstrStreet, lic.fstrStatus, a.fstrFuelType)

Not ideal as you will get 1...

I do not know a lot about Azure data factory, but looking at the screenshots, it LOOKS to me like you are only pulling 1 column from ParquetSource.  When you...

One other thing to look at would be bandwidth.  On-Prem, you may have a Gb ethernet connection between you and the server.  In the cloud, you may have reduced bandwidth.

As...

First, welcome to the SQL Server forum... next, you posted this in the wrong section.  You are not running SQL Server 2019, you are running MariaDB.

I would recommend looking up...

I think the easiest way to fix a "log file full" is to increase the size of the log file, but that assumes you have disk to do so.

When you...

To add to everyone else asking about the code, are you sure it is the function that "crashed the ETL - it now never finishes."?  I am wondering if MAYBE...

I've not worked with JSON in SQL before, but my first debugging step would be to do a SELECT @json to make sure that you got the full data from...

The other thing to keep in mind is do you have anything else running on that server?  From a SQL Server standpoint, SSIS, SSAS, and SSRS all use their own...

If you don't need the end user connecting as themselves, you could have it connect as a specific user on the remote machine.  Downside is you may need to create...

I think this really falls under "it depends".

Are you already licensed for 2019 (ie do you have software assurance OR do you need to buy 2019)?

Are there features in 2019...

I rarely do an uninstall.  What I do when I decommission a SQL instance is to stop the services and change them to disabled.  I've had odd hiccups when doing...

I agree with Grant here, and would like to add that you miss 100% of the chances you don't take.

I know in my organization, once a product hit a certain...

First thing, posting an Oracle question in the SQL Server 2016 forum section is likely not going to get many results (if any).

Next, I am confused why you posted here...

This is a multi-step process and depends on your requirements, but one approach would be to use what you have but turn the AVG into a windowing function and store...

On top of books, it may be beneficial to take some training courses.  There is a LOT of training available out there.