Networking and Connections
This quote says it all:
It’s from an article on the 9/11 memorial and how an algorithm was used to inscribe...
2011-05-11
747 reads
Blog Posts
PASS Summit 2011 Session Preference Survey
PASS has added a new feature to the session selection process for the PASS Summit 2011, which they are calling...
2011-05-11
598 reads
PASS Summit Session Selection is Open
This year the Program Committee decided to open up the selection process to the community. I'm anxious to see how...
2011-05-11
851 reads
Patch Week
My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices,...
2011-05-11
895 reads
Pragmatic Tools Week: Task Factory
If you've ever spent any time doing SSIS development work, you'll eventually come to a point when developing something and...
2011-05-11
1,429 reads
SQLRally Overdrive: Birds of a Feather Discussions Event
Just wanted to post a quick note/invitation to everyone to come join us on Thursday, May 12th from 5:45-7:00 for...
2011-05-11
368 reads
Troubleshooting Performance -1
Whenever you get a call from user that they are facing any performance issue what would you do. As I...
2011-05-11
472 reads
TSQL Tuesday #18 - Using CTE to Analyze Disk IO
(TSQL Tuesday on Wednesday! - Apologies for the late entry - better late than never)
Today’s topic is CTE’s.Scientifically speaking, solids mostly expand...
2011-05-11
2,008 reads
T-SQL: Identifying, inserting and removing spaces in strings
Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.
For example, you may...
2011-05-11
3,766 reads
Vote for My PASS Summit Sessions
Yes, this is absolutely a shameless post for self-promotion. However, since potential attendees get to offer input into what sessions...
2011-05-11
955 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