Kenneth Fisher

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at https://sqlstudies.com/.

All authors

sp_helptext

by Kenneth Fisher

SQLStudies

My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...

2012-09-02

4,115 reads

At Startup SSMS setting

by Kenneth Fisher

SQLStudies

I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...

2012-08-27

660 reads

keyword DEFAULT

by Kenneth Fisher

SQLStudies

In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...

2012-08-20

1,341 reads

All authors

Read the latest Blogs

Visit the forum

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

Kenneth Fisher

sp_helptext

At Startup SSMS setting

keyword DEFAULT

Blogs

In-Person CISA Training – April 13-16, 2026

EightKB 2026

The FinOps Lifecycle: From Budgeting to Reporting

Forums

VS Code, Unresolved References.

Fun with JSON II

Changing Data Types

Question of the Day

Fun with JSON II