December 2015 – g-blog

SQL Server Date to Varchar Conversion Formats

December 23, 2015February 9, 2018by pgurnigLeave a Comment

Often, I find the need for a specific format for a date. SQL has lots of great options with its convert function. Here's a handy chart. select convert(varchar, getdate(), 101) -- 12/23/2015 select convert(varchar, getdate(), 102) -- 2015.12.23 select convert(varchar, getdate(), 103) -- 23/12/2015 select convert(varchar, getdate(), 104) -- 23.12.2015 select convert(varchar, getdate(), 105) -- 23-12-2015 select [...]

Spinning up a New VM via Azure PowerShell – Quick

December 19, 2015December 28, 2015by pgurnigLeave a Comment

A more in-depth version of this post can be found here. This article assumes that you have the following: An active Azure subscription. An Azure PowerShell installation. (This differs from the normal PowerShell installation.) Let’s get started. From the Azure Powershell command prompt, type: Add-AzureAccount Sign in to Azure. To get your SubscriptionName, simply execute [...]

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