Query Performance Tuning in SQL Server
I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query...
2014-10-16
677 reads
Blog Posts
SSRS report rendered in EXCELOPENXML then something went missing
Recently I had been requested by a client to look into one of their SSRS reports issues. They had one...
2014-10-16
3,160 reads
The Murder Train is making a stop in Salt Lake City
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-10-16
572 reads
UNION vs UNION ALL
You might be wondering why I’m going into such a simple subject. Well the way I see it there are...
2014-10-16
2,752 reads
What will you see at SQL in the City
London, Oct 24, 2014
Seattle, Nov 3, 2014
Come join us.
Filed under: Blog Tagged: Humor, syndicated
2014-10-16
814 reads
Beware the defaults! (in windowing functions)
Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...
2014-10-15 (first published: 2014-10-07)
6,628 reads
Can’t Create A Timeline in Excel on Multidimensional Cube
Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting...
2014-10-15
3,360 reads
Hell No, DMO - DMV is what it shall be!
So, I've finally decided to draw a line in the sand. I've been doing some writing lately. The radio silence...
2014-10-15
1,838 reads
I'm an MVP
Hello Dear Reader! Two weeks ago I was very honored to be named a Microsoft SQL Server MVP. Since then...
2014-10-15
811 reads
Lync 2013 Video Issues on Windows 8
Part of the reason I have a blog is to document issues and resolutions I do not want to forget....
2014-10-15
539 reads
Blogs
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...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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