"I have talked to some people that state "our best practices is to never use..." because they tried it when it was first introduced in SQL Server 2005 and it...

I've used schema's since around 1999, when I started using Oracle. The fact that SQL Server didn't use them has always been strange to me and I was pretty happy...

I'm not so sure about whether I work in the gig economy, but I've been a freelancer since mid 2008 (yeah, great timing, but I was fed up after a...

I'm not so sure about whether I work in the gig economy, but I've been a freelancer since mid 2008 (yeah, great timing, but I was fed up after a...

The department I left yesterday is hiring new datamodellers so my colleague drafted a small test, where the candidate had to reverse engineer a single table with 5 lines of...

In our architecture, we use instances to separate DEV/TEST/QA/PROD, databases to separate logical architecture layers, and schemas as source system namespaces in the staging layer, and as customer namespaces in...

What a great article! I've been pointing a lot of other people to it now that I've found it, because it summarizes my own experience so well.

Although I have...