2020-10-19
458 reads
Administration
Bean Counting to Burnout
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
2020-10-14
111 reads
2020-10-12
488 reads
2020-09-28
477 reads
Do You Know What the Settings Should Be?
Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.
2020-09-28
93 reads
Execute on DMVs without user having View Server State
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
2,293 reads
2020-09-24
498 reads
2020-09-15
464 reads
2020-09-14
570 reads
SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos
Learn how to correct an error that is overloading SCOM by fixing an SPN.
2020-09-10
8,140 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
Best Digital Marketing Strategies
Having trouble attracting leads or visibility online? We develop the best digital marketing strategies...
Best Social Media Marketing Company
Posting regularly but not getting engagement or sales? As one of the best social...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
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