I started my career on the Microsoft stack building forms and websites using drag and drop tools. Over time that became a punchline, which is unfortunate because honestly, the productivity was insane...
Running PostgreSQL on Azure was always a bit of a sideshow. One of the reasons I returned to Microsoft, however, is that they are now taking it seriously. *Very* seriously.
Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within a single transaction.
Working with dates and series of dates is easy in PostgreSQL, especially using generate_series.
One of the joys of working with PostgreSQL is the ability to run full-text searches right out of the box. But how do you set this up? Better yet: when should you use full-text indexing and how would...
I just released a new book about PostgreSQL, Saturn, and Cassini! Quite possibly the most fun I've had writing about data and databases.
I am not a fan of migrations - never have been and probably never will be. They were interesting when Rails first came out, but now they're pure friction.