Is C# Better?
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
329 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
PASS Summit 2009 – Keynotes
I’m not going to look back at the keynotes since I blogged about them. If you are interested, you can...
2009-11-12
768 reads
The Best of SQLServerCentral, Vol.7
The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.
- Download free eBook
- Printed book:
2009-11-12
6,468 reads
The SQLServerCentral Party
I think it went off well this year, and it looks like it will be around next year as well....
2009-11-12
889 reads
Consolidating Again and Again and Again
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
527 reads
Consolidating Again and Again and Again
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
509 reads
Consolidating Again and Again and Again
Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.
2009-11-12
802 reads
A Better Way To Install Updates
The decisions to install service packs and cumulative updates is often confusing to new DBAs. Many of them install every update, often without a good reason. Steve Jones asks why we might not have a better way to install updates, maybe even helping us decide if we need them.
2009-11-11
128 reads
PASS Summit 2009 – Fun
I’m not a big party guy, and in fact, more than a few people can attest to the fact that...
2009-11-11
811 reads
A Better Way To Install Updates
The decisions to install service packs and cumulative updates is often confusing to new DBAs. Many of them install every update, often without a good reason. Steve Jones asks why we might not have a better way to install updates, maybe even helping us decide if we need them.
2009-11-11
380 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
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 t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers