Google recently unveiled a dashboard to allow users to manage the data that Google stores about them. Including removing search data! Steve Jones comments on the possibility of implementing this for other companies.
2010-02-24
403 reads
Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.
2010-02-23
334 reads
Can most programmers not program? A new test, the FizzBuzz test, is being used to weed out candidates. Steve Jones comments on the types of FizzBuzz questions he's used in T-SQL.
2010-02-22
1,460 reads
Vendor-specific hardware might make Oracle less painful to use in the future, so Chris Massey considers whether Microsoft should consider providing a more tailored and complete product with SQL Server. The verdict? "Not necessary".
2010-02-22
151 reads
Finding downtime can be hard at times, but Steve Jones recently found a company that took it during the week. This Friday's poll asks when you can have downtime.
2010-02-19
105 reads
Today we have a guest editorial from Andy Warren. Balancing work and life is a challenge, and today Andy looks at one way that has helped him to manage his hours and learn to get away from work.
2010-02-18
116 reads
An interesting point was made by a reader about the price of SQL Server licenses when R2 is released. Steve Jones comments about a penalty that some of you may find if you look to build a SQL Server 2008 server later this year.
2010-02-17
261 reads
Most of us, by definition, are average. That's fine most of the time, but when you want a new job, standing apart from the average Joe is a good idea. Steve Jones talks about working on standing apart from the crowd.
2010-02-16
414 reads
A holiday in the US has Steve Jones on the slopes. A short reminder of patches released last week is the editorial today.
2010-02-15
43 reads
Steve Jones talked about the announcements of Service Pack 4 for SQL Server 2005 and Service Pack 2 for SQL Server 2008 in this editorial.
2010-02-15
174 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
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