Plan Time for Self-Development

As you begin the new year, if you don't already have time set aside each week for self-development, plan it. Don't just "make time," but actually set up the...

Non-Functional Requirements

I have found that non-functional requirements (NFRs) can be hard to define for a given solution. I’ve seen teams struggle with NFRs. However, to ensure I’m speaking the same...

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