Better apply the latest version (after testing)

SQL 2022 is now supported https://github.com/olahallengren/sql-server-maintenance-solution/blob/master/README.md

If you want to alter the database to enable query store you need ALTER permission on the database.

Can be through the dbowner or grant a specific user alter database rights

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql?view=sql-server-ver16&tabs=sqlpool

Who created the database "Logger_Groups_CI"? Who is the owner

From https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver16

dbmanager

Can create and delete databases. A member of the dbmanager role that creates a database, becomes the owner of that database,...

An alternative for STRING_AGG is SELECT ... FOR XML_PATH

https://www.itprotoday.com/sql-server/ordered-set-functions-whats-new-and-missing-sql-server-vnext

• This reply was modified 2 years, 9 months ago by Jo Pattyn.

Thanks for the extensive list. Haven't really followed up the data world. We had some ransomware breaches in Belgiums cities.

AI makes some serious leaps with art and chat

Those events are...

Also convert '12/31/9999' to a proper date-type for comparison

In Belgium this would read as the 12th of month 31 in the year 9999

Got it open

Full Recovery Model w/o Log Backups

The ... log file has not been backed up in the last week: Is there a transaction backup in place or change the...

Haven't opened the attachment yet.

One of the result columns of sp_Blitz is URL which has more details what the check is about

Like "Active Tables Without Clustered Indexes" -> https://BrentOzar.com/go/heaps

As Andreas wrote, if you have access to the database you can use sp_Blitz, sp_humanevents, sp_WhoIsActive for a quick triage.

For administration of SQL DB's you might also look at dbatools

It's nice to have the dashboard.

You can use it when it's slow ("user request") to make an inventory of troublesome queries / blocking

Most expensive queries by cpu / reads /...

Standard answer for slowness -> what are your waits. Have you already activated query store to find the culprits? Is it patched up

Hyper-V:

Is it someway throttled: powersaving , resource limits,...

Moved the concatenation of tmp columnname in the STRING_AGG

select 'UPDATE '+name+' JOIN tmp USING (mssql_id) SET '+STRING_AGG(table_name +'.' + COLUMN_NAME+'=tmp.' + COLUMN_NAME,',')+';'
from dbo.t_column_details  C left join...

As you use a local smtp server, msdb.dbo.sp_send_dbmail will work find since it only sees the local smtp server.

Maybe your network admin could help configuring the smtp-server?

Do you send mails with Exchange Online through msdb.dbo.sp_send_dbmail?

We use a regular smtp-server for dbmail and  is not impacted (as it doesn't use exchange online)

Why did you pick the SQL 2012 forum? That version doesn't deal with pyspark / dataframes