Posts that I send out to other sites like Dev.to and Medium.

Syndication

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

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

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

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

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

A Pure PostgreSQL Document Database API

Another day, another database project in my repo! This time it's a pure PostgreSQL JSONB document storage API that you can drop in and...
Rob Conery
3 min read

The Logical Disaster of Null

I'm in the middle of writing the next volume of The Imposter's Handbook and I found myself down a Rabbit Hole from the very...
Rob Conery
7 min read
>