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

138 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,211 reads

If you've ever loaded a 2 GB CSV into pandas just to run a...

What problem is Fabric Ontology trying to solve? For years, most data conversations have...

Recently I ran across some code that used a lot of QUOTENAME() calls. A...

Tlp/Wa_Cs:0818-751-777 Jl. Jenderal Ahmad Yani No.24-26, Panderejo, Kec. Banyuwangi, Kabupaten Banyuwangi, Jawa Timur 68416

Comments posted to this topic are about the item Stairway to Reliable Database Deployment...

Comments posted to this topic are about the item QUOTENAME Quote Parameters

When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?