Comments on Acceptable Behavior
Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but...
2012-04-27 (first published: 2012-04-23)
2,616 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
AlwaysOn Failover Bug
I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...
2012-04-26
1,248 reads
SQL Server Log Backups
While presenting a session on Common Backup Problems both at SQL Saturday in Orange County and at SQL Connections in...
2012-04-02
1,049 reads
Execution Plan for a User Defined Function
When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:
It appears as...
2012-03-30 (first published: 2012-03-26)
8,334 reads
TDE and Compression
I knew that enabling TDE would cause the information stored within to, effectively, be randomized, which means it would seriously...
2012-03-19
2,795 reads
SQL Server 2012 AlwaysOn & A Thorough Setup
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,137 reads
Let’s Talk
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...
2012-03-08
871 reads
Avoiding Bad Query Performance
There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:
That’s certainly not...
2012-02-07
1,205 reads
Meme Monday: Deadlines
Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some...
2012-02-06
1,208 reads
Learning, Networking & Wine
Let’s say, you want to spend a couple of days learning about SQL Server. You also want to spend some...
2012-02-01
1,181 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
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 t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers