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
10 reads
Blog Posts
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
A New Word: Lilo
lilo– n. a friendship that can lie dormant for years only to pick right back up instantly, as if you’d seen each other last week – which is al...
2024-12-27
24 reads
How to Find Where Your Databases Reside In The File System
How to Find Where Your Databases Reside In The File System
SQL Script:
Copy
/*
RETURNS LIST OF FOLDER NAMES WHERE SQL SERVER DATABASE
FILES ARE STORED.
It is dynamic...
2024-12-27 (first published: 2024-01-31)
809 reads
Playing with the Data API Builder
I published an article today on the Data API Builder, which is a way of presenting your database tables as a REST or GraphQL API for developers. You can...
2024-12-27 (first published: 2024-12-13)
476 reads
A Very Cool Benefit in SSMS 21
I saw a post from Erin that Preview 2 is available. I’d gotten a message when I started SSMS v21 this morning, but got distracted. I made a short...
2024-12-25 (first published: 2024-12-11)
1,104 reads
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the Basic SQL Practice: A Store course – it's totally free for the entire month! This...
2024-12-25 (first published: 2024-12-24)
30 reads
Creating a “Real” Copy of a View: #SQLNewBlogger
I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table....
2024-12-23 (first published: 2024-12-11)
659 reads
Microsoft Fabric Training and Tutorials
Microsoft Fabric is the new data offering in Microsoft Azure and there is a great deal of interest in it. How do you get started? Where are the tutorials?
2024-12-23 (first published: 2024-04-29)
815 reads
A New Word: Suente
suente– n. the state of being so familiar with someone that you can be in a room with them without thinking, without holding anything back, or without having to...
2024-12-20
28 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