The May Car Update (2008)
Steve Jones talks about alternative hybrids, in this bi-monthly update on automotive news.
2008-05-28
110 reads
Editorials
Sorting the Sheep from the Goats
A guest editorial from Tony Davis, on how to test whether someone will make a good DBA or developer.
2008-05-27
234 reads
IT Project Euthanasia
A guest editorial from Phil Factor on the kindest way to dispose of unwanted IT projects.
2008-05-26
160 reads
2008-05-26
77 reads
2008-05-23
70 reads
MatrixDB
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
2008-05-22
347 reads
2008-05-21
556 reads
Database Weekly Update for May 19, 2008
Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.
2008-05-19
30 reads
The Best Way to Find Quality People
How can you find good employees? Steve Jones offers a few tips on what has worked for him in the past.
2008-05-19
258 reads
A Worthwhile Goal
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
2008-05-16
113 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
Best Digital Marketing Strategies
Having trouble attracting leads or visibility online? We develop the best digital marketing strategies...
Best Social Media Marketing Company
Posting regularly but not getting engagement or sales? As one of the best social...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
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