Common Issues When Using Change Tracking for Data Warehouse Incremental Loads

I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...

Data Governance: The Invisible AI Accelerator

The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.

Top 5 Advanced SQL Courses for 2025 (Must-Know)

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's...

Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs

On January 9 I have done an online presentation about Exploring PostgreSQL for the SQL Server Developers and DBAs for the Cloud Data Driven User Group. You can find the...

Setting up a Local LLM

I wanted to experiment a bit with an LLM and training it, so I decided to try a few things. I looked at a few tutorials (see the references...

SQL in 2025: Still the King of Data

Data's the new oil, and SQL is your refinery. It's still the go-to language for shaping, analyzing, and making sense of the data that fuels our businesses. In 2025,...

15 Characters or Less: The Challenge of SQL Server Listeners Name

15 Characters or Less: The Challenge of SQL Server Listeners Name

There is a hard limit on how long your AlwaysOn listener name can be. That...

Removing the REST Endpoint in the Data API Builder

The more I work with the Data API Builder (DAB), the more I lean towards GraphQL instead of REST. Rest isn’t bad, but it’s tough. This is part of...

The Local OLLAMA Gui

I ran a small ollama model in a container and have been doing some experiments. One of the things I wanted to do was get a GUI so I...

A New Word: Amoransia

amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for someone you can never have, wallowing in devotion to some impossible person who could give...