The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.
2018-02-05
17,430 reads
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a...
2018-01-11
348 reads
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a new location.
The ALTER DATABASE command would work for moving...
2018-01-11
8 reads
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions for our SQL Data Files...
2018-01-11
387 reads
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions that we use for SQL Server data files are MDF (Primary Data File), NDF...
2018-01-11
4 reads
The SQL Server Evaluation Edition is a great way to get a fully functional and free instance of SQL Server for learning and...
2017-12-01
67,711 reads
The SQL Server Evaluation Edition is a great way to get a fully functional and free instance of SQL Server for learning and developing solutions. The edition has a built in expiry...
2017-12-01
5 reads
The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.
CU#1...
2017-10-27
520 reads
The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.
CU#1 KB Article: https://support.microsoft.com/en-us/help/4038634/cumulative-update-1-for-sql-server-2017
Microsoft® SQL Server® 2017 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=56128
2017-10-27
7 reads
In this post, I’m going to talk about an issue that I found while running the cluster validation report. You...
2017-07-22
1,595 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