Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

All authors

Blog Post

Will You Vote?

Voting is one of the many privileges that I have as an American citizen.  It’s a privilege that most Americans...

2013-09-23

568 reads

Blog Post

Saving Grace

According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...

2013-05-30

1,236 reads

Blog Post

Certifiable?

I have recently begun to contemplate pursuing the MCSA Certification.  I have been working with SQL Server for almost 20...

2013-05-17

617 reads

Blog Post

Mentoring

I’m putting my money where my mouth is, with respect to my last blog post.  I am officially a mentor...

2012-08-24

638 reads

Blog Post

Paying it Forward

My company has recently put forth an effort to hire fresh college graduates and interns.  I think this is a...

2012-08-24 (first published: )

1,729 reads

All authors

Blogs

AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention

By

Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...

Flyway Tips: Multiple Projects

By

One of the nice things about Flyway Desktop is that it helps you manage...

What DevOps Look Like in Microsoft Fabric

By

Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...

Read the latest Blogs

Forums

Can an Azure App Service Managed Identity be used for SQL Login?

By jasona.work

I'm fairly certain I know the answer to this from digging into it yesterday,...

Azure Synapse database refresh

By Sreevathsa Mandli

Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...

how to write this query?

By water490

hi everyone I am not sure how to write the query that will produce...

Visit the forum

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