Monday Monitor Tips: Lots of Postgres Options
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We added PostgreSQL support in 2023 and that continues to grow. This post looks at a...
2025-01-06
96 reads
Blog Posts
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to really learn, you need a project. I’m a DBA by trade and as such…haven’t really...
2025-01-06 (first published: 2024-12-20)
377 reads
Advice I Like: Experience and Aptitude
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the first time. Therefore when hiring hire for aptitude and attitude and then train for skills....
2025-01-03
346 reads
Database Build Error – Incorrect syntax near DISTINCT
I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account....
2025-01-03 (first published: 2024-06-24)
707 reads
Introduction to OpenAI and LLMs – Part 2
My previous blog post on this topic was Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and this blog post will talk about the...
2025-01-03 (first published: 2024-06-05)
1,309 reads
Plan Time for Self-Development
As you begin the new year, if you don't already have time set aside each week for self-development, plan it. Don't just "make time," but actually set up the...
2025-01-02
34 reads
Non-Functional Requirements
I have found that non-functional requirements (NFRs) can be hard to define for a given solution. I’ve seen teams struggle with NFRs. However, to ensure I’m speaking the same...
2025-01-01 (first published: 2024-05-08)
671 reads
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from Whiteboard to Star Schema (quite the title) by Lawrence Corr and Jim Stagnitto. The book...
2024-12-30 (first published: 2024-12-18)
1,193 reads
Changing the Origin in Git–#SQLNewBlogger
I needed to show a customer how to migrate from Azure DevOps to GitHub recently, and to smooth this process, we needed to repoint the origin remote. Another post...
2024-12-30 (first published: 2024-01-03)
322 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...
2024-12-30
8 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