Using Azure Functions in Azure Data Factory

(2020-Apr-19) Creating a data solution with Azure Data Factory (ADF) may look like a straightforward process: you have incoming datasets, business rules of how to connect and change them 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...

Call to action: What do you own?

You restored that database, did you remember to change the owner or is it still you? How about that job ... Continue reading

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

IRL #7: Test Restores and CheckDB

My Pluralsight course for new SQL Server DBAs Problem: My client asked me for a way to automate test restores and CheckDB either ad hoc or on a schedule,...

PASS Summit 2020 pre-con time

In 2018, I entered Speaker Idol at the PASS Summit, and because I forgot to start my timer I was disqualified for running over the five-minute limit (say “five-minute...

The New Public Speaking

The need to transition to virtual speaking engagements is not easy for me. As someone who loves public speaking and delivering in person training, not being able to do...

The New Public Speaking

The need to transition to virtual speaking engagements is not easy for me. As someone who loves public speaking and delivering in person training, not being able to do...

TIL: Restore-DbaDatabase

(This post comes from one of our Junior DBAs – @SQLDork) If you haven’t read it already, i recently wrote a blogpost where i go over Backup-DbaDatabase, you can...

Understand SQL Server Editions and Components

SQL Server editions:- · Enterprise – Enterprise edition is the topmost edition with all available features. This is best suited for mission-critical Tier 1 applications. Enterprise edition is the...