Business & Management

Cone of Silence

Once upon a time, I worked for a small company that had a tiny office. It was just a big room where all the developers, designers and creatives assembled, plus a couple of small ones where the owner and his secretary spent most of the time on their phone pitching to new clients or trying [...]

Programming

MS-SQL: Cleaning up duplicates with Common Table Expressions

It is a common pattern to prefer non-semantic primary keys — auto-incremented integers or UUIDs — over semantic ones. It’s advisable to define unique indexes on the semantic identity fields, but sometimes you avoid it for performance reasons or you just forget. When things screw up, you end up with multiple records relating to the [...]

Follow

Get every new post delivered to your Inbox.

Join 336 other followers