SQLSaturday Orlando–Power BI On-Premises In A Day
Please join me for a day of developing and deploying Power BI reports in an On-Premises environment. This event is...
2018-08-20
249 reads
The Smiling DBA
SQLServerCentral.com Stairway Series–SSAS Tabular
The first 2 articles have been published on a SQLServerCentral.com Stairway series for SQL Server Analysis Tabular models. This is truely a blessing to be able to publish on...
2018-07-25
18 reads
SQLServerCentral.com Stairway Series–SSAS Tabular
The first 2 articles have been published on a SQLServerCentral.comStairway series for SQL Server Analysis Tabular models. This is truely...
2018-07-25
271 reads
Idera Greek Sync: Performance Tuning with Execution Plans
On Wednesday July 11th, please join Idera Geek Sync at 11AM Central for a walk through some basics in Execution Plans. We will look at the history of execution...
2018-06-24
12 reads
Idera Greek Sync: Performance Tuning with Execution Plans
On Wednesday July 11th, please join Idera Geek Sync at 11AM Central for a walk through some basics in Execution...
2018-06-24
350 reads
2018-04-26
10 reads
2018-04-26
437 reads
24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours....
2018-04-18
23 reads
24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours...
2018-04-24 (first published: 2018-04-18)
2,311 reads
DBA Fundamentals–Tuesday 11 Central–Execution Plans
WHAT: EXECUTION PLANS FOR BEGINNERS
WHEN: Tuesday, 04/17/18 - 11:00 am – 12:00 pm
WHO: Thomas LeBlanc
WHERE: https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting the starting point for using the...
2018-04-12
15 reads
Blogs
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
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