Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m […]
2019-07-27
729 reads
This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town. I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. […]
2024-08-21 (first published: 2019-07-13)
603 reads
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2025-05-26 (first published: 2019-07-06)
350 reads
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
402 reads
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
212 reads
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
2019-06-08
229 reads
This editorial was originally published on May 18, 2019. It is being re-run as Steve is on holiday. Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was […]
2025-01-20 (first published: 2019-05-18)
378 reads
2019-05-11
128 reads
2019-04-13
200 reads
Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.
2014-02-03
312 reads
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...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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