Some developers have reacted with dismay to the recent news that Microsoft’s Oslo project is being integrated into the SQL Server platform and renamed SQL Server Modeling. The overwhelming feeling seems to be that their DSL dream is being snatched away.
2009-11-30
93 reads
Microsoft is very willing to lend its ear to new feature requests, but sometimes forgets to finish off the ones we've got.
2009-10-19
57 reads
The Maintenance Plan wizard offers a quick and simple route to make sure essential database maintenance tasks are performed and scheduled. However, it needs to be used with a lot of care, and is no substitute for the judgment, experience and common sense of a flesh and blood DBA.
2009-10-05
376 reads
The wording of the statement about MySQL that came out from Oracle after the merger was downbeat. The implication was "Oh no! Another Blooming Database to deal with". But surely they don't plan to just let it drift?
2009-08-17
348 reads
2009-08-10
182 reads
Tony Davis explains his theory on why developers and DBAs listen to very different types of music, while working, and offers his list of "classic tracks" for all DBAs.
2009-07-07
321 reads
It's a holiday weekend, but for some DBA's it's hard to escape the unwanted clutches of IT...
2009-07-06
80 reads
Over the past five or so years, encouraging progress has been made with regard to testing .NET application code...I wish I could say that the same progress had been made with testing SQL.
2009-07-01
550 reads
Virtualization, and use of the 'cloud', will be essential to the deployment of new applications, but will existing applications will be quite so amenable?
2009-06-15
280 reads
T-SQL is not a language to be admired from a distance for its grace, sophistication and integrity. It is a tool designed to allow "normal" developers and DBAs to build database business applications as smoothly and efficiently as possible.
2009-05-25
370 reads
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
hi everyone I am not sure how to write the query that will produce...
Comments posted to this topic are about the item Rollback vs. Roll Forward
Comments posted to this topic are about the item Foreign Keys - Foes or...
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