We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a ... Continue reading
2021-08-09 (first published: 2021-07-22)
809 reads
I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to ... Continue reading
2021-08-02 (first published: 2021-07-15)
407 reads
It’s a SQL Server Instance not a SQL Server. The product is SQL Server. The installed copy is an Instance. ... Continue reading
2021-07-29
348 reads
I don’t speak all that often. A few times a year for the most part. Because of that I don’t ... Continue reading
2021-07-27
16 reads
Thanks for agreeing to do this Kellyn. I’ve always found you to be one of the more interesting personalities in ... Continue reading
2021-07-23 (first published: 2021-07-08)
247 reads
Hypothesis: If I have Dynamic Data Masking enabled on a column then when I use something like BCP to pull ... Continue reading
2021-07-20
14 reads
This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of ... Continue reading
2021-07-16 (first published: 2021-06-29)
679 reads
I was speaking with one of my favorite people in the SQL Server community, Grant Fritchey (blog|twitter), on twitter today. ... Continue reading
2021-07-06
92 reads
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in ... Continue reading
2021-07-05 (first published: 2021-06-24)
236 reads
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy ... Continue reading
2021-07-01
32 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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