SQLSaturday#71 is only a day away! - Final Schedule....
Just a final note for all of you planning on attending tomorrow's SQL Saturday #71 event extravaganza up in Boston. The event...
2011-04-01
756 reads
Robert Pearl
SQL Server Quiz - Answer the questions, win a prize.....
It's March Madness, and we're not just talking about basketball. We're not just talking about Women's History Month, which is...
2011-03-15
2,104 reads
SQLSaturday#69 - Philadelphia Wrap-Up
Just wanted to take the opportunity to summarize my experience at SQLSaturday#69 in Philadelphia, this past Saturday. Another city, another amazing event! I haven't been...
2011-03-08
2,373 reads
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Sometimes, folks come to me, and ask for...
2011-03-04
5,043 reads
SQLSaturday#69 - Update - Schedule Posted! - You Can Still Register
It's just a little less than 2 weeks to SQLSaturday#69 at DeVry University, 1140 Virginia Drive, Ft. Washington, PA 19034...
2011-02-21
870 reads
Intro to SSAS BI Workshop - Review
A Synopsis of My Experiences of the “Intro to SSAS” BI Workshop in NYC!
By Robert Pearl
Well it’s a wrap of...
2011-02-18
1,841 reads
What's OLD in SQL Server 11 aka Denali? - Deprecated Feature List
Well, we always see, hear, and read about the list of NEW features in the myriad of articles, columns and blogs...
2011-02-08
1,732 reads
28-days in February - What to do - Read about Waits & Queues
Happy Monday! I'm sure many of you may have already caught on, that Waits & Queues is the way to go...
2011-02-07
712 reads
Microsoft SQL Server Licensing For Dummies..
Don’t let the above title fool you! Have you been confused on the Microsoft SQL Server Licensing requirements? Per Processor, Per CAL, Per Core, Per Socket, Per Node – Per haps (space intended :-), we should revisit the issue again, and try to offer some assistance as you go forward in making your purchasing decisions.
2011-02-04
4,848 reads
Something BIG in Boston - SQLSaturday#71
BIG in BOSTON
Last time, I blogged about the first upcoming event in the North East in Philadelphia, PA – SQLSaturday#69, but...
2011-02-02
634 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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