Women in Technology
A guest editorial from Phil Factor today that points out some of the incredibly contributions by women in technology.
2010-01-06
395 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Why would a SQL Server Professional need an iPhone for work?
In which Phil Factor attempts to justify his iPhones and iPod Touches as a business expense.
2010-01-04
303 reads
Speed Phreaks
A guest editorial from Phil Factor looks at the Speed Phreak competition that has been taking place recently and is quite popular. Read about the inspiration for the competition and why you might want to participate.
2009-11-18
282 reads
Surely It Should Just Work?
Does a programmer need to know how his code gets executed? Arguably, developers should focus on database structures rather than a particular implementation, and Phil tries to convince us that good programming is not just knowing everything about your programming environment.
2009-11-16
139 reads
Phil Factor SQL Speed Phreak Competition
If you have a database application that is running slowly, or is straining the server, what do you do? After...
2009-10-25
3,144 reads
In Praise of Barebones Applications
The English voice of IT reason, Phil Factor, brings us a guest editorial. Today he waxes about the overbearing processes used to build internal corporate applications.
2009-10-01
191 reads
There's No Such Species as a DBA
Phil ponders whether the term 'DBA' is still really meaningful, or if it's just a blunt instrument used to bash a diverse population into a mis-conceived niche. Is it worth the trouble of being typecast, just to have those 3 letters on your CV?
2009-09-21
259 reads
A Good Word for ODBC
A guest editorial from Phil Factor puts in a good word for ODBC. This is the standard for Windows machines to connect to all kinds of data sources, and is both loved and hated by developers of all kinds.
2009-09-10
319 reads
Evil Code
/*
A couple
of years ago, when I wrote the Simple-Talk Prettifier that is really no more than a stored
procedure...
2009-08-18
2,619 reads
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-17
2,916 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
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