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

181 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,239 reads

This is timely, as I’m currently on a boat in the Adriatic taking a...

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Hi, to all of you who are using CA certs on SQL Server boxes...

Comments posted to this topic are about the item It's Never Just One Thing

Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?