I’ve decided that, in fact, it is time to start moving people off the ancient technology, Profiler. Before, I always said, stay where you’re comfortable. However, keeping people comfortable...
2020-02-06 (first published: 2020-02-03)
877 reads
I wrote a short blog post about the misperception that Profiler was easier than Extended Events when it came to the core concept of “click, connect, BOOM, too much...
2020-01-27
25 reads
Query tuning is not easy. In fact, for a lot of people, you shouldn’t even try. It’s much easier to buy more, bigger, better hardware. Yeah, the query is...
2020-01-29 (first published: 2020-01-21)
916 reads
I know, I know, I’m on #teamexevents so I think that Extended Events can do no wrong, but let’s address this thought that Profiler is easier. Now, if we’re...
2020-01-28 (first published: 2020-01-20)
529 reads
If you go through all the stuff I’ve written about Extended Events, you’ll find that I use causality tracking quite a bit. However, I’ve never just talked about what...
2020-01-22 (first published: 2020-01-13)
352 reads
The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first...
2020-01-14 (first published: 2020-01-06)
530 reads
With the end of the year, other things are coming to an end as well. Tomorrow, December 31st, will mark my final day as President of the PASS organization....
2020-01-10 (first published: 2019-12-30)
453 reads
MERRY CHRISTMAS! HAPPY YULETIDE! HAPPY HANUKKUH! Instead of something technical, let’s take a moment to just kick back and enjoy a few great Christmas movies. Now, let’s be clear....
2019-12-23
14 reads
I saw this question on SQL Server Central the other day and had an immediate, visceral reaction. I know why. Now, before I explain my answer, please, let me...
2020-01-01 (first published: 2019-12-16)
1,372 reads
If you’re working with the Microsoft Data Platform, you should be, at the least, exploring Azure Data Studio as a new tool in your toolbox. One of the big...
2019-12-18 (first published: 2019-12-09)
334 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Hi So the case statement is slowing this down - but for the life...
I need to delete rows from both the temporal main and history tables. The...
Comments posted to this topic are about the item When SQL Server Central Went...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers