2007-11-22
46 reads
Editorial
Contract or Perm
If you are accepting a DBA position, does it make sense to work as a contractor or permanent employee?
2007-11-21
242 reads
2012-10-29 (first published: 2007-11-20)
222 reads
The Weekly News for November 19, 2007
A few comments on the news of the past week: SQL Server 2008 CPT5, a 1.6SSD Array, Non-Compete agreements and more.
2007-11-19
25 reads
Open Enrollment
It's the time of year where employment benefits renew for many US employees. Steve Jones talks about how much your company should care about your health.
2007-11-19
71 reads
Finding a Balance
This editorial was originally published on Nov 19, 2007. It is being republished as Steve is on vacation. With the tremendous amount of digital storage that people can carry around these days, how do you balance the security risks.
2012-08-31 (first published: 2007-11-16)
159 reads
2007-11-15
106 reads
Incommunicado
Communication is important, and it's a real problem when people can't reach you. Read about an interesting phone accident the some hints for better communication.
2007-11-14
69 reads
Data Breaches
Security is hard, but are we doing a good job? Steve Jones shares a few thoughts on our security development practices
2007-11-13
54 reads
The Pace of Information
Is the rapid pace of information being fed to us a problem? Steve Jones has a few thoughts.
2007-11-12
41 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