What Counts as Work - in Software Development
Bill explores the consequences of people not seeing the value in doing things that are crucial to the success of projects.
2013-12-11
547 reads
Bill Nicolich
- Interests: E-commerce data. Set-based operations. Automation programming. Architecture of public interfaces and private interfaces within classes. Managing complexity. Evolutionary psychology. Classic literature. The author Joseph Conrad. The author Marianne Moore.
Insensitivity: A Good Technique?
This article explores the place of emotion among knowledge workers doing team-based design activities.
2013-04-05
182 reads
Holidays and other Social Technologies
A look at what passes for technology from Bill Nicolich in our guest editorial.
2012-12-18
121 reads
SharePoint - Subversive?
A reflective editorial on how SharePoints and other collaborative work spaces are getting used.
2012-01-02
234 reads
Visualize Tech Skills
Is your area of responsibility starved for resources? Is it difficult to get a raise? If so, don't despair. You're...
2011-02-24
1,806 reads
Queries for SSC Community Participation
Bill Nicolich uses T-SQL to look at the community participation of people at SQLServerCentral.
2010-12-23
1,597 reads
The Real Purpose for Kindle
It finally dawned on me why people would bother getting a separate book-reading device like Kindle - and why it might...
2010-12-22
1,234 reads
The Development DBA Role
The Development DBA role, though not as common as the more prominent DBA and Database Developer roles in the database...
2010-12-01
4,492 reads
Query-generated Column Expressions
A technique from Bill Nicolich that allows you to target columns by data type for the same custom expression and easily build complex queries.
2010-05-25
8,643 reads
SCRUM Training with Alistair Cockburn
I wanted the SCRUM Master certification this year, and could have gone local, but I wanted to get the training...
2010-04-30
2,100 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