Writing Better Dynamic SQL

Writing Better Dynamic SQL

This updated and "sort" of a style guide is for SQL developers and, to some extent, DBAs, essentially anyone daring (and sometimes...

FabCon Vienna 2025 Recap

Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...

Power BI PBIR Format Admin Setting

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it...

Github Copilot in SSMS can include data in its memory, simple prompt injections ahead

SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is a great feature that can help with writing SQL queries and scripts sql development. However,...

Advice I Like: Failure

If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

Quite a long title for a short blog post ??While deploying a DACPAC (from a SQL Server Data Tools Database Project) through Azure Devops, I got the following error...

Starting Your First Data Warehouse: A Practical Learning Guide

I had a great question asked of me the other day and thought I would turn the answer into a blog post. The question is “I’m an experienced DBA...

Data Conferences – Worth Every Dollar

Some of the best career enhancers you can buy.   Why I Go to Conferences I go for two big reasons: Learning from the best. The folks teaching at...

SQL Server 2025 RegEx and AI

One of the language changes in SQL Server 2025 that I’ve seen a lot of people mention is the addition of RegEx functions to T-SQL. I decided to take...

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

I hosted this month, but I decided to put my own entry in as well. There are more things in this release than I expected, probably because of the...