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

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

Data Strategy Checklist for 2025

The post Data Strategy Checklist for 2025 appeared first on Joyful Craftsmen.

Grinding Away: Brent Ozar

Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...

My 2024 in Data: Music

This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...

Side Projects

Anyone (everyone?) who has ever tried to learn a programming language knows that to really learn, you need a project. I’m a DBA by trade and as such…haven’t really...

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

Database Build Error – Incorrect syntax near DISTINCT

I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account....

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

Introduction to OpenAI and LLMs – Part 2

My previous blog post on this topic was Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and this blog post will talk about the...