Free Webcast: DBA vs Memory Settings
Join me in two weeks for a really fun free webcast. Update: watch the recording of the webcast here! DBA vs Memory Settings Tues, April 24, 2018 – 8:30AM...
2018-04-11
5 reads
Remembering Robert Davis, aka @SQLSoldier
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
25 reads
Adding a Downloadable Calendar Event File to WordPress without a Plugin
Let’s say you’ll be doing an event soon — say a Facebook Live event– and you want to create a calendar reminder for folks to download. Lots of us...
2018-03-19
8 reads
SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)
It’s T-SQL Tuesday’s 8 year birthday (or close enough), and Adam Machanic has challenged us with the question: what will the world be like when T-SQLTuesday turns 16? Not...
2018-03-13
9 reads
New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels
I’ve got a whole slew of free webcasts and events coming this spring. I’m excited about each and every one of them! My next event is a free session...
2018-03-12
6 reads
Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”
Update: Instead of reading this blog post, I suggest you read the article, “The Secret History of Women in Computing: Computer programming once had much better gender balance than...
2018-03-07
8 reads
Using YouTube Captions & Transcript to Find Content in a Long Video
This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public. I attended...
2018-02-23
8 reads
How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)
For TSQL Tuesday #99, @AaronBertrand gave us an invitation to write about something we’re passionate about outside of SQL Server. As a community we spend a lot of time digging into nerdy...
2018-02-13
11 reads
Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions
Do you ever need to use a text editor to apply regular expressions to files? If so, this post is for you! If not, you may wanna skip it...
2018-02-08
8 reads
WordPress: Create a Sidebar List of Parent/Child Pages
Recently, I wanted to create a list of pages for a custom WordPress sidebar. Specifically, I had a “parent” page, sqlworkbooks.com/free-sql-server-quizzes. Under this page, I had more than 30 individual...
2018-01-04
722 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
Best Digital Marketing Strategies
Having trouble attracting leads or visibility online? We develop the best digital marketing strategies...
Best Social Media Marketing Company
Posting regularly but not getting engagement or sales? As one of the best social...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
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