pg-blog

Paul Gurnig

10 posts

ComputingSQL Server Date to Varchar Conversion Formats

  • Paul Gurnig
  • April 11, 2022
SQL has many great date-formatting options with its CONVERT() function. Feature Photo by Andrew Neel on Unsplash

command lineAWS CLI: Filtering for Output

  • Paul Gurnig
  • April 10, 2022
The command below will show only the availability zones for the user’s default Region (as specified in aws…

command lineAWS CLI: Create a Named VPC

  • Paul Gurnig
  • April 10, 2022
Creating a VPC uses the ec2 command. In this example, the VPC will be named “vpc-01”. AWS Documentation…

command lineAWS CLI: List AZs for another Region

  • Paul Gurnig
  • April 10, 2022
In the AWS CLI, you can specify another region without updating your configuration. As an example, for a…

command lineGenerate your Public Key from your Private Key File

  • Paul Gurnig
  • April 9, 2022

ComputingBasic VIM Cheat Sheet

  • Paul Gurnig
  • April 2, 2022
Basic VIM commands to get you started Adding Text Action Command Insert at current position i Insert on…

ComputingSpinning up a New VM via Azure PowerShell – Quick

  • Paul Gurnig
  • December 19, 2015
  A more in-depth version of this post can be found here. This article assumes that you have the…

ComputingUsing a Correlated Subquery to Update a Base Table

  • Paul Gurnig
  • December 19, 2015
The syntax for updating using correlated subqueries can be a little confusing at times. The example shown below…

ComputingSpinning Up a New VM via Azure Powershell

  • Paul Gurnig
  • December 19, 2015
A medium-depth look at spinning up VMs via Azure PowerShell with a couple of extras to help make your PowerShell tasks easy.

ComputingAn Introduction to Writing Externs in C for Max/MSP

  • Paul Gurnig
  • December 13, 2015
Note that this paper was written in 2005-2006 while studying Computer Science at the University of Chicago. At the same time, I had added several Electronic Music courses with Howard Sandroff at UC. This paper might also be subtitled "when worlds collide".
pg-blog