Thank you for the feedback 🙂

If you only take full and diff backups, I assume your databases are in simple recovery model ( or your db log file(s) will keep on growing after the first...

You need to grant the sql server service account auth to get to the new backup file location/share

IMHO AzureMI have been brought to life to have people be more keen to (try to) migrate and land on an environment they are familiar with.

• DBMail needs specific attantion

...

Keep in mind you windowing functions work on the result set itself !

Since you want to have time series reporting, you need to make sure your rows cover occurrences for...

After errorlog investigation:

first thing to do is to take another LOG backup ( if db recovery model <> simple )

Then restore from full backup and add the needed DIFF and...

Did you investigate Filestream or FileTable options ?

Backup only takes the pages as is and calculates a checksum based on that data.

Checkdb actually checks it all.

on top of that:  What's the page_verify option set for your...

You need to specify to support unsecured connections 🙁

I hope your applications do not use table hints to force the use of a given index.

Also doublecheck the indexes are enabled !

( maybe disabled for 99% of...

Does sys.index_resumable_operations hold data?

Ah

#Context

Do you have the link to the "dup post"?

If you cannot switch the sql server service to use a domain account, you'll have to grant the file share to the computer account.

I always add such attributes to the action part of the ADD EVENT

CREATE EVENT SESSION [DBA_purpose] ON SERVER
ADD EVENT sqlserver.database_file_size_change (
ACTION ( sqlserver.client_app_name, 
 sqlserver.client_hostname, 
 sqlserver.database_name,...