Many of us would like to be sure we could rollback changes made during a deployment if they caused issues. Steve Jones notes that it might not be worth actually building those scripts in advance.
2016-08-22
496 reads
2016-08-22
96 reads
A smoke test can be a good way to ensure complex systems are working as expected after maintenance or changes.
2016-08-19
952 reads
The way that governments build software and work with data must change if we want to be more efficient.
2016-08-18
59 reads
2016-08-16
121 reads
Phil Factor explains why data detached from its temporal context often loses all meaning.
2016-08-15
88 reads
2016-08-15
85 reads
Today we have a guest editorial from Andy Warren as Steve is on vacation. Andy talks about a trip to Microsoft for the SQL Server 2016 launch.
2016-08-12
149 reads
A story I heard a long time ago reminds us to choose what is really important.
2016-08-11
116 reads
The potential vulnerabilities of wireless devices might be a security issue for databases.
2016-08-10
105 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
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