Data Trust
How much do you trust companies with your data? Steve Jones finds a couple new web sites that offer great services, but is it worth the price?
2008-10-26
66 reads
Editorial - iPod
Absolutely (Not?)
For this Friday's poll, Steve Jones asks about what absolutes you might have in your job.
2008-10-23
68 reads
A Virtual Database World
Steve Jones talks about virtualization with databases, but not in the way you might think.
2008-10-22
57 reads
36 Changes
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
2008-10-21
62 reads
Data Ownership
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
62 reads
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-17
516 reads
The Financial Crisis
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
2008-10-16
63 reads
Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
2008-10-15
56 reads
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
2008-10-13
63 reads
Data Farming
Another spy story involving data that's not true, and perhaps not plausible, but it makes Steve Jones think about data shadows.
2008-10-11
73 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
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
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