Absolute and Relative References

This week I caught a short tale of Reitse trying to migrate a Power BI report from one Tenant to another in Fabric. It's something that I would consider a common practice, whether it's from a dev tenant to a prod one, or from a consultant to a client workspace. Moving things around is what we do in the digital world, whether that's schema structure, a report, a data export, or something else. This is common.

And it should be simple, right? I'm not complaining about Fabric here, though it should be easier. I don't know if this is a Fabric problem, per se, or maybe it's a Power BI issue. After all, I should be able to decide and link things in a relative or an absolute manner.

I'm going through this as we test some movement of the SQL Server Central infrastructure. There is a mix of relative and absolute pathing, which breaks the test system. This is similar to the issues I've seen when copying files and configuration inside a local machine. Should I really have d:\git\myrepo\flyway.toml, or should this be .\flyway.toml and assume the reference will be in the repo? There's no easy answer, whether you're using Flyway, Docker, or any software.

This is a place where the user should think for a moment about the future and what makes sense. Every month I I attach a file from SharePoint to an email to my Finance group. Outlook always asks me if I want a copy or a reference. Often, for internal links I want a link, so that if I edit the file (or the recipient does), we edit the same file. However, in this case, this is a document of record, so I want to know what I sent, without edits. If I edit things, I want to resend it.

Often we want relative references, especially in the Cloud and Internet places, where we might move resources around, and we don't want breakage. This is common when moving from dev to test to prod, or from one server to another. However, at times, we want absolute references. On the flip side, I want a standard in my SQL Server instances that puts my data files and backup files in standard locations. Data on the d: and e: drives, backups on the z: drive was a standard we used in one place.

I'm not advocating that you lean one way or the other, but think about the purpose of the item and the future possibilities. Sometimes an absolute reference makes sense, and sometimes a relative one works better. If in doubt, I'd pick the latter, but be sure that whatever software or system in which you work supports this.

Steve Jones - SSC Editor

Making Data AI-Ready, Part 2 (This is the second article in a three-part series on making data AI-ready. Part 1 covered the fundamentals of AI-ready data, this article looks... The...

AI generated ETL ran clean on the first try, and it took six weeks to find out what it was missing. A late Monday file, a file sent twice,...

Along with the broader term of “AI”, “vector” has also been a hot term, but it may not be as clear what it means. You may have also noticed...

A false AI-assisted intelligence report nearly led US forces to intercept a Chinese ship, raising concerns about oversight in military AI.

Xiaomi released MiMo-V2.6 Pro, Flash, and 9B AI models alongside reinforcement-learning resources, giving enterprises new open-weight deployment and testing options.

Learn how to remove prompt noise, separate mixed g...

Chester Ismay, a data science educator and AI consultant, created schedule viewers to keep up with the sports he follows, including the WNBA, NFL, NBA, and Premier League. But...

After my session at VSLive last week, I had a few ...

Eventually, your AI is going to be wrong. Not necessarily because it hallucinated. Not necessarily because the model failed. It might have used stale data. It might have retrieved...

This post familiarizes a practitioner with LLMs, SLMs, and VLMs as well as serving as a field guide for navigating this rapidly evolving terrain. The post The Model Zoo: LLMs,...

The concern that a particular technology is going to destroy the world seems to be an ever present fear. The technology changes but the fear and the marketing around... The...

Learn how attackers exploit SQL Server linked servers, traces, DMVs, and the KILL command - plus the monitoring queries and fixes DBAs need to close these blind spots.… The post...

Query Store Cleaning And Mysterious Broker Tasks W...

I followed the migration of a row through SQL Serv...

Organizations getting real value from AI are not simply investing more. They’re building stronger foundations across strategy, data, governance, adoption and measurement. Here’s what successful AI leaders do differently.  ...

Referrals have never been more important in the jo...

I read a lot of social media posts, and they mostl...

Amazon EventBridge announces an enhanced custom event bus for organizations scaling event-driven applications across teams and accounts. Deploy a single event bus shared across all AWS accounts in your...

As a DBA or any data professional, it is becoming more valuable and vital to have a well rounded understanding of your data estate and environment. However, sometimes it...

Next month on Saturday, October 17, I’ll be spea...

In part 4 of our SWD + AI series, we explore how AI can accelerate the design process to create and refine graphs and slides into effective communications.

Let denote the cumulative distribution function (C...

Medallion architecture is the go-to for handling analytical data, particularly with the prominence of lakehouses in Databricks and Fabric. Whilst the layers are well defined, their definitions don’t tell...

In my previous blog post, How Many Mk1 Toyota MR2s are still on the road, or currently being restored in the UK? we looked at how I used the...

A simple daily average can hide complexities and return different values. We explore several edge-case scenarios to build the desired calculation using AI to accelerate the development.

The time has come: in 2026, using AI to write DAX has started to be effective. Let me recap what has changed between 2023 and 2026, and what we...

This blog post will explain how to capture the data from real-time events for Fabric Operation Events and store the results in a Lakehouse. My approach is to use...

As I come to the end of this initial salvo of material about Fabric T-SQL (more to come as I dig deeper), I wanted to do a final posts...

Fabric licensing isn't one decision, it's two — ...

Snowflake is an increasingly popular option for da...

SQL Server Performance Office Hours Episode 83 – Special Guest Host To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:01:45 – Temp DB Usage Explained 00:03:45...

You’re looking at page split numbers in a monitoring tool or Perfmon, and you’ve heard that page splits are bad, so you’re lowering fill factor, expecting your page splits...

What a 4 TiB Azure Disk Taught Us about Slow Reads...

Prepared transactions are orphaned sessions that hold locks and block vacuum indefinitely.

With PGConf.dev 2027 now on the horizon, I found myself thinking back to PGConf.dev 2026 and all the moments that stayed with me. From 19–22 May 2026, I attended...

Get PostgreSQL running in Docker in minutes with this step-by-step setup guide. Learn to pull the image, run a container, set up volumes, and connect with psql.… The post How...

On the server this article was written against, pg_stat_statements_info.dealloc reads 20, and that counter is all the database has left to say about forty rows an agent deleted. The...

A long time ago I ran a write-heavy system on a hub and a handful of workers. Each worker took a share of the application traffic and wrote events...

max_pred_locks_per_transaction has the naming problem of max_locks_per_transaction, and then one of its own. Like its namesake, it is a table size quoted per backend slot, not a limit on...

Before I get started, yes, I’m going to write about Power BI. If you’re not familiar with my work, the long and short of it is that I tend to keep a healthy distance from anything involving semantic models and reports. Why? In one word, pie charts. Sorry if that triggered you.

A few weeks ago I wrote about how Semantic Link La...

Video by: Reid HavensPlenty of Power BI issues that look like DAX issues start one layer down, in the model. The formula is correct, the relationship underneath it isn't...

Most lending teams don’t wake up one morning and decide they’re comfortable taking on more risk. It builds over time – gradually enough that it’s easy to miss until...

My conversation with Dan Gookin, the original For Dummies author and now mayor of Coeur d’Alene, Idaho, started as a publishing reunion. It ended with a much larger question:...

I wanted to know which US counties have the deadliest roads, measured as deaths per resident. The ranking takes a few lines of R:…

We run a full Chain-Ladder reserving calculation for 233 insurers in a handful of polars expressions, cross-checked against R’s ChainLadder package

I wanted a number I assumed was one line of R away...

I wanted to know how much of a country’s daily electricity demand is just the weather, so I pulled five and a half years…

The STIG is detailed, which is a good thing, but I found myself wanting something a little more practical for day-to-day DBA work. Something I could open, work through... The...

This is an impressive piece of malware. Its sophistication says nation-state to me, but there is no direct evidence and certainly no attribution.

An OpenAI agent accessed an Australian Medicare statistics portal without authorization, prompting a government review of autonomous AI risks and controls.

Hackers captured a Flock camera and got a look (al...

This is pretty amazing: However, the most astonishing thing about this break is that the GPT­6 Astra did it entirely on its own. Carter Leffer only directed GPT­6 Astra to...

NOLOCK double counting is how three people in a lunch line turn into four lunches. Nothing was inserted. One row moved ahead of the scan and got read twice....

Shubnam was packing boxes for a move into a new home when their friend sent them an Instagram video. The footage had only been up for a few hours,...

IBM combined error detection with probabilistic error cancellation, cutting quantum error correction overhead by up to 63 times in a new study.

Databricks is investing more than $350 million in Singapore as enterprises shift from AI pilots toward secure, governed production deployments.

I know it's not nice to mock mistranslations, but would you believe we're laughing with them, not at them? In response to recent criticism of the difficulty of identifying precisely what...