Black Box vs. Gray Box vs. White Box Testing
If your organization is spending money, then meaningful results are a must. Pen testing isn't supposed to be a pat on the back. It's supposed to be a tool...
2026-03-17
10 reads
Blog Posts
Tooling for Success: The Best FinOps Tools and Technologies
As a DevOps person, I know that to make FinOps successful, you need more than just a good strategy—you need the right tools and technologies to execute that strategy...
2026-03-17 (first published: 2026-03-16)
30 reads
T-SQL Tuesday #196 Roundup: What career risks have you taken?
I hosted this month’s T-SQL Tuesday invitation in which I asked, “What career risks have you taken?” I got some great responses which I’ll recap here, Career risks? Rob...
2026-03-17
3 reads
Balancing Life with a Career–Slides
I had a great time at SQL Saturday Atlanta 2026 this past weekend. I had some good comments and a few questions. I’ll write a bit more on this,...
2026-03-16
3 reads
Flyway Tips: Multiple Projects
One of the nice things about Flyway Desktop is that it helps you manage your database code as a project and see what changes are being built. However, many...
2026-03-16 (first published: 2026-03-04)
150 reads
What DevOps Look Like in Microsoft Fabric
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps) is an integrated data and analytics platform designed for modern data-driven workloads, such as data...
2026-03-16 (first published: 2026-03-04)
313 reads
Advice I Like: Knots
Learn how to tie a bowline knot. Practice in the dark. With one hand. For the rest of your life, you’ll use this knot more times than you would...
2026-03-13
14 reads
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI, Today on Day 3 I would like to write about LLM models — Open Source...
2026-03-13 (first published: 2026-03-03)
348 reads
Rolling Back a Broken Release
We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode...
2026-03-13 (first published: 2026-02-23)
275 reads
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as cloud adoption has matured, I’ve come to realise that building and running great systems isn’t...
2026-03-12
17 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers