Speaking at Colorado Springs SQL Server User’s Group on June 15
I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15,...
2011-05-09
516 reads
Glenn Berry
PASS 2011 Summit Abstract Submissions
Today is the last day to submit session abstracts for the PASS 2011 Summit. I was lucky enough to speak...
2011-05-04
478 reads
A SQL Server Hardware Nugget A Day – Series Recap
Writing a month long series is always a lot more work than you initially expect. You would think that I...
2011-05-01
629 reads
A SQL Server Hardware Nugget A Day – Day 30
For Day 30 of this series, (which is the last day), I am going to talk a little about RAID,...
2011-05-01
931 reads
A SQL Server Hardware Nugget A Day – Day 29
For Day 29 of this series, I am going to talk about some of the basic things that you should...
2011-04-30
1,394 reads
A SQL Server Hardware Nugget A Day – Day 28
For Day 28 of this series, I am going to talk a little bit about some upcoming developments in Intel...
2011-04-28
1,643 reads
A SQL Server Hardware Nugget A Day – Day 27
For Day 27 of this series, I am going to talk a little bit about disk performance and one easy...
2011-04-27
1,319 reads
A SQL Server Hardware Nugget A Day – Day 26
For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a...
2011-04-26
1,239 reads
A SQL Server Hardware Nugget A Day – Day 25
For Day 25 of this series, I want to talk about how you go about picking a CPU for your...
2011-04-25
538 reads
A SQL Server Hardware Nugget A Day – Day 24
For Day 24 of this series, I want to talk a little bit about the TPC-E OLTP benchmark.
The TPC...
2011-04-24
743 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
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 James Serra
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 Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
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