Opinion   More  

Postgres   More  

All Stories

Imposter’s Handbook, Season 2 is Released

Over the winter holiday break (on Christmas Eve, to be precise), Scott Hanselman and I released the next volume in the Imposter's Handbook series....
Rob Conery
2 min read

PostgreSQL Tools for the Visually Inclined

I started my career on the Microsoft stack building forms and websites using drag and drop tools. Over time that became a punchline, which...
Rob Conery
8 min read

Random Travel Hacks

I love traveling but hate overpacking! In this post I'll offer a few of the tricks I've learned from traveling extensively over the years.
Rob Conery
9 min read

Creating a Massively Scalable Blog with Ghost, MySQL and…

Continuing my little series on “deploying things to Azure with shell scripts” I decided to convert my WordPress script to one for Ghost. It...
Rob Conery
2 min read

Creating a Massively Scalable WordPress Site on Azure’s Hosted…

I get to break things for a living, and this time I'm putting Azure's WebApp for Containers through its paces, trying to get Wordpress...
Rob Conery
10 min read

Spinning Up a PostgreSQL Database on Azure Using Bash

Running PostgreSQL on Azure was always a bit of a sideshow. One of the reasons I returned to Microsoft, however, is that they are...
Rob Conery
7 min read

Mod and Remainder are not the Same

A remainder and a modulus look so very similar, but they are not the same thing and worse, are treated differently by different programming...
Rob Conery
4 min read

Transactional Data Operations in PostgreSQL Using Common Table Expressions

Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within...
Rob Conery
5 min read

Simple Monthly Reports in PostgreSQL Using generate_series

Working with dates and series of dates is easy in PostgreSQL, especially using generate_series.
Rob Conery
3 min read

Setting Up a Fast, Comprehensive Search Routine With PostgreSQL

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...
Rob Conery
5 min read