What version of SQL is SSMS scripting for?
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server ... Continue reading
2019-03-25
18 reads
Kenneth Fisher
Disabling and enabling triggers
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...
2019-03-20 (first published: 2019-03-06)
2,601 reads
Hugo’s SQL Server Execution Plan Reference
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and...
2019-03-18
449 reads
SQL Homework – March 2019 – Reconfigure tempdb
You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor...
2019-03-15 (first published: 2019-03-04)
2,415 reads
Dipping into the Cookie Jar: T-SQL Tuesday #112
This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies....
2019-03-12
253 reads
DBA Myths: Can a differential backup get bigger than the full backup?
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one...
2019-03-04 (first published: 2019-02-14)
2,451 reads
Dem queries
Dem queries, dem queries, dem slow queries,
Dem queries, dem queries, dem fast queries,
Dem queries, dem queries, dem big queries,
Now write...
2019-02-27
1,150 reads
Using the Microsoft Authenticator app to log into Azure
So I was trying to work on a blog post about the new truncation error this morning and realized I...
2019-02-25
237 reads
Why do I (they) own that database?
Ever looked at the list of databases and wonder why you own one of them? Or why some other user...
2019-02-20
138 reads
Disabling Indexes
Indexes are probably the number one tool we have to improve performance. That said, there are times when we want...
2019-02-18 (first published: 2019-01-28)
2,457 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
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...
Fun with JSON I
Comments posted to this topic are about the item Fun with JSON I
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