2019-07-12 (first published: 2015-04-28)
378 reads
Editorial
Microsoft Exercise
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
2019-06-07 (first published: 2015-04-27)
1,107 reads
Email In The Bathroom: Not A Universal Good
Here are some fine, affordable products to completely destroy your work-life balance.
2015-04-27
164 reads
Code Reviews
This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.
2018-12-14 (first published: 2015-04-24)
236 reads
Your Role Is Changing
The DBA role is changing with the growth of DevOps as a way to better build software in an organization.
2015-04-23
230 reads
Security Through Chaos
A company Steve Jones knows uses a diverse network infrastructure to help provide security.
2015-04-22
113 reads
Would a Duress Password be a Good Idea?
Today we have a guest editorial from Andy Warren. Should we adopt a duress password, just in case we find ourselves in a movie situation while at work?
2019-09-26 (first published: 2015-04-21)
492 reads
Embrace Stored Procedures
Developers working with SQL Server should learn to embrace stored procedures. They really, really do work well.
2018-11-01 (first published: 2015-04-20)
565 reads
Sweeping out SQL Server 2005
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
150 reads
Monitoring After Deployment
This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do you have a formal way to determine if the changes are causing issues?
2019-06-04 (first published: 2015-04-17)
372 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