Cam-Graph
A new project from Microsoft Research has Steve Jones interested. It deals with large data sets to perform graphical modeling. The storage mechanism has Steve Jones interested.
2011-04-25
106 reads
Editorial
Happy Easter 2011
It's Good Friday and the Easter holiday weekend with a number of countries having a bank holiday. Steve Jones is on vacation and providing us with a blooper reel for today.
2011-04-22
92 reads
Saying Thank You
After a bad experience traveling, Steve Jones stops to recognize that despite a possible computer bug, he still recognizes that the programmers building web sites aren't making mistakes on purpose and deserve a thank you for their work.
2011-04-21
175 reads
The Mentoring Experiment
Have you ever wanted a mentor? Do you think that your career would benefit from having one? Steve Jones talks about a new experiment that he is putting in place with Andy Warren that looks to build a mentoring framework.
2011-04-20
278 reads
Careful Blogging
This editorial was originally published on Sept 22, 2005. Steve Jones talks about the dangers of blogging about your job and with your company. Be sure that you are aware of what the impact of your posts will be on your image.
2011-04-19
146 reads
Do we do enough?
Do we, event organizers, tool vendors, concerned SQL citizens, as a community, do enough to reach people who don't know about the training available to them?
2011-04-18
102 reads
Analytics or Flying Cars
We live in a great age of data and Steve Jones thinks it's a great time to be a data professional, especially if you work on your data presentation skills.
2011-04-18
154 reads
2011-04-15
149 reads
The DBA of the Future
Today we have a guest editorial from Andy Warren that talks about what DBAs might need to know in the future.
2011-04-14
691 reads
PAAS
Platform as a service, a new way of looking at applications. It's analogous to SAAS and IAAS, which can improve the efficiency of the software purchase or the hardware acquisition process. Steve Jones notes that this is something he'd like to see for database platforms.
2011-04-13
91 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