PASS DBA Virtual Chapter Trimming Indexes, Getting Your Database in Shape
Hello Dear Reader! Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to...
2012-10-23
1,024 reads
SQLBalls
DBA Study Guide
http://www.flickr.com/photos/caledonia09/4999119065/
Hello Dear Reader, over here at Pragmatic Works we’ve been growing like weeds. For the most part we are looking...
2012-10-18
2,423 reads
SQL Saturday 151 Interview: Stacia Misner
Hello Dear Reader SQL Saturday 151 is just around the corner. If you haven't registerd there is still time to...
2012-09-27
1,722 reads
Please VOTE for Me: PASS Summit 2012 Lightening Talks
http://www.flickr.com/photos/cyndydoty/2087680308/Hello Dear Reader the PASS Summit is approaching and with that the program committee sent out a request for Lightening...
2012-08-20
1,053 reads
SQL Saturday 151 BI Pre-con: Stacia Misner
Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam. The Pre-Con’s have been named and they are fantastic. ...
2012-08-16
743 reads
Database Certificates and the X.509 Standard
Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it. ...
2012-08-14
1,083 reads
Database Corruption, Transparent Data Encryption, and Trace Flag 5004
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,719 reads
How to Data Compress Varchar(MAX)
I talk a lot about compression. I’ve blogged a pretty decent amount on it as well. One of the things...
2012-08-08
7,969 reads
Book Review: On Writing A Memoir of the Craft by Stephen King
I just finished this book. Literally. Sitting on an airplane in route from Orlando to Charlotte NC. I got up...
2012-08-07
1,008 reads
How to Find Bad Page Splits
http://www.flickr.com/photos/brickapolis/5474835288/
I was working with a friend last week, doing SQL related teaching and tune ups. Earlier this week I had...
2012-08-06
4,243 reads
Blogs
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
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)...
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