2017-04-20
366 reads
Editorial
SQL Server Telemetry
SQL Server captures information about usage and send it to Microsoft. Is that a problem? Not for Steve Jones.
2017-04-18
863 reads
Liable for Data Loss
Today Steve Jones looks at some data loss lawsuits against Microsoft, but asks the general question of whether software vendors need to be more liable (and careful).
2017-04-17
71 reads
More Power in Your BI
This week Steve looks at all the information and learning available for Power BI.
2017-04-17
124 reads
The Cost of Database Downtime
Do you know what the cost is for your database going down? Maybe more interesting, is do you want to know?
2017-04-14
146 reads
AI Helpers or Replacements
The future will see more of our data used in machine learning and other AI-like systems. Is that something we want?
2017-04-13
53 reads
The Value of Your Personal Data
Today Steve Jones discusses the idea of data value, and what it might mean to you, personally.
2017-04-12
54 reads
2022-12-05 (first published: 2017-04-11)
225 reads
By Design
Just because something works, is it prudent to implement a solution knowing there is a chance this design flaw will be stricken from future revs of SQL Server? It depends.
2017-04-10
77 reads
How do you define employee satisfaction?
This article explores aspects of a job that help one feel satisfied at work.
2017-04-10
98 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