Data Conferences – Worth Every Dollar
Some of the best career enhancers you can buy. Why I Go to Conferences I go for two big reasons: Learning from the best. The folks teaching at...
2025-12-01 (first published: 2025-11-12)
277 reads
Blog Posts
Monday Monitor Tips: ServiceNow Integration
Earlier this year I visited a customer that was using the Redgate Monitor webhook to integrate with ServiceNow. However, they were also trying to integrate in a richer way...
2025-12-01 (first published: 2025-11-10)
315 reads
Prepping for Certification, Part 3 of ?
After I have understood the details for a certification test (part 1), including format and the rules for taking it and after I have taken time to learn how...
2025-12-01
16 reads
Reverse Engineering a Physical Model Diagram
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting, but creating all the objects is a pain. I decided to try creating a physical...
2025-12-01
49 reads
Advice I Like: Failure
If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...
2025-11-28 (first published: 2025-11-14)
430 reads
SQL Training Black Friday Deals
If you're looking for particular "Black Friday" deals, here is what I've seen advertised in the community. I have not taken any of these classes, so I can't give...
2025-11-28
38 reads
Why Databases Still Fascinate Me
I get asked a lot about why or how I began working with databases years ago. I did not wake up one day and decide, “I am going to...
2025-11-28 (first published: 2025-11-10)
415 reads
Happy Thanksgiving! (USA Holiday)
In the United States, today is Thanksgiving. The intent behind the holiday is to remember all that we have to be thankful. I have a lengthy list from friends...
2025-11-27
19 reads
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have...
2025-11-26 (first published: 2025-11-06)
352 reads
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
I mentioned this in my talk on Quantum Computing at the PASS Data Community Summit: Microsoft has announced that the post-quantum cryptography APIs are now generally available.
2025-11-26
160 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...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
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