Doubly Wrong
Today we have an editorial that was originally published on Nov 7, 2006 as Steve is at DevConnections. This one talks about SPAM and security.
2011-11-01
75 reads
Editorials
Gold in the Execution Plan hills
There's more information hidden behind those graphical plans than you might first suspect.
2011-10-31
224 reads
Happy Halloween 2011
It's Halloween day, the night for dressing up in costume and being a little silly. Hopefully it's also a fun day without anything going wrong for you at work.
2011-10-31
72 reads
Employee Slurping
This editorial was originally published on Oct 21, 2006. It is being re-run as Steve is out at SQL in the City today. This one talks about the security of USB devices and the potential problems of employees copying data.
2011-10-28
176 reads
Virtualization for Security
This editorial was originally published on Nov 7, 2006. It is being re-run as Steve is at SQL in the City today. Today Steve talks about security using virtualization.
2011-10-27
55 reads
The Good Job
Today Steve Jones talks about jobs, and how life is too short to stick with a crappy job.
2011-10-26
224 reads
The HR Scorecard
If you are looking to gain some BI experience or tackle a project that might help your company, Steve Jones suggests you consider doing something for HR.
2011-10-25
349 reads
Don’t Economize on Processors for Database Servers
In this guest editorial, Glenn Berry argues that, when designing your servers, you need to budget for processing power as your primary concern.
2011-10-24
292 reads
The Cost of Architecture
What's the cost of those architectural decisions that you make? It can be substantial if they aren't good ones, but is that a problem? Steve Jones talks a little about the implications
2011-10-24
161 reads
Which Versions of SQL Server Do You Have?
This week Steve Jones asks about the versions of SQL Server that you have to support in your daily job. Answer this week's poll and let us know the width and breadth of support that you are responsible for maintaining.
2011-10-21
213 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