2014-11-04
96 reads
Editorial
Normalizing Performance
Determining the best performance value you can get for your effort is not as straightforward as you might think.
2014-11-03
209 reads
The Geek Costume
This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.
2014-10-31
175 reads
Have You Been Hacked?
Security is a big deal, and Steve Jones wonders if most data professionals would be aware that they had been hacked.
2018-07-31 (first published: 2014-10-30)
227 reads
Stuck in a Rut
What do people do when their job doesn't require a lot of technical skills? Steve Jones has a few thoughts.
2014-10-29
168 reads
Triple Digits
Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.
2014-10-28
235 reads
CI and CD Aren't Magic
The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.
2018-08-01 (first published: 2014-10-27)
152 reads
Managers: who needs them?
Managers, look away now. Patrick Index wants to get something off his chest...
2014-10-27
326 reads
When Work Gets in the Way of Work
Work sometimes gets in the way of work. Steve Jones notes this can cause stress and problems over time.
2018-06-27 (first published: 2014-10-21)
218 reads
Why Would You Move?
Most people prefer to work with the platforms that they are familiar with, but there is always pressure to try new, exciting technologies when others have success. Steve Jones explores the idea of switching platforms.
2014-10-20
165 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
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...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
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