The Other Jobs
This week Steve is asking what jobs you might choose if you had the chance, as well as those you enjoyed, or perhaps dreaded.
2019-05-17
277 reads
Editorials
2019-05-16
578 reads
Microsoft and Minecraft and Training Kids
Today we have a guest editorial from Andy Warren, looking at learning.
2019-05-15 (first published: 2015-02-23)
525 reads
Where Do You End Up as a DBA?
Steve Jones talks about careers, and where you might take your career over time.
2019-05-14 (first published: 2015-02-20)
723 reads
Communicate Smarter Not More
After installing Microsoft Teams, Steve has a bit of communication overload.
2019-05-13
202 reads
2019-05-11
128 reads
The Impediments to Change
SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]
2019-05-10
253 reads
The Death of the GDPR
The GDPR is struggling with enforcement against some of the larger tech companies. Steve thinks this is a problem, but it might not matter for smaller companies.
2019-05-09
502 reads
Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
2019-05-08
256 reads
A Double Failure
A company has both a server without a password and live data in test environments. Not a good situation.
2019-05-07
372 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
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