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)
878 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)
917 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)
530 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)
531 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)
454 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
15 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)
336 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers