And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
2008-05-01
335 reads
Editorial
Should I Buy a Kindle?
Steve Jones still thinks there is a lot of value in books, both fiction and non-fiction, but he's looking at e-Readers, specifically the Kindle from Amazon.
2008-04-30
241 reads
All Data Readers Are Evil
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-29
175 reads
The Exceptional DBA: Soft Skills
If impeccable technical skills are a "given", what are the soft shills that will make you an Exceptional DBA rather than a competent DBA?
2008-04-28
1,461 reads
Easy or Hard
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
2008-04-28
98 reads
Seeing Double
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
2008-04-25
151 reads
2008-04-24
123 reads
The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
2008-04-23
100 reads
Table Level Access
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-22
547 reads
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-21
96 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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