Press Release


Technical Article

SQL Saturday #372 - Exeter, UK

SQL Saturday, organized by SQL South West, is coming to Exeter, England on April 25. This is sure to be a special event, and as always, offers a free day of training and networking. Register while space is available.

2015-03-26

7,920 reads

External Article

Database source control workshop, Cambridge UK

Redgate is hosting a 1 day public workshop on April 22, 2015. This workshop will teach you how to put a database in source control, deploy a database from source control, and monitor database changes across development, testing, and production environments.

2015-03-24

7,650 reads

Technical Article

SQL Saturday #364 - Boston, MA

SQL Saturday is coming to Boston on April 18th 2015. Join us for a free day of SQL Server training and networking, and listen to great speakers like Grant Fritchey, Brent Ozar, and Andy Leonard. Register while space is available.

2015-03-19

7,512 reads

Technical Article

SQL Saturday #387 - Madison, WI

SQL Saturday is coming to Madison, Wisconsin on April 11th 2015. Join us for a free day of SQL Server training and networking and hear expert speakers like David Klee, Wendy Pastrick, and Jes Borland. Register while space is available.

2015-03-16

5,830 reads

Technical Article

SQL Saturday #381 - Richmond, VA

SQL Saturday is coming to Richmond on March 21, 2015. Join us for a free day of SQL Server training and networking. There are also paid-for pre-con sessions available from Tim Mitchell and Kevin Kline. Register while space is available.

2015-02-27

7,175 reads

Blogs

What DevOps Look Like in Microsoft Fabric

By

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

T-SQL Tuesday #192: What career risks have you taken?

By

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

Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...

Read the latest Blogs

Forums

Best Digital Marketing Strategies

By Aone It Service

Having trouble attracting leads or visibility online? We develop the best digital marketing strategies...

Best Social Media Marketing Company

By Aone It Service

Posting regularly but not getting engagement or sales? As one of the best social...

Azure Synapse database refresh

By Sreevathsa Mandli

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

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