On what in Azure?

Azure SQL Database? If so what size? Is it DTU? Is it vCore?  What config?

Azure...

Options for this would be

1 - fix forward

2 - restore the pre-update DB side by side or on another server and use things like RedGate schema compare to revert the...

Well what is the reasoning behind rebuilding indexes?  Performance? And has it been proven that the index rebuild actually helps or is it the UPDATE STATISTICS by product which is...

Can be done your logic is just a little off.

The "ParamDefinition" must be a continuous string of all params for the dynamic SQL

DECLARE @t [dbo].[ChannelReadingType];
DECLARE @ChannelReadingTableName ...

Something is blocking/holding a lock on the query the GUI is trying to run.

Use things like sp_who2 / sp_whoisactive (http://whoisactive.com/) / sp_blitzlock (https://downloads.brentozar.com/FirstResponderKit.zip), to see what is holding a lock...

I would use "sp_whoisactive" and store this in a table frequently, have a job to run it every 10 seconds or so to capture what you need and then you...

No I didn't, I don't fully understand your requirements.

Please generate what data is needed to be in the "final result set" based on the data in the BACPAC and it...

Yes, but you really shouldn't do it

You...

Ah OK, your talking about OS based maintenance not SQL / DB maintenance.

So take a look at MSDB and the backup history tables, work out how big the log backups...

SOUNDEX is going to be the closest thing in T-SQL to do it, but it wouldn't match LASIX to LASI as the sound isn't the same.

Just note it's non-SARGable so...

There is no true and tested method, and it all depends how you're doing the maintenance.

If doing things in serial, like most index rebuilds etc, find your biggest index size...

You can gather statistics using this object sys.dm_db_index_usage_stats

It will provide information about seeks, scans, updates etc.

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver16

SELECT 
    DB_NAME(database_id) AS [Database Name], 
...

Look through the MSDB, everything you need and more is in the system tables in that DB.

sysjobs

sysjobsteps

sysjobhistory

You would need to monitor all that, you can track the table spaces quite easily, there is s built in report to do it.  However the query which caused the...

You need to monitor the default trace for event ids 92/93/94/95, how often you need to gather this information will depend how busy the server is. A very busy server...