Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-24
164 reads
Editorial
Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
2009-06-23
342 reads
Grown Up Software
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
2009-06-22
180 reads
Lax Security - Database Weekly (June 22, 2009)
This week Steve Jones talks about database security, or the lack thereof, in today's world.
2009-06-22
122 reads
Going Native
This Friday Steve Jones asks about advice for other DBAs. What's the best way for those intermediate and accidental DBAs to handle maintenance on their servers?
2009-06-19
137 reads
The Best Minds
What do you want when you go to a conference? Great speakers or great information? Steve Jones talks a little about how we get both in the future.
2009-06-18
74 reads
Why Object Databases will always be Tomorrow's Technology
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
2017-02-21 (first published: 2009-06-17)
751 reads
The Simple Estimate
Why can't it be easy for someone to tackle small projects? It is in some areas, and Steve Jones talks a little about some of the issues.
2009-06-16
104 reads
Barriers to Virtualization
Virtualization, and use of the 'cloud', will be essential to the deployment of new applications, but will existing applications will be quite so amenable?
2009-06-15
280 reads
Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
2009-06-15
190 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