Create and Read the Analysis Services Flight Recorder
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,558 reads
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,558 reads
Spotting synchronization disconnects between a primary and a secondary data center in a distributed availability group configuration can be hard, so here are valuable tools to help you with it
2025-10-10
1,285 reads
2025-09-02 (first published: 2025-08-04)
616 reads
This article describes the process to create a read-scale cross-platform SQL Server Availability Group where the primary is Linux and the secondary is Windows.
2025-07-23
370 reads
2025-07-23
4,507 reads
This article shows the final step of an availability group creation, specifically for a distributed clusterless one.
2025-07-14
4,533 reads
Learn how you can integrate the SQL Server error logs into Crowdstrike for better analysis.
2025-03-17
1,213 reads
Keeping track of all the security related logs can be hard. Using your security team to shoulder some of the load can help. Learn how in this article.
2024-12-16
3,747 reads
create a sql server polybase scale out group in azure for free
2021-06-23 (first published: 2021-04-12)
2,022 reads
2021-05-26 (first published: 2021-04-30)
8,870 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