Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

The Done Stamp

by Andy Warren

SQLAndy

I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...

2012-05-25

590 reads

It’s OK To Eat Alone

by Andy Warren

SQLAndy

There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...

2012-05-24

766 reads

Marketing Ideas for Chapters & SQLSaturday

by Andy Warren

SQLAndy

I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...

2012-05-23

724 reads

Watson Plays Jeopardy

by Andy Warren

SQLAndy

I watched the documentary on Nova about the IBM project to build Watson, a computer that could play Jeopardy. The...

2012-05-23

842 reads

LinkedIn Group Recommendations-Not Quite Useful

by Andy Warren

SQLAndy

I received an email from LinkedIn suggesting that I might find these groups useful:

I’m sure those map back to someone...

2012-05-22

728 reads

Build a Little Free Library

by Andy Warren

SQLAndy

I saw this on the Boing Boing feed yesterday, Little Free Library is a project to try to build 2500...

2012-05-18

843 reads

Expectations-The Big Disconnect

by Andy Warren

SQLAndy

One of the things I’ve learned from running events is to set expectations. If you’re going to provide coffee don’t...

2012-05-18

579 reads

The Brain Dump Blog

by Andy Warren

SQLAndy

I was chatting with a friend recently and he said he could never blog the way I do. Which way...

2012-05-18

587 reads

Go Look at NELL

by Andy Warren

SQLAndy

NELL (Never Ending Language Learning) is a computer system that is trying to learn to read the web. Couple things...

2012-05-17

714 reads

Varied and Interesting Links

by Andy Warren

SQLAndy

Here are some things I’ve run across in the past few weeks you may find interesting:
FailCon. Billed as a one-day...

2012-05-14

571 reads

Blogs

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

By Vinay Thakur

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

Flyway Tips: Multiple Projects

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

What DevOps Look Like in Microsoft Fabric

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?

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?

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