SSRS Tip: Simplest Method to Pass MDX Multi-Select Parameters to MDX Datasets I recently ran across a poorly covered topic in regards SSRS development using MDX parameters and datasets. After...
2013-02-07
31 reads
HP Announcement: PDW V2 Appliance Features
New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server...
2012-11-16
2,200 reads
HP Announcement: PDW V2 Appliance Features New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server PDW have been announced! Highlights: Lower price point (backup...
2012-11-16
12 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field...
2012-10-23
1,138 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
22 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’.
The...
2012-10-18
1,180 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’. The program VISIO.EXE version 14.0.6122.5000 stopped interacting with Windows...
2012-10-18
35 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...
2012-10-15
1,822 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...
2012-10-15
34 reads
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...
2012-10-04
5,420 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