Why use XACT_ABORT?
This came up one day at my work when a developer was using it. I hadn’t used it before and thought I’d better check it out. It’s off by...
2025-04-28 (first published: 2025-04-11)
937 reads
Blog Posts
Kusto Detective Agency - Intro
While I mostly write about SQL Server, I have a soft spot for Kusto. In this series, I will explore solutions to fun challenges collectively known as the Kusto...
2025-04-27 (first published: 2025-04-26)
92 reads
Building Resilience: Leadership Insights from Sports
In the bustling world of sports, leadership appears as a beacon of hope and direction. Imagine a football team, standing on the brink of a crucial match. The players,...
2025-04-25 (first published: 2025-04-08)
223 reads
Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger
There is a SET command in SQL Server that changes how much data is returned from some fields. This short post shows what I learned about the SET TEXTSIZE...
2025-04-25 (first published: 2025-04-07)
485 reads
Announcements from the Microsoft Fabric Community Conference
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference recently. Here are all the new features that I found most interesting, with some...
2025-04-23 (first published: 2025-04-09)
342 reads
T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video on any topic of your choice. I liked his reasoning for this and appreciate his...
2025-04-23 (first published: 2025-04-08)
210 reads
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an old pipeline where I had made some adjustments into as part of a database migration....
2025-04-21 (first published: 2025-04-04)
310 reads
Comparing My Current Schema with a Backup with SQL Compare
A customer asked if they needed to restore a database from backup to compare the schema in a database. They don’t and this post shows that. This is part...
2025-04-21 (first published: 2025-03-31)
266 reads
A New Word: Immerensis
immerensis – n. the maddening inability to understand the reasons why someone loves you – almost as if you’re selling them a used car that you know has a...
2025-04-18
16 reads
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple flask-based TODO application to Azure Container Apps using Pulumi. You will Dockerize the Python application,...
2025-04-18
39 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts