Rob Conery

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...

Rob Conery
Jan 3, 2019 2 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...

Rob Conery
Jan 14, 2019 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...

Rob Conery
Jan 9, 2019 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,...

Rob Conery
Oct 1, 2018 7 min read

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
Jan 3, 2019 2 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
Jan 14, 2019 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
Jan 9, 2019 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
Oct 1, 2018 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
Aug 21, 2018 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
Aug 13, 2018 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
Aug 1, 2018 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
Jul 23, 2018 5 min read

Working Smarter, Not Harder, Part 1

This last month has been intense. I'm writing the second volume of The Imposter's Handbook with Scott Hanselman, I moved back to Hawaii,...

Rob Conery
Jul 18, 2018 4 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
Jul 5, 2018 3 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. It took us just over 18 months to put this... Read More

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 took me about 30 minutes to tweak things, but ultimately... Read More

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 setup using a hosted MySQL instance. Read More

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 now taking it seriously. Very seriously. Read More

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 languages. Do you know how your language handles mod? Read More

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 a single transaction. Read More

Simple Monthly Reports in PostgreSQL Using generate_series Working with dates and series of dates is easy in PostgreSQL, especially using generate_series. Read More

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 set this up? Better yet: when should you use full-text... Read More

Working Smarter, Not Harder, Part 1 This last month has been intense. I'm writing the second volume of The Imposter's Handbook with Scott Hanselman, I moved back to Hawaii, and I'm trying to finish up a sprint for a... Read More

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 get going with right away! Read More

More

Imposter’s Handbook, Season 2 is Released

Creating a Massively Scalable Blog with Ghost, MySQL and…

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

Spinning Up a PostgreSQL Database on Azure Using Bash

All Stories

Imposter’s Handbook, Season 2 is Released

Creating a Massively Scalable Blog with Ghost, MySQL and…

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

Spinning Up a PostgreSQL Database on Azure Using Bash

Mod and Remainder are not the Same

Transactional Data Operations in PostgreSQL Using Common Table Expressions

Simple Monthly Reports in PostgreSQL Using generate_series

Setting Up a Fast, Comprehensive Search Routine With PostgreSQL

Working Smarter, Not Harder, Part 1

A Pure PostgreSQL Document Database API

Explore →

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. It took us just over 18 months to put this... Read More

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 took me about 30 minutes to tweak things, but ultimately... Read More

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 setup using a hosted MySQL instance. Read More

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 now taking it seriously. *Very* seriously. Read More

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 languages. Do you know how your language handles mod? Read More

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 a single transaction. Read More

Simple Monthly Reports in PostgreSQL Using generate_series Working with dates and series of dates is easy in PostgreSQL, especially using generate_series. Read More

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 set this up? Better yet: when should you use full-text... Read More

Working Smarter, Not Harder, Part 1 This last month has been intense. I'm writing the second volume of The Imposter's Handbook﻿ with Scott Hanselman, I moved back to Hawaii, and I'm trying to finish up a sprint for a... Read More

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 get going with right away! Read More

All Stories

Explore →

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 now taking it seriously. Very seriously. Read More

Working Smarter, Not Harder, Part 1 This last month has been intense. I'm writing the second volume of The Imposter's Handbook with Scott Hanselman, I moved back to Hawaii, and I'm trying to finish up a sprint for a... Read More