Hyper-V Guests
To what extent should a hypervisor company support other software? Will this have implications for cloud computing, or services used in software? Steve Jones comments.
2010-12-16
78 reads
Editorial
We Are Not a Meritocracy
Today Steve Jones reminds us that talent and technical skills are not necessarily enough to advance your career and that you ought to remember to work on other types of skills that you may want to improve.
2010-12-15
216 reads
The Low End
Today Steve Jones talks about those products we consider "low-end." Products like Access or VB. Are they a problem for us?
2010-12-14
177 reads
iPads for Christmas
A contest from Red Gate and Steve Jones could get you a copy of SQL Monitor and an iPad for Christmas. Steve Jones talks about how you can enter, and perhaps win an iPad for yourself this holiday season.
2010-12-13
1,771 reads
How Do You Work When You are Not at Work?
Things have evolved since the days of essential pagers and landline connections. Or have they? Brad ponders how the nature of remote working is evolving, and invites you help others learn from your experiences.
2010-12-13
166 reads
Shrinking Databases
One piece of advice that is often given to new SQL Server administrators is not to shrink their databases. But they seem to do it often enough anyway. For this Friday's poll, Steve Jones asks if we should do away with shrink.
2010-12-10
983 reads
Certified Private Clouds
Microsoft is working to certify vendors to build private clouds, which Steve Jones thinks is a great idea.
2010-12-09
172 reads
Costing Cool Projects
Can you accurately determine the cost or benefit of a new, cool project up front? Steve Jones thinks not, but coming up with new projects can be a way to set yourself apart from others.
2010-12-08
114 reads
Elections
Steve Jones found a very fascinating way that might keep elections more secure, verifiable, and also more open.
2010-12-07
107 reads
How will SSDs change SQL Server storage arrays?
If SSDs are about to make obsolete one of the major driving forces behind the development of SANs (disk latency) then how is the storage array going to change in the near future?
2010-12-06
514 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