I don't have synapse to test with.

Collation confict can be resolved by forcing a specfic collation in your query

http://www.ashishblog.com/how-to-resolve-the-collation-conflict-and-how-to-check-collate-in-sql-server/

It could be that the collation of tempdb ( as you...

Apperently it can with an alter statement

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/28ee3de6-9dc7-4f4a-9663-cafa531d64c2/tde-how-to-change-encryption-key-algorithm-from-128-to-256

Thanks for the deep dive

No experience. Would start with updating odbc drivers. 8.0.29 seems to be the most recent version . https://dev.mysql.com/downloads/connector/odbc/

Depends on what you will do with it. Do you quickly need to answer what is the second course Worker01 took in Year Y?

Usually the first form WorkerId Year CourseCode...

Are the statistics up to date?

Found this on deleting old items on blobstorage like implementing a policy

https://stackoverflow.com/questions/56903837/delete-files-older-than-x-number-of-days-from-azure-blob-storage-using-azure-fun

Could be a counter table? Like new order -> update counter ( write )

Perhaps

SELECT MAX (vacationhours) as 'Max_VacationHours', MIN (vacationhours) as 'Min_VacationHours'

From [HumanResources].[Employee]

Thanks for all the daily /weekly newsletters

Thanks, how did you couple it with a workflow?

I'm not aware of such setting. https://docs.microsoft.com/en-us/sql/integration-services/data-flow/flat-file-custom-properties?view=sql-server-ver15

I guess it is usually handled at the input side / codesnippet to make sure you don't go over 96mb of data

It could be timing out. Contact your McAfee ePO vendor.

An sich it shouldn't be a cause for the empty dashboards.

Normally the collation order is column >  database > server. Maybe it's connecting to the wrong database?

So the step to 2017 was required?