2011-02-24
2,186 reads
administrator
2011-01-31
2,299 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a “revolutionary computer server”… I think of wonderbox as a “computing appliance”, but Wikipedia limits the...
2010-10-10
10 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to slide it into a commodity status… But on the Exabyte era, we depend on databases...
2010-09-13
13 reads
The application platform for the “Unlimited information” era
“The information age is an idea that the current era will be characterized by the ability of individuals to transfer information freely, and to have instant access to knowledge...
2010-08-22
9 reads
The ‘addicted to data’ decade is still in its infancy
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web or traditional application has no value without data. Few people...
2010-06-25
5 reads
Is Microsoft “years behind” in cloud apps?
Microsoft is associated almost exclusively with Windows and Office. Unfortunately a lot more innovation areas are not well known… Is Microsoft losing the cloud apps? Let me share with...
2010-05-15
5 reads
Opportunities in (I.T.) Chaos
I just finished reading “The next wave of technologies” by Phil Simon. A great read! It proposes a new Enterprise 2.0 - not related to earlier Web 2.0 related...
2010-04-18
8 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year, Amazon EC2 dropped the Beta label and the story accelerated: Less...
2010-04-02
10 reads
2009-07-03
5,242 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