Audit Logons with Extended Events

This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Related Posts:

Life Support 2008 - Audit Logons July 17, 2019...

Free SQL Data Compare

I am a consultant in Austin who can help make your data go fast, be secure and highly available. When I am engaged in a performance tuning project priority...

Free SQL Data Compare

I am a consultant in Austin who can help make your data go fast, be secure and highly available. When I am engaged in a performance tuning project priority...

The Very Best of Extended Events

Over the next couple of months, I’ll be putting on a number of different sessions teaching about the tools supplied by Microsoft, for free, that can help you when...

Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.

You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it ... Continue reading

Using Pester to Improve Operational Tasks

Taking the Time To Test
Requirements in a constant state of change set you up for failure.
Failure to work through requirements before starting can also increase the risk of failure.
Planning...

Daily Copying 20 Apr 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...

Improved Windows Terminal Setup

I’ve long been a Cmder/ConEmu user for Windows as it’s provided a much-needed improvement of the standard Windows terminal.
I’ve started trying to use the newer Windows Terminal project to...

Disk Performance Metrics in AWS and Azure

In the last two posts, we have discussed the different types of storage disks available in the AWS and Azure cloud platforms. We also discussed the characteristics that affect...

Disk Performance Metrics in AWS and Azure

In the last two posts, we have discussed the different types of storage disks available in the AWS and Azure cloud platforms. We also discussed the characteristics that affect...