You can’t use GO in dynamic SQL.
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-10
15 reads
Kenneth Fisher
Who do you contact before an upgrade? : T-SQL Tuesday #147
I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent ... Continue reading
2022-02-09
7 reads
SQL Homework – February 2022 – “Soft” skills.
Well, it’s a new year and a new start, even if I am a bit behind the start of the ... Continue reading
2022-02-02
3 reads
2021 a year in review
No matter where you are in the world the last couple of years have been, shall we say, difficult. More ... Continue reading
2022-01-07 (first published: 2021-12-30)
203 reads
2021 a year in review
No matter where you are in the world the last couple of years have been, shall we say, difficult. More ... Continue reading
2021-12-30
5 reads
The less you hear from or about the DBAs the better they are doing their job.
Something I’ve been thinking about recently is that DBAs are best when they are invisible. Now, this is also true ... Continue reading
2021-12-15 (first published: 2021-12-07)
357 reads
SQL Homework – December 2021 – Changing collation
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-10 (first published: 2021-12-02)
306 reads
The less you hear from or about the DBAs the better they are doing their job.
Something I’ve been thinking about recently is that DBAs are best when they are invisible. Now, this is also true ... Continue reading
2021-12-07
5 reads
Data jokes
I’m feeling a bit uninspired this week, and I plan on only doing one post this week, so I figured ... Continue reading
2021-12-03 (first published: 2021-11-23)
876 reads
SQL Homework – December 2021 – Changing collation
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading
2021-12-02
7 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
Question of the Day
Fun with JSON I
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