One thing you can always do to ensure justice to assure you're doing good Capital "G", Good ...is to always try to come back to something you love daily, and to try to make it better just a little bit better, a little more helpful a little less heavy with mistakes a little bit better [...]
Author: pgurnig
AWS – Deploy a Static Website to S3 using the CLI
(This article assumes a folder with existing code for the website on your local machine. ) The steps are: (Optional) If the bucket already exists, remove it using rb. Create the bucket using mb. Recursively copy the local web files to the target using cp. Instruct S3 to treat the bucket as a static website. [...]
S3 Buckets: Create, Put, Read
Using Amazon's CLI is handy, quick and often preferable to going through the Console. I wanted a way to read billing information from the command-line without having to log into AWS. Exporting billing information to an S3 bucket is not the scope of this article. (Here is an article to help with that.) The goal [...]
Nicaragua, Forget Paris
Nicaragua was not on any of our lists of places to visit -- I don't think my wife and I had ever even said the word Nicaragua to each other before my wife's company began doing business there. For a Central American trip, Costa Rica would have been a more likely choice, and we had [...]
Friendly Hostnames with SSH
This article is for Mac OS X, 10.9.5. We'll review how to log in to a machine on AWS using a friendly hostname rather than an IP address. If you have many servers in your care, recalling all the related IP Addresses can be tedious, confusing and error-prone. Keeping a list in a database or [...]
Inspiration
Hustle. I'm seeing a lot of it these days, and in ways that are inspiring. Many of the people I'm meeting up with these days are part of new businesses, or they are revitalizing and transforming existing ones. It doesn't really matter which. They seem energized with the possibility of something better, and fatigued by [...]
SQL Server Date to Varchar Conversion Formats
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
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
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
A medium-depth look at spinning up VMs via Azure PowerShell with a couple of extras to help make your PowerShell tasks easy.
g-blog 
You must be logged in to post a comment.