I read you've already prepared it using DMA.

You'll have to address your devs or software vendor(s) to have them test their apps against your target db level.

I would aim to...

If I remember well, a regular sqlserver instance needs a startup parameter to be able to handle databases which are hosted on a remote share.

Why on earth do you want...

• This reply was modified 1 year, 4 months ago by Johan Bijnens.

Did you check this article . https://techcommunity.microsoft.com/t5/azure-sql-blog/using-query-store-with-least-privileges-instead-of-db-owner-to/ba-p/775177

If relationship is 1 - 1 -> inner join

If relationship is 1 - n -> exists

Don't you monitor your connections (using XE) ?

"Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Why not just schedule the TSQL statement in a sqlagent job?

or use a powershell jobstep to create the backup using sqlagent ( or scheduled tasks if for express edition )

are you querying cross domain ? ( add the domain extention ! )

I have to scan a bunch of servers for failed logins. As part of this process, I want to get the incoming host names. However, the SQL log file...

Thank you for the...

Start with avoinding functions in where clauses ! ( needs full ( index ) conversion before actual use )

Declare @RefTs datetime2(0) = dateadd(MM, datediff(MM, 0, GETDATE()) -...

Can this ref be applicable for your issue?

gMSA account authentication failure during password rotation

spid -2 is supposed to be an orphaned DTC transaction.

ref: Disaster recovery 101: dealing with negative SPIDS (-2 and -3)

Johan, you would need to check with the vendor, but I don't belive that performance improvements are the core reason. I belive that for some special purposethey choose KS+WS...

It is indeed scheduled in the weekend (using SQLAgent and Powershell).

Still 23 minutes is a long time to collect these statistics for this single database.

It's a good thing not all...

Currently we are collecting database statistics information using

select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED')

For some larger databases this statement takes more than