The Growth of Storage
This week Steve Jones asks you to predict the future of hardware. When will we have laptops that rival the specs of today's large SQL Server servers.
2013-01-18
116 reads
Editorial
Serious Security
The password issue has Steve Jones concerned. So many of us that use computing devices don't do a good job of securing our information.
2013-01-17
131 reads
Message Queues in Software
Steve Jones talks about Service Broker and messaging and how these techniques can help you build a more robust application.
2013-01-16
271 reads
Cramming for Interviews
Today Steve Jones talks about the questions people ask on the Internet about interviews. Are they ok? Should you cram for an interview this way?
2013-01-15
341 reads
The Java Danger
This week a vulnerability in Java has prompted a large scale notice to the general public.
2013-01-14
164 reads
Global Insecurities
The various security scans of 2012 reported lots of potential problems in companies. Why don't vendors make it easier for us to install and configure their software securely?
2013-01-14
79 reads
The Auditing Poll
Is auditing in use in your applications? Steve Jones wants to know as he thinks it will be more important in the future for most software.
2013-01-11
111 reads
A Patch Disaster
What would happen if the wrong patches were applied to your database server? The results could be a huge problem. Steve Jones reminds you to be careful with mass patches.
2013-01-10
145 reads
2017-03-27 (first published: 2013-01-09)
437 reads
Statistical Protection
Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.
2013-01-08
113 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