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...

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...

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...

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...

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...

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...

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...

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...

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...

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...