Disaster Planning Includes You
Today we have a guest editorial from Andy Warren. Andy discusses the need to consider personnel when you are planning for things to go wrong.
2010-11-23
155 reads
Editorial
Decoupling the Database
Database refactoring is a difficult proposition at the best of times, but is rendered more or less impossible if the database is close-coupled to the application's other components. In a guest editorial, Mladen Prajdic stresses the importance of a native SQL Server abstraction layer.
2010-11-22
2,782 reads
Security by Obscurity
Today we have an editorial reprint from Aug 23, 2005 as Steve is on vacation. Does security through obscurity work? Steve Jones thinks it can help in a limited sense, providing another layer of protection.
2010-11-22
122 reads
Little Devices
This Friday Steve Jones asks if you think that your job could be done with smaller devices. Is there a chance that a mobile phone, a tablet or something else could help you be more productive?
2010-11-19
157 reads
The DBA Disconnect
It seems that there is a disconnect between how technical people view security and how business people see it. Steve Jones talks about the problems that we have in trying to secure the systems we manage.
2010-11-18
174 reads
Are You a Ten?
Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.
2010-11-17
310 reads
Google Scale
Not many of us work at Google scale, where every little thing you do can matter. However Steve Jones thinks that the little things still matter when you are building software.
2010-11-16
231 reads
The Next Step for SQL Server
This past week saw the next version of SQL Server, code named Denali, released as a public CTP. Steve Jones comments on the new version.
2010-11-15
326 reads
Proving Your Identity
We have to provide security for our data, and to some extent that means verifying who has access. SQL Server has limited means for doing this other than relying on the OS, but Steve Jones has some ideas on how to make this more secure.
2010-11-15
137 reads
More Triggers
This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.
2010-11-12
887 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