too many ? There should only be a single one !

ref: https://blog.sqlauthority.com/2020/04/11/sql-server-multiple-log-files-to-your-databases-not-needed/

( I only temporarily used a second ldf file to be able to extend to a new disk and...

Also keep in mind by default it will only report progress every 10 % !

Use Jeffrey's script to have the prognosis.

Here is a nice reference by Brent Ozar regarding RCSI: "Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide"

Have a look at the "Gotchas With Implementing...

How correct do you need your results to be ?

Check this great blog post by Paul White:  "The Read Uncommitted Isolation Level"

Asking around how colleagues handle it or web search for a minute, especially nowadays, chances are someone already 90% published of what you need.

Although I must admit: "what you automate,...

Ask for "view definition" to be granted to you, so you can seed an objects composition.

GRANT view definition TO [user_or_role]

also keep in mind, the SQLServer service account needs to be granted usage of the given paths !

Did someone add the registry key settings to disable the old TLS and/or SSL protocols ? ( and not reboot the node at that time )

That is not advisable as this will always start the job, even when it is disabled !

My point is:  When a sysadmin or "sqlagent job manager" disables a job for...

check out msdb table dbo.sysjobhistory

it logs execution times per step.

I'm the same way until I have two 12 ouncers of coffee under my...

• This reply was modified 3 years, 8 months ago by Johan Bijnens.

We use sqlserver alerts ( raiserror 50000+ ) and have sqlagent respond to it and launch a given job.

Keep in mind it may take SQLAgent up to 20 seconds to...

• This reply was modified 3 years, 8 months ago by Johan Bijnens.

the options are documented: Overview of business continuity with Azure SQL Database & Azure SQL Managed Instance

and Restore a database in Azure SQL Managed Instance to a previous...

Oh no ....

Since you're stating your next step is AI, why don't you have a look at Azure SQLDB ?

It gives you SQLServer EE, but with the flexibility of number of cores...