The PASS Session Selection Process, My Experience Part 3
In my last two posts I talked specifically about the process. This round I’m going to discuss the tools of...
2010-07-12
608 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
The PASS Session Selection Process, My Experience Part 2
In part one I talked about the abstracts. While important, abstracts are only one part of a complicated selection dance....
2010-07-09
472 reads
The PASS Session Selection Process, My Experience Part 1
Well, I have just finished up my part in the abstract selection process for the PASS Summit. This was my...
2010-07-07
544 reads
SQL Saturday #35 Notes and Observations
First of all, I want to congratulate all the volunteers that made this happen. It was a very well organized...
2010-05-25
1,172 reads
What happens when Windows is the step-child? Adventures in Ruby on Rails.
Like many of you I’ve heard the developer community going on about Rails for quite a while now. It wasn’t...
2010-04-02
1,462 reads
What I’ve Read and Recommend to Others – General Database and Theory by C.J. Date
Date on Database: Writings 2000-2006
This is a collection of writings by C.J. Date, one of the fathers of the relational...
2010-02-26
1,884 reads
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-24
2,200 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-19
2,937 reads
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-18
2,015 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-16
2,598 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