As many of you know, Query Store is a wonderful tool for identifying query regressions, which in turn makes it an equally wonderful tool for migrations involving an upgrade...
2020-04-30
20 reads
(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...
2020-04-30 (first published: 2020-04-19)
4,134 reads
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...
2020-04-29 (first published: 2020-04-20)
316 reads
You restored that database, did you remember to change the owner or is it still you? How about that job ... Continue reading
2020-04-29
13 reads
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...
2020-04-29
11 reads
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,...
2020-04-29 (first published: 2020-04-23)
516 reads
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...
2020-04-29
10 reads
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...
2020-04-29
12 reads
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...
2020-04-29
7 reads
(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...
2020-04-29
26 reads
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers