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.
2026-10-21
21 reads
Articles
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.
2026-10-21
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
2026-10-21 (first published: 2026-09-28)
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.
2026-10-19
1,465 reads
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
2026-10-19
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.
2026-10-16
1,748 reads
Explanation of SQL Server IO and Latches
I eventually found an explanation for this error message that, while not completely satisfactory, did lead me to diagnose wider-reaching I/O issues on the affected instance and led me to a better understanding of latching in general.
2026-10-16
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
A SQL Server upgrade left a log shipping secondary unable to accept transaction logs. Re-seeding it without touching the primary or its mirror is straightforward in principle — drop, restore full + diff + log with NORECOVERY, hand back to the job — but three undocumented traps will stop you along the way. Here's what they are and how to get past them.
2026-10-14
970 reads
Should your SQL Server database use foreign key constraints?
Should SQL Server databases enforce foreign key constraints? A veteran DBA breaks down the real arguments
2026-10-14
Calculating Min-Max Normalization in PowerBI
Learn how to normalize values in Power BI to allow you to compare disparate different data.
2026-10-12
1,020 reads
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
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
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