Coding Standards Gone Bad in SQL Server

Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...

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

DAX and Power BI Stairway Live

As part of the Redgate Community Circle, I’m going to be running a live class on DAX and Power BI, every Thursday, from 12MDT for about 30-45 minutes. We’ll...

New Article: Understanding SQL Server Ownership Chaining

Back in January I gave a presentation to a small group of folks on foundational SQL Server security items. The last thing I covered was the concept of ownership...

Remote Work Resources

We’re at least five weeks into this thing here in New York and while there are some encouraging signs, it’s more likely than not that “non-essential” workers aren’t at...

SQL Server and CPU Hyper-Threading in Virtual Environments

I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be...

Switching between different Azure Data Factory environments

When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,...

T-SQL Tuesday Live 21 Apr 2020

I’ll be hosting T-SQL Tuesday live again today, at 1:00pm MDT/3:00pmEDT/8:00pmGMT If you’re interested in taking a break, chatting, touching base with others, bring your comments, questions, thoughts, and...

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

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