PASS Virtual Chapter August presentations
If you do not know by now, PASS has many virtual chapters that give free webcasts all month long. I...
2012-08-19
772 reads
Blog Posts
Would You Listen To The Steve & Andy Radio Show?
My friend Steve Jones and I have talked every week for a long time, close to ten years now. On...
2012-08-18
972 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
Different ways to audit SQL Server security
Today, my first article (ie. Different ways to audit SQL Server security) published on SearchSQLServer.com. In this article, I discussed...
2012-08-17
1,085 reads
Home Backup for the DBA
I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed...
2012-08-17
1,514 reads
RAID (Redundant Array Independent Disk)
RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk...
2012-08-17
909 reads
Restarting
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them are rally valid. There are 2 real reasons for...
2012-08-17
11 reads
Restarting
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them...
2012-08-17
783 reads
Actual Emails: The Customer Doesn't Want Full Recovery Mode
Got this question in an email. I'll paraphrase.
William Hoping you can advise me on best way to handle this. My client doesn’t...
2012-08-16
685 reads
Coming to Your Town
I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...
2012-08-16
1,168 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
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
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