The Importance of Clear Data Displays
An accident on a ship is being blamed on unclear data visualization.
2017-11-06
71 reads
Editorial
2017-11-01
91 reads
2017-10-31
70 reads
Perspective
I find it extremely easy to sometimes lose sight of the important stuff. The day-to-day grind can seriously get in the way. I think this is a big part of how we find ourselves having so many silly intra-organizational turf wars. The developers don’t like how the DBAs do things. The DBAs are frustrated with […]
2017-10-30
74 reads
How Far are You Willing To Go To Get Something?
There are important things in life and in our career, how far are you willing to go to get them?
2017-10-30
112 reads
Physical or Virtual Storage
This week Steve Jones talked about physical hardware, asking who might still pay attention.
2017-10-27
200 reads
Unstructured Data
Unstructured data can be misleading. Steve Jones has a few thoughts today on how he sees this term.
2017-10-26
84 reads
2017-10-25
374 reads
Gigging for a Career
The idea of working on just projects is tailor made for a data professional. Or is it?
2023-11-13 (first published: 2017-10-24)
204 reads
Tell the Judge You Have No Backup
The NYPD is claiming there isn't a backup for one of their databases.
2017-10-23
123 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