A SQL Server Hardware Nugget A Day – Day 26
For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a...
2011-04-26
1,239 reads
Glenn Berry
A SQL Server Hardware Nugget A Day – Day 25
For Day 25 of this series, I want to talk about how you go about picking a CPU for your...
2011-04-25
538 reads
A SQL Server Hardware Nugget A Day – Day 23
For Day 23 of this series, I want to talk a little about some things to consider as you make...
2011-04-24
887 reads
A SQL Server Hardware Nugget A Day – Day 24
For Day 24 of this series, I want to talk a little bit about the TPC-E OLTP benchmark.
The TPC...
2011-04-24
743 reads
A SQL Server Hardware Nugget A Day – Day 22
For Day 22 of this series, I want to talk a little about 32-bit vs. 64-bit hardware, and the related...
2011-04-23
744 reads
A SQL Server Hardware Nugget A Day – Day 21
For Day 21 of this series, I will talk about processor cache size and its relationship to SQL Server performance.
Cache...
2011-04-21
910 reads
A SQL Server Hardware Nugget A Day – Day 20
For Day 20 of this series, we are going to talk about some factors to consider if you are thinking...
2011-04-20
775 reads
A SQL Server Hardware Nugget A Day – Day 19
For Day 19 of this series, I am going to briefly discuss hardware RAID controllers, also known as disk array...
2011-04-19
545 reads
A SQL Server Hardware Nugget A Day – Day 17
For Day 17 of this series, I am going to talk about Geekbench. Geekbench is a cross-platform, synthetic benchmark tool...
2011-04-18
599 reads
A SQL Server Hardware Nugget A Day – Day 18
For Day 18 of the series, we will talk about AMD Turbo CORE technology. AMD Turbo CORE is a technology...
2011-04-18
530 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