Business Rules

Today we have a guest editorial reminding us that business knowledge is important, and we could all use some training.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2025-11-19

134 reads

Enforce business rules with indexed views and a two-row table

Here’s a technique that uses a view with a unique index and a dummy table with only two rows to trick SQL Server into enforcing your business rules.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(41)

You rated this post out of 5. Change rating

2012-08-20

8,205 reads

Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...

This is kind of a funny page to look at. The next page has...

A while ago I blogged about a use case where a pipeline fails during...

I have a table I didn't design that has tons of repeating groups in...

Comments posted to this topic are about the item Writing as an Art and...

Comments posted to this topic are about the item String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?