2011 PASS Board Election Results
Results of the 2011 PASS Board of Directors election were officially announced this morning. I want to congratulate my friends...
2011-12-28
779 reads
Kendal Van Dyke
2011 PASS Board Elections Notes
As I write this the final hours for the 2011 PASS Board of Directors elections are ticking away. Before the...
2011-12-20
937 reads
PASS Summit 2011 Session Evaluations
Session evaluations from the 2011 PASS Summit have been entered, calculated, and officially released to speakers. While I didn't make...
2011-12-15
1,072 reads
A PASS Board Of Directors Endorsement
One of the requirements for the PASS Board of Directors application was a collection of recommendations - 3 from volunteers, 3...
2011-12-09
889 reads
PASS Board Of Directors Voting Open Through Dec. 20
Voting for the 2011 PASS Board of Directors elections started earlier this week and if you were a PASS member...
2011-12-09
678 reads
Database Mirroring In A Windows Workgroup
Database Mirroring is a popular high availability solution and low-cost alternative to clustering, especially for smaller shops who can't afford...
2011-12-01
4,700 reads
PASS Board Of Directors Interview
I had my telephone interview for the PASS Board of Directors this afternoon and I'm cautiously optimistic that I did...
2011-11-08
632 reads
Why I'm Running For The PASS Board Of Directors
If you read this week's onnector email you may have noticed that I'm one of the six candidates who have...
2011-11-04
819 reads
My PASS Summit 2011 Experience
The 2011 PASS Summit is in the rear view mirror (has it really been almost three weeks now?)...and as always...
2011-11-02
931 reads
#SQLGive Update - New Dropoff Locations
Since announcing #SQLGive earlier this week I'm happy to report that two additional vendors have agreed to host dropoff boxes...
2011-10-07
841 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