Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Learn how to use CHOOSE() and IIF() to validate priorities and return easy to read messages to the user.
Communication, For Incidents and Life
Many years ago, I was on call for a production system. This was common for me since I was one of several production DBA’s for the company. It was a normal weekend for me, and I got up and started playing with my kids. They were heavily into trains, and we were laying out our […]
How to Create an Alert in the Microsoft Fabric Warehouse
We are building a new data platform with Microsoft Fabric and we’re using the warehouse for our “gold layer”. We don’t have real-time ingestion or analytic requirements, but we have a use case where we want to send an alert if a certain threshold is reached. Ideally, the alert is sent when a SQL query returns a result set.
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
In part 4 of this series, we look at using CROSS APPLY to filter in a function.
Training the next generation
Many years ago, I started at a smaller-sized company. About 150 employees; it was a SaaS company that provided survey software. It was growing quickly, and I was the primary DBA. I was hired not only to be a DBA, but to build a DB team to handle many of the issues the company faced […]
What happens when your AI coding agent starts a database on its own
How to build an app through an LLM: switching from CoPilot to Claude, a directional term-lookup feature
Risk Vs Reward, The never ending ROI discussion.
This week I hosted T-SQL Tuesday. This monthly event suggests a topic for bloggers to write about. It’s been going on for many years, and you can find more details here. https://tsqltuesday.com/ For my specific post, you can find the summaries here. T-SQL Tuesday #203 — Summary/Follow up I’ve spent 20+ years being asked questions about […]
I Struggle
This one is going to involve a lot of honesty & self-reflection. Run now. You've been warned. I know for a fact that I'm blessed. I'm healthy. I have a loving family. There are friends out there happy to see me when we meet. I've got one of the single greatest jobs ever. I live […]
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
This article shows two scenarios, tested independently, with the full scripts and the real numbers from each run.
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Pondok Ungu Bekasi Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Sultan Agung No.19-20 Kavling Blok A, RT.007/RW.007, Medan Satria, Kecamatan Medan...
Alamat BCA KCP Central Park Telp:0821°8200°203
Telp/Wa 628218200203 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren,...
Alamat BCA KCP Ruko Swadaya Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers