The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

I had just been playing around with these three functions this morning and for the life of me I could not remember what DENSE_RANK provided.

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

Hat tip to the excellent DBWeekly for the link.


You lost me at “Growth”

Does this stuff really work for people?

I have no objectsions to a cold email/intro/etc, but have some guts and try to actually sell yourself on something tangible.


Very odd icon choice by Apple. I get that this represents my ‘shopping bag’, but clicking on it is the only way to login to your account on the home page without scrolling to the footer.


Estimates are Hard

Sat down at my computer with the goal of making a quick change to a background worker.

My internal clock said “This will take 10 minutes”.

Four commits later, at least 85 minutes had passed*.

Felt like 10 minutes time went by.

Estimates are hard.

* Didn’t plan on timing this, not exactly sure the duration between starting and the first commit, but it should have actually been just a couple of minutes to get it started.

Clickbait and the Candy Diet

Great piece by Seth Godin, The Candy Diet:

Clickbait works for a reason. Because people click on it.