PostgreSQL error in Fabric Pipelines – No pg_hba.conf Entry for Host
I came across a bit of a weird error when I was trying to connect to a PostGreSQL database (hosted as an Azure DB for PostGreSQL), where “xx.xx.xx.xxx” is...
2024-06-07
235 reads
Blog Posts
T-SQL Tuesday #174 – My Favorite Interview Question
This month is a great topic to me. I think growing and improving your career is a skill that most of us could improve, especially in our younger years....
2024-06-07 (first published: 2024-05-14)
637 reads
T-SQL Tuesday #174: Job Interview Questions
Once upon a time, I used to think of difficult technical questions to ask candidates for a DBA position. However, over time I came to understand that in most...
2024-06-07 (first published: 2024-05-14)
419 reads
Are ABORT_AFTER_WAIT's victims logged?
In SQL Server, using the KILL command to terminate a session results in an entry being logged in the error log.
This raises the question: Does the ALTER INDEX REBUILD...
2024-06-05 (first published: 2024-05-18)
211 reads
Part 2: The Modern Azure Data Warehouse – ADF and ADLS
In today’s data-driven world, having the right tools to manage and process large datasets is crucial. That’s where Azure Data Lake Storage (ADLS) and Azure Data Factory (ADF) come...
2024-06-05 (first published: 2024-05-17)
361 reads
Free Advanced SQL Course for June: Don’t Miss Out!
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with LearnSQL's special offer. For the entire month of June 2024, they are giving away their...
2024-06-04
59 reads
Large System Databases on SQL Server
This one is an oldie in my blog drafts, but a goodie! So, I will finally post it after nearly three years of sitting around. Thank you, past self,...
2024-06-04
75 reads
Automating Container Image Builds with Docker Build Cloud and Github Actions
In a previous post we went through how to use Docker Build Cloud to remotely build a Docker container image from a Github repository. In that example, we kicked...
2024-06-03 (first published: 2024-05-17)
234 reads
Power BI: Refreshable Excel Files in PBI Service
Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...
2024-06-03 (first published: 2024-05-14)
384 reads
Sharpen Your SQL Skills: June’s Challenge Awaits!
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge. Dive into a real-world gym database and help Christine, the gym's manager, wrangle her data....
2024-06-01
60 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