What I’ve learned from Groundhog Day.
One of my all time favorite movies is Groundhog Day staring Bill Murray. In case you’ve never watched it (and ... Continue reading
2020-01-10 (first published: 2019-12-30)
424 reads
Kenneth Fisher
SQL Homework – January 2020 – Document, document, document
Happy New Year! It being New Year’s, at least by the Gregorian calendar, I thought we could make this month’s ... Continue reading
2020-01-01
26 reads
What happens if I disable the clustered index?
You are probably already aware that you can disable an index. This can be handy when you have a large ... Continue reading
2019-12-30 (first published: 2019-12-16)
996 reads
A gift. T-SQL Tuesday #121
My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants us to talk about Gifts received ... Continue reading
2019-12-23 (first published: 2019-12-10)
282 reads
Viewing Azure SQL DB security with sp_AzSQLDBPermissions
A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure ... Continue reading
2019-12-18
54 reads
SQL Homework – December 2019 – The default trace and the system health session.
I know this is the holiday season for many of us (which ones depend on your religion and nationality of ... Continue reading
2019-12-17 (first published: 2019-12-02)
445 reads
Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;
One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of ... Continue reading
2019-12-12 (first published: 2019-11-27)
1,133 reads
Session Evaluations from “SQL Server Security from the Ground Up”
I was recently given the opportunity to speak at Pass Summit. As always (this is the second time) this was ... Continue reading
2019-12-12
10 reads
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading
2019-12-11 (first published: 2019-12-05)
661 reads
#PowershellBasics: Working with arrays
I mentioned arrays in a previous post so I figured I should talk about what they are and how to ... Continue reading
2019-12-06 (first published: 2019-11-25)
460 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
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