A New Word: Querinous
querinous – adj. longing for a sense of certainty in a relationship; wishing there were some way to know ahead of time whether this is the person you’re going...
2025-01-10
124 reads
Blog Posts
BK’s Bookshelf: Never Split the Difference
I picked up Never Split the Difference: Negotiating As If Your Life Depended On It by Chris Voss, a former FBI negotiator. Given what I do, I realized that...
2025-01-10 (first published: 2025-01-01)
443 reads
Capturing Ideas for Blogs
As we close out the year, I decided to drop this post here and maybe inspire a few of you to write in 2025. This post looks at some...
2025-01-10 (first published: 2024-12-30)
1,680 reads
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....
2025-01-10
172 reads
Introduction to OpenAI and LLMs – Part 3
My previous blog posts on this topic were Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and the “how” part Introduction to OpenAI and LLMs –...
2025-01-09
30 reads
2025-01-09
8 reads
Test Post 2
Ut enim ad minim veniam, quis nostrud exercitation ullamco labo-
ris nisi ut aliquip ex ea commodo consequat.
2025-01-09
5 reads
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least, and sometimes even on non-working days. I’ve been working with SQL Server for years now,...
2025-01-08 (first published: 2024-12-24)
2,282 reads
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to...
2025-01-08 (first published: 2024-12-30)
1,764 reads
Monday Monitor Tips: CIS Compliant
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many enterprises think about as their auditors use this as a benchmark. If you’ve never looked...
2025-01-06 (first published: 2024-12-23)
327 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