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
14 reads
Blog Posts
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
25 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)
828 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)
477 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,105 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)
666 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)
822 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
Data Strategy Checklist for 2025
The post Data Strategy Checklist for 2025 appeared first on Joyful Craftsmen.
2024-12-20 (first published: 2024-12-16)
392 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
BCA Multifinance Surabaya Timur Tlpn.Wa 083834802131
Ruko Soho Emas, Jl. Klampis Jaya No.39, Klampis Ngasem, Sukolilo, Surabaya, Jawa Timur 60117
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers