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

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

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

Has this login been used recently?

I get asked this every now and again, along with the companion When was the last time this login was ... Continue reading

Make Database Code Reusable in SQL Source Control with Deployment Filters

When I first began working with databases, I was lucky to land a job at a little start-up which had solid development and operations processes: all our code, including...

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

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

Adjusting pod eviction time in Kubernetes

One of the best features of Kubernetes is the built-in high availability. When a node goes offline, all pods on that node are terminated and new ones spun up...

Daily Coping 17 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...