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

Accelerated Database Recovery for tempdb in SQL Server 2025

Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieves this is...

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

When it comes to managing complex database environments, having the right monitoring solution is critical. That’s why I’ve relied on Redgate Monitor at different points in my career. It...

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

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

Check Power BI report interactions with Semantic Link Labs

It can be tedious to check what visual interactions have been configured in a Power BI report. If you have a lot of bookmarks, this becomes even more important....

How to Set Up SQL Server 2025, Ollama and NGINX in Docker Without the Headaches

Ollama SQL FastStart kit just works out of the box. It makes it easy to spin the whole Docker Compose stack not in minutes but seconds! Continue reading →
The...

Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition

In my previous post, I showed you how to build a snapshot backup catalog using SQL Server 2025’s new native REST API integration. But what if you’re still running...

Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation

Change is inevitable. What separates thriving organizations from those that falter is not the scale of disruption but how leaders respond to it. In times of shifting technologies, evolving...

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