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

111 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,204 reads

I mentioned this in my talk on Quantum Computing at the PASS Data Community...

This was announced last week at Microsoft Ignite and it's been covered by others...

"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...

Comments posted to this topic are about the item The Ending Substring

Comments posted to this topic are about the item Done is Better than Good,...

Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...

In Azure SQL Database and SQL Server 2025, if I run this, what is returned?

SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'