Computing – g-blog

Passing the AWS Associate Exam

February 4, 2018February 5, 2018by pgurnigLeave a Comment

Looking for advice on passing an AWS Architecture Associate Exam? I had been looking for that advice very recently. Fortunately, there are plenty of good resources out there to help. (And yes, I did pass the exam recently.) Advice isn't in the form of exam answers. Well, it is if you're willing to dig in. I followed [...]

Using a Correlated Subquery to Update a Base Table

December 19, 2015February 7, 2018by pgurnigLeave a Comment

The syntax for updating using correlated subqueries can be a little confusing at times. The example shown below uses a table variable as its target. The key is to include an aliased version of the table in the UPDATE's FROM clause. Once that is aliased, you can simply reference the alias in the subquery. For example: [...]

Spinning Up a New VM via Azure Powershell

December 19, 2015December 19, 2015by pgurnig

A medium-depth look at spinning up VMs via Azure PowerShell with a couple of extras to help make your PowerShell tasks easy.

An Introduction to Writing Externs in C for Max/MSP

December 13, 2015February 8, 2018by pgurnig

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