DBCC CLONEDATABASE issue: Duplicate key row in sys.sysschobjs

I ran into this error recently while trying to clone a production database:
Msg 2601, Level 14, State 1, LineNumber

Cannot insert duplicate...

Prefixated

Are you a prefixer? And by that I mean a developer – or DBA – who uses prefixes on object names? [DISCLAIMER:...

Them Con+cat+enatin’ Blues

We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...

Moneyball And The DBA

“Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the...

Warning: Expect Delays

Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,...

The Hidden Price Of Foreign Keys

Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another...

DBA’s need resolutions, too!

It’s that time of year again: time to make resolutions, then try to stick to them. Sure, we could start...

Is Your Database Overweight?

The obesity epidemic is much in the news these days. The list of health issues related to being overweight is...

The Fine Art Of Translation

I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...

Back To (Security) Basics

Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...