FWIW: I've read on multiple threads regarding "backup database", providing parameters , BUFFERCOUNT = 17 , MAXTRANSFERSIZE = 1048576  have better results regarding performance of the command in...

If the auto-growth cannot respond before its timeout has passed, you'll receive this error message.

The extent will happen eventually.

Please double check.

I fear not .... at this time

did you also read the "For additional details about the Kerberos and MaxTokenSize, see KB327825" link? ( https://learn.microsoft.com/en-US/troubleshoot/windows-server/windows-security/kerberos-authentication-problems-if-user-belongs-to-groups )

Open the deadlock graph using Solarwinds/SQLSentry Planexplorer (free tool) and you can see how locking evolves playing the graph.

We keep a DBA inventory database. function get-ActiveSQLInstances reads the active instances information.

This is where you read your server list.

The sets attributs are:

ServerNaam : servername\inctance
Instance : instance
FQServernaam...

just put it in a "temp" csv file and upload that to sqlserver.

This is how we create such an inventory:

Trap {
    # Handle the...

I would rather like to know the current version of my Azure Managed Instance, which has been on 12.0.2000.8 for the last 5 years.

I can see the date change e.g...

I'm glad you like it 🙂

Did you checked my article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

How about ...

$VerbosePreference = [system.Management.Automation.ActionPreference]::Continue 
$VerbosePreference = [system.Management.Automation.ActionPreference]::SilentlyContinue

Trap {
    # Handle the error
    $err = $_.Exception
    #Want to...

The question is not "If they'll target you",

the question is "When will they target you"

#KeepDoorShut

#KeepSecurityTight

• you could also just convert the collation in the calculated column.

  ...
  ,MyChecksum as (checksum([host_name],[program_name] COLLATE Latin1_General_CS_AS,[DbName] ,[nt_user_name],[login_name],[original_login_name],[is_dac])) persisted
  , MyHashBytes HASHBYTES('SHA2_256',concat([host_name],[program_name] COLLATE Latin1_General_CS_AS,[DbName] ,[nt_user_name],[login_name],[original_login_name],[is_dac])) persisted
  ​

  Make that column persisted...

Isn't that supposed to never ever happen ?

#Sarcasm

create index IX_Service_Start_Date ON ivc_cds.CDS_Claim_Header (Service_Start_Date ) 
WITH (FILLFACTOR = 98, SORT_IN_TEMPDB = ON ) ON  [DefFG]
-- remove on  ServiceStartDatePartitionScheme ( Service_Start_Date ) 

also have...