SQL Server Time Bombs
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental prod DBA) you’ve gotten that frantic call in the middle of the night. Or maybe...
2025-03-12 (first published: 2025-02-28)
552 reads
Blog Posts
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges, the March SQL Practice is the perfect opportunity. This month’s challenge is designed for advanced...
2025-03-11
6,570 reads
T-SQL Tuesday #184–Mentoring
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a good one that asks us where we are making the world better. The topic is...
2025-03-11
6,578 reads
T-SQL Tuesday 184 - Mentorship
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Deborah Melkin
(blog) asks us to talk about our relationship with mentoring and...
2025-03-11
21 reads
Answering Questions On Dropped Columns
Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...
2025-03-10
2 reads
Is Your Business Truly Ready for AI?
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial intelligence into their operations, eager to unlock efficiency, automation, and data-driven decision-making. But while AI...
2025-03-10 (first published: 2025-02-20)
235 reads
SQL Saturday Atlanta BI Recap
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the year. This year was especially sweet to see a lot of the SML (Saturday Morning...
2025-03-10
25 reads
What is Deferred Name Resolution?
One interesting concept in SQL Server is Deferred Name Resolution. This is something many developers struggle with understanding how this works and where it works. In the Microsoft docs,...
2025-03-10 (first published: 2025-03-03)
432 reads
A New Word: Waldosia
waldosia– n. a condition in which you keep scanning faces in a crowd looking for a specific person who would have no reason to be there, as if your...
2025-03-07
29 reads
Enterprise Digital Exhaust
Digital exhaust, or data exhaust, is the information you generate as you interact digitally. We've typically thought of this in terms of tracking cookies and the like, but it...
2025-03-07 (first published: 2025-02-25)
186 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers