My first step is to use ModelRight's reverse engineering function to suck the database schema into a diagram. Then I spend a little time arranging the diagram to study the...

I don't use schemas for a few reasons. First, why would you ever put multiple application data in the same database? Brr. Besides, that's what four part names are for if...

Our company keeps an audit trail for particularly sensitive tables' read accesses, but the sheer size of logging every single read-access would quickly fill more hard drives than could physically fit on...

I have to disagree about the mathematics. I've heard this "need math!" creed my whole career (40 years) and it simply is not true. 

Of course, if you're dealing...

If you don't already have it buy Red Gate's SQL Prompt. It will automatically insert fields for you when you type the first part of a SQL statement. VERY convenient!...

DevOps at its core is "talk to the people involved BEFORE changing stuff".

Nice theory. Never works.

The real problem is the illusion of simplicity. A person...

GDPR-like laws are something I hadn't considered, but it makes sense in an absolutist sort of way.

At least here in the U.S. lawyers are more than happy to...