Losing Data
As data professionals, we want to avoid losing data. We won't always be successful, but we can avoid making the easy mistakes.
2013-06-17
107 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
SQL in the City Goes Mobile
This week is the kickoff of the third year of SQL in the City from Red Gate. As we have...
2013-06-17
961 reads
Trust
Why does the IT industry seem to act and run so differently than many other industries? Steve Jones takes a stab at explaining this.
2013-06-17
133 reads
Do You Want a Meritocracy at Work?
The best at their crafts are usually the most rewarded in sports, but not necessarily in other fields. This week Steve Jones asks if you would like it to be different?
2013-06-14
187 reads
Data Vision
Computer vision has been something that researchers have worked on for years. We have no shortage of cameras, and we are starting to see the computing systems behind these devices starting to actually understand what is being seen. That understanding is very valuable. Will we see something similar happening in our SQL Server technologies?
2013-06-12
100 reads
The Watson Service
IBM's Watson project continues to grow and the latest implementation might be one that affects many of us in our daily lives.
2013-06-11
115 reads
T-SQL Tuesday #43–Hello, Operator?
It’s T-SQL Tuesday time, and this one is a bit of a challenge for me. Rob Farley is hosting, and...
2013-06-11
944 reads
No R2
The next version of SQL Server was announced last week and Steve Jones is pleased with the name.
2013-06-10
307 reads
The Decision to Fail
When a disaster occurs, the response from your organization isn't always pre-determined. There are times when you might not want to failover to secondary systems, especially if you don't expect the disaster to last long. How do you decide when to fail over?
2013-06-07
121 reads
Quickly Copy Data
Moving data around can be a challenge as the sizes of our databases grow. Steve Jones talks about some of the challenges and some creative ways you might consider moving data.
2013-06-06
281 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