pg-blog

Browsing Category

Computing

8 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: 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…

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