That's all well and good, but you best remember to treat your database administrators like pampered pets rather than commodity cattle, or else we'll wander off and get our fur...

My biggest gripe is a database modeled after what was previously a collection of Excel sheets. It makes sense to one person in the accounting department, and is totally useless...

I would never name a column 'authorization'. It would be something like 'AuthorizationDate' or 'AuthorizationCode', etc.

Sadly, this is T-SQL legal too.

Let's keep this secret to ourselves, lest folks will want to start coding that way.

You're making me think about about SQL Server performance monitoring metrics as an example.

I wouldn't resort to (or rely upon) table locking or serializable isolation level for something like this. It could inadvertently block other processes that only need read access, and at...

Once SQL Agent and SSIS are ported to Azure, I expect they will be contained at the database level, functionality which would probably trickle down to the on-prem version of...