Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development Life Cycle (SDLC)? Stick around, because I'll get to...
2016-12-12
12 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
358 reads
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus...
2016-11-22
557 reads
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus around scenarios and solutions for databases in Microsoft's...
2016-11-22
3 reads
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
2,119 reads
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.
First time deployment
Backup / restore...
2016-11-11
6 reads
Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...
2016-11-07
353 reads
Applies to: xSQL Schema
Compare v7.0.0 – 9.0.2
Before I develop a scenario where
xSQL Schema Compare snapshot comparison is necessary let’s explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...
2016-11-07
12 reads
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
195 reads
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...
2016-11-02
9 reads
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)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
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