How did you provide access to the backup file on blob storage to your SQLMI ?

of course there was a #sarcasm LOL reading this post.

- None of my business side (in-house) clients cares about performance and scalability, but all want best ... until shown the...

did you check with this soluiton ? "Tally OH! An Improved SQL 8K “CSV Splitter” Function"

And its followup comments

how about

go
Declare @Festivaldates TABLE 
             ([createdate]  date NULL
      ...

Also keep in mind you can use QueryStore to have query followup.

Interesting with this is you already have  reports at hand to help you dig into it all

I would go for eXtended Events to capture such information.

could be something like this:

-- Create the event session
CREATE EVENT SESSION DBA_LongRunningQueries ON SERVER
ADD EVENT sqlserver.sql_statement_completed (
 ...

If it is an Azure SQLVM, I would prefer my Azure provider/facilitator to drop the Azure SQLVM and provide you an Azure SQLVM that matches your specs.

That are indeed valid arguments to take into account.

Our world is mainly about being able to cooperate !

That is normal as security has become tighter with the lastest updates.

To ommit this extra security for dbatools you can use

<# https://docs.dbatools.io/Set-DbatoolsInsecureConnection.html
Synopsis

Sets the default connection settings to...

Did you check with DBATools ?

ref:

Export-DbaBinaryFile

Import-DbaBinaryFile

I asked Copilot how to overrule an Nhibernate generated query:

To overrule or customize an NHibernate-generated query, you can use native SQL queries or HQL (Hibernate Query Language). Here are...

Of course, splitting the query and using UNION ALL to put it all together may be an option too.

did you switch from 32-bit version to 64-bit version of the software ? ( We're using the 64-bit versions whenever available )

64-bit versions have always been advised to set max-memory-size...

of course, there's also the database's page verify option, that protects page content ...

Anyone who has write auth on the backup file, can manipulate it.

Will it be restorable?

• use checksum as a backup parameter, so SQLServer checks this and prevents a restore of...