Not on the Same Page
It seems that security staff and other technical people are not always on the same page. Steve Jones says that we should be working to take security more seriously.
2011-09-14
96 reads
Editorial
2011-09-13
125 reads
Now you ODBC me now you don't
Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.
2011-09-12
286 reads
A Matter of Life or Death
Could your job as a data professional result in the death of someone? It's entirely possible this might affect you at some point. Steve Jones talks about why you ought to do your best when setting up security.
2011-09-12
158 reads
The Apprentice
This Friday Steve Jones asks if we should reconsider the way we train developers and other computer professionals. Give us your opinion this week.
2011-09-09
137 reads
Learning for Profit
Today Steve Jones talks about a way to improve your skills, make yourself more marketable for that next job, and perhaps earn some money.
2011-09-08
182 reads
The Robot DBA
Steve Jones talks about the idea of an automated DBA and disputes the notion that it will come to pass anytime soon.
2011-09-07
240 reads
From Vandalism to Serious Crime
It seems that there are new types of hacker attacks, not looking to steal information for profit, but for disclosure as an embarrassment. Steve Jones talks about the potential downsides for DBAs.
2011-09-06
130 reads
Labor Day 2011
It's a holiday in the US today and Steve Jones provides a little entertainment for those people still at work.
2011-09-05
74 reads
Piracy and Agile
Do Agile IT projects have anything to learn from the organizational structures and laws used by pirates? Phil Factor is not convinced.
2011-09-05
119 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