2008-12-24
159 reads
Editorial
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
2008-12-23
83 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-22
520 reads
The Best Computer
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
2008-12-19
244 reads
Guest Editorial: That ain't a Database, it's a Spreadsheet
Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
2008-12-18
440 reads
Versions of Disaster
Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.
2013-09-12 (first published: 2008-12-17)
342 reads
Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
2008-12-16
477 reads
Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-15
243 reads
Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
2008-12-15
349 reads
Guest Editorial: On writing SQL
The exceptional talents of seasoned engineers and developers can never quite be rendered obscelete by technological wizardry. Phil Factor considered old-school intuition, and wonders if he's missed a trick.
2008-12-12
481 reads
Blogs
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,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
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...
Fun with JSON I
Comments posted to this topic are about the item Fun with JSON I
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