How to Change the File Extension for a Data File
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
6 reads
Ganapathi varma Chekuri
- Interests: SQL Lover
Upgrade SQL Server Evaluation edition to license Edition of SQL Server
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,712 reads
Upgrade SQL Server Evaluation edition to license Edition of SQL Server
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
Cumulative Update #1 for SQL Server 2017 RTM
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
Cumulative Update #1 for SQL Server 2017 RTM
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
Resolve Network Binding Order Warning in failover cluster
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,598 reads
Resolve Network Binding Order Warning in failover cluster
In this post, I’m going to talk about an issue that I found while running the cluster validation report. You may receive below warning message that includes information about...
2017-07-22
9 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica...
2017-04-18
1,717 reads
The Connection to the Primary Replica is not Active
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group. This error mostly appears when we...
2017-04-18
11 reads
Step by Step Configuring a Dedicated Network for Availability Group
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage...
2017-04-10
865 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
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 t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers