Advice for Business
Some advice from Steve and Sam Altman, whether you work in business or want to build one.
2024-01-08
164 reads
Editorials
Has AI Changed Software Development?
Generative AI is everywhere, but especially in software development. Is it helping us? Steve has a few thoughts.
2024-01-06
112 reads
Projects To Showcase Your Skills
A good way to showcase your skills is by working through and documenting a project and solution. Steve notes today that this is important in today's hiring market and asks for sample projects you might suggest for others.
2024-01-05
505 reads
Fixing Poor Programming Practices
Today Steve has a few stories of how he's fixed poor programming practices and asks you to share your own.
2024-01-03
344 reads
Happy New Year 2024
Happy New Year from Steve, with a reminder to work on your career plan for 2024.
2024-01-01
79 reads
Being A Bit Less Comfortable in 2024
I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple topic just staring me in the face: New Year’s Resolutions. Love them or hate them (or it we are honest, a good bit of both,) this end of one year and the start of another […]
2023-12-30
170 reads
The 2024 Plan
On the last working day of 2023, Steve says you should think about making a 2024 plan for your career.
2023-12-29
209 reads
Some Relief But Still Some Concern
Steve is relieved that he hasn't updated sqlmemorial.org this year, but worries he's missed remembering some of our colleagues.
2023-12-27
168 reads
2023-12-25
55 reads
A Thrill of Hope
I realize that this isn’t the last Database Weekly editorial of the year – that honor is reserved for Louis Davidson next week. 😊 However, as we approach the end of the year and various holiday celebrations, one of my favorite Christmas carols has been of particular encouragement to me recently. 2023 hasn’t gone exactly […]
2023-12-23
60 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