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
2,426 reads
T-SQL
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,666 reads
2026-10-14
888 reads
2026-10-09
874 reads
2026-10-07
492 reads
2026-10-05
941 reads
2026-09-30
1,387 reads
2026-09-25
1,493 reads
2026-09-23
1,313 reads
Finding Gaps in Sequential Data Using SQL Server
Many systems expect a sequential range of numbers for invoices, ticket numbers, and more. Learn how you can identify where you have gaps in your sequences.
2026-09-21
3,827 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers