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...

The bigger problem I just found out is that this column is part of the key structure on some of our financial tables.  So splitting it out makes it...

There are many articles covering "Composite columns" (/ "composite keys") vs individual columns (/ surrogate key ) pro's and cons.

You are now at a junction point handling one of the...

Did you notice you end up with a negative DurationInSeconds ?

--                ...

Please post the "Server Audit" and the "Server Audit Specification" scripts.

There must be some filtering active for it not to report all.

Did you enable as well the "Server Audit" as well as the "Server Audit Specification" ?

Check filters !!

I just export the plan and its consumption statistics from the plan cache.

1 file with all consumption details, 1 .sqlplan file per plan

It is an option, but you may end up being deadlocked most of the time, depending the amount of blocking and lock escallation

Scalar functions are still  a big NoNO ! ( Inlining doesn't work on all SVFs !! )

Write your SVFs as InlineTableValueFunctions and things will perform again

Have you checked SQL Server audit data?

/*
Generate Server Audit event session to trace action in a database

DBA_ServerAudit

*/

Declare @CreateSession bit = 0;

Declare @DropSession bit = 0 ;

Declare @StartSession...

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