Ask the vendor of the tool for help?

Is the database "offline" or the folder "" offline?

Have you tried fiddling with the folder permissions ( perhaps the tool, sql server, your...

No, SSAS keeps the memory as it is usefull for caching. It will try to keep a minimum of free memory on the server. When lowmemory is triggered, start cleaning...

We only have one server with one catalogue.

We use it to override settings that may come from deployments. New project -> Configure -> Link to environment. You may not need...

Retry logic in SQL is difficult as there may be errors that kills your session. You could use try catch but it's still tricky

https://www.brentozar.com/archive/2022/01/error-handling-quiz-week-making-a-turkey-sandwich-with-xact_abort/

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?