Giving back [T-SQL Tuesday #102]
This post is part of the May 2018 T-SQL Tuesday blog challenge, “Giving Back“, from Riley Major. It’s been quite a while since I’ve participated in a T-SQL Tuesday....
2018-05-08
9 reads
Blog Posts
Good Seeing
I just finished reading The Perfect Machine about the construction of the Hale Telescope at Mount Palomar (here is a pretty...
2018-05-08
260 reads
Learn, Evolve and Giving Back - TSQL Tuesday #102
This month’s T-SQL Tuesday is brought to us by Riley Major (b | t) and he encourage us to talk about how we are helping by giving back to...
2018-05-08
4 reads
Learn, Evolve and Giving Back – TSQL Tuesday #102
This month’s T-SQL Tuesday is brought to us by Riley Major? (b | t) and he encourage us to talk about...
2018-05-08
359 reads
Power BI Custom Visuals Class (Module 101 – Tachometer)
In this module you will learn how to use the Tachometer. The Tachometer for communicating performance against a goal.
Module 101...
2018-05-08 (first published: 2018-05-02)
2,243 reads
Quick tip: Refresh IntelliSense cache in SSMS
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
274 reads
Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run...
2018-05-08
218 reads
Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run commands from outside of the container and this gave...
2018-05-08
5 reads
SQL and Azure Maze
Something fun for the end of the month. Here are a handful of mazes for you to enjoy. I found...
2018-05-08 (first published: 2018-04-30)
1,957 reads
SQL Server Snapshot vs Read Committed Snapshot
For a quick introduction to transaction isolation levels see my previous post on them.
Once snapshot isolation is enabled on a...
2018-05-08
1,701 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