You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it ... Continue reading
2020-05-01 (first published: 2020-04-20)
696 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
14 reads
The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. ... Continue reading
2020-04-27 (first published: 2020-04-16)
601 reads
I get asked this every now and again, along with the companion When was the last time this login was ... Continue reading
2020-04-20 (first published: 2020-04-08)
896 reads
Happy T-SQL Tuesday again! Number 125. I can’t believe how long this thing has been running. In case you weren’t ... Continue reading
2020-04-14
16 reads
The other day Kendra Little (blog|twitter) mentioned that she was trying to get a command in Powershell working. Specifically one ... Continue reading
2020-04-13 (first published: 2020-04-06)
1,247 reads
The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run ... Continue reading
2020-04-06 (first published: 2020-03-30)
380 reads
Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world ... Continue reading
2020-04-01
8 reads
TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code ... Continue reading
2020-03-30 (first published: 2020-03-25)
771 reads
When it comes to migrating applications to Azure, there are a number of paths available. But if you’re migrating on-premises ... Continue reading
2020-03-25 (first published: 2020-03-17)
285 reads
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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