# Thursday, August 2, 2018

GCast 8:

Azure Virtual Machines

What is an Azure Virtual Machine? How do I create one?

Thursday, August 2, 2018 8:19:00 AM (GMT Daylight Time, UTC+01:00)
# Monday, July 30, 2018
Monday, July 30, 2018 11:10:00 AM (GMT Daylight Time, UTC+01:00)
# Thursday, July 26, 2018

IMG_1666Hundreds of people packed the ballroom at the Four Seasons ballroom in downtown Seattle for the World Finals of the 2018 Imagine Cup competition.

Hosts Kate Yeager and Corey Sanders paused.

"And the winner is…"

The crowd leaned forward in anticipation.

They stomped their feet in a simulated drumroll.

They had met the judges; they had heard from Microsoft CEO Satya Nadella and Olympic Gold Medalist Chloe Kim; and they had seen presentations from the three finalists.

IMG_1678Over 40,000 students from almost 200 countries around the world had signed up for this competition, but only the top 40 teams were invited to the Seattle area for the finals. These teams represented 33 different countries, and each pitched their projects - a combination of hardware, software, and business ideas - to a panel of judges. The judges culled the field to 18 semi-finalists; then to 3 finalists and these 3 delivered their final pitches on Day 3.

The 3 finalists were

  • iCry2Talk, a team from Greece that developed a system to analyze the crying of babies,  determine what triggered the crying, and communicate that to parents via text, image, and voice messages.
  • Mediated Ear, a team from Japan that developed software to help hearing-impaired people listen to a single voice in a room full of other voices and noises.
  • SmartARM, a team from Canada that built a prosthetic arm with a camera in the palm, capable of recognizing images and positioning the fingers to pick up the item correctly on a muscle flex.

And now it was time to learn the winner.

And the winner was…


IMG_0659A cheer erupted. Confetti flew from the ceiling. Music played.

SmartArm consisted of Hamayal Choudhry and Samin Khan, students at the University of Ontario Institute of Technology and the University of Toronto respectively.

I was especially pleased to see them take home the world championship. Months ago, I helped mentor them at a hackathon at the University of Toronto, where they won a prize for best use of Microsoft technology; and I've followed them as they put in countless hours of work and great ideas to advance their project to where it is today.

SmartArm took home the top prize - $85,000 cash, $50,000 Azure credits, and a mentoring session with Satya Nadella; but there were many winners beyond them and the other 2 Finalist teams. Many of the teams will return home to turn their projects into business. And many will inspire their classmates to compete next year.

It was an amazing week filled with energy and ideas.

Thursday, July 26, 2018 3:26:17 PM (GMT Daylight Time, UTC+01:00)
# Wednesday, July 25, 2018

TheLastEnchantmentThe Last Enchantment by Mary Stewart's concludes the Merlin Trilogy begun with The Crystal Cave and The Hollow Hills.

The story begins just after young Arthur's ascension to the throne of Britain. It covers Arthur's first decade as high king as he battles the Saxons and unites Britain.

But Arthur is a minor character in this novel, as Stewart focuses on Merlin, the king's cousin, mentor, advisor, prophet, and friend.

Arthur is betrayed by both his half-sisters; but we hear much more about Morgause, because she tries to poison Merlin than about Morgan, who steals the king's legendary sword.

In The Last Enchantment, as in the previous novels, Merlin's mystical abilities are never as powerful as in the familiar legend; his abilities limited to his education, his wisdom, and the ability to occasionally see visions of the present and future.  In this novel, he loses his clairvoyant power, yet retains his value to Arthur as a trusted advisor and mentor.

Despite Merlin's power and stature within the new kingdom, he shows considerable humanity. He confronts the loss of his mystical powers; He confronts his own mortality and how the kingdom will fare when he eventually passes; and he falls in love for the first time in his life. He even deals with his accidental entombment after an Morgause's assassination attempt leaves him in a deathlike state.

I loved this whole series.

I loved Stewart's ability to take a story as familiar as the Arthurian legend and make it fresh and make it her own.

I loved the way she combined the different versions  of the Arthurian legend into a coherent tale.

I loved the humanity with which she injects all her characters - even those with special abilities.

I loved the action and the politics and the romance.

I loved the relationship and loyalty between Arthur and Merlin.

I was fortunate to have discovered this series and I'm happy to have seen the trilogy through to its conclusion.

Wednesday, July 25, 2018 12:30:00 PM (GMT Daylight Time, UTC+01:00)
# Tuesday, July 24, 2018

A package manager is a tool to install desired software and any other components on which that software depends. They do so by reading from a pre-configured package file, which lists dependencies, required configurations, where to retrieve binaries, and the order in which each step must occur.

Many software developers are familiar with package managers, such as NuGet (for Microsoft applications), PIP (for Python) and RubyGems (for Ruby). These are used to add components to a software project.

Chocolatey is a Package Manager designed specifically for installing desktop applications onto a Windows computer, outside of any software project.

You can get started using Chocolatey by navigating to https://chocolatey.org/. Chocolatey requires Windows and PowerShell (which comes pre-installed on current versions of Windows).

Install Chocolatey by opening a Command prompt and typing

@"%SystemRoot%\System32\WindowsPowerShell\v1.0\powershell.exe" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin"

or by opening a PowerShell prompt and typing

Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

You will likely need to open those prompts as an Administrator. Close the prompt when you are done.

choco install openlivewriter -y choco install googlechrome -y choco install firefox -y choco install notepadplusplus -y choco install nodejs -y choco install git -y choco install putty -y choco install nodejs -y choco install visualstudiocode -y choco install paint.net -y choco install dropbox -y choco install fiddler -y choco install azure-cli -y choco install audacity -y choco install visualstudio2017enterprise -y choco install slack -y choco install filezilla -y choco install handbrake -y choco install gitkraken -y choco install camtasia -y choco install snagit -y choco install unity -y choco install azure-cli -y choco install curl -y choco install everything -y choco install spotify –y
choco install icloud -y choco install docker -y
choco install kindle –y
choco install microsoft-teams –y
choco install postman –y
choco install microsoftazurestorageexplorer -y

Once Chocolatey is installed, you can install software with the command "choco install ", followed by the name of the package. Uninstall software with the command "choco uninstall ", followed by the name of the package. You can find existing packages and their names at https://chocolatey.org/packages.

"choco install" and "choco uninstall" have a number of command line switches. I found "-y" to be the most useful, which answers "Yes" to any prompts to download or run software, saving you a lot of time and intervention.

My number 1 use case for Chocolatey is to re-install all my desktop applications after I reset a PC (delete all data and applications and re-install Windows). I have created a batch file named "ChocolateyInstallScript.bat" to install many of my favourite desktop applications.

The script is listed below:


I ran this script this morning after resetting my laptop. It ran for about an hour with no intervention from me. After an hour, all the apps were installed.

Below is part of the output:


The best part is that, for what I am doing, Chocolatey is completely free!

For more information, check out the the Chocolatey documentation here or watch my interview with Chocolatey creator Rob Reynolds here.

Chocolatey provides a a simple way to install and manage desktop applications. It saved me time and energy when I rebuilt my machine.

Tuesday, July 24, 2018 4:06:00 PM (GMT Daylight Time, UTC+01:00)
# Monday, July 23, 2018
Monday, July 23, 2018 8:20:00 AM (GMT Daylight Time, UTC+01:00)
# Sunday, July 22, 2018

Azure blob storage is a good, inexpensive way to store files in the cloud.

Putting some thought into how you will use this data will save you some money.

Azure offers 3 tiers of blob storage access: Hot, Cold, and Archive. Your choice depends on how frequently you intend to access your data.

It is always free to upload data to Azure storage, but there may be a charge to retrieve data.

Hot storage and Cool storage each offers easy, quick access to your files if you want to read or download them. The difference is the price. There are 2 components of Azure storage pricing: storage and data transfer. Storage is the fee for using space on Azure hard drives. Data Transfer is the fee to access your data (for example, you may want to download a copy of a file or point to an image stored in blob storage). Hot storage has higher storage costs, but lower data access costs than cool storage. So, if you plan to access your data a lot, Hot storage makes more sense; for infrequently accessed data, cool storage is cheaper. 

There is a third Azure Storage tier called "Archive" that is designed for long-term storage data that is accessed very infrequently. Archive tier differs from the other two not only in price - but in how quickly you can access your data. The storage price is much lower, and the access price is much higher than the other two tiers. In addition, it may take hours between the time you request your data and the time you can access your data.

Hot and Cool tiers can be set at the storage account level, but Archive tier can only be set for individual blobs.

If you want to store 5TB data in Azure storage the cost per month (as of July 2018) would be:

Hot tier $104
Cool tier $76
Archive tier $10

The cost to retrieve 1 GB of data with each tier would be

Hot tier $0.00
Cool tier $0.01
Archive tier $0.02

To summarize:

Tier Monthly storage cost, 5TB Access cost / GB
Hot $104 $0.00
Cool $76 $0.01
Archive $10 $0.02

Of course, these prices can change over time. You can view the current prices at https://azure.microsoft.com/en-us/pricing/details/storage/blobs/ 

As you can see, the costs can vary significantly. Your choice depends on how frequently you plan to access your data. If you want to store images to display on your web site, the Hot Tier makes sense. If you want to store customer invoice PDFs and you expect people to only review them every month or two, Cool is probably the best choice. If you want to back up your video files just in case your local drive fails (like I did), Archive is more practical, because I might never retrieve those files.

As Azure evolves, these options become more and more driven by the demands of the customer.

Sunday, July 22, 2018 9:33:00 AM (GMT Daylight Time, UTC+01:00)
# Saturday, July 21, 2018

HillbillyElegyJ.D. Vance was never a hillbilly. He isn't even from the hills. He was raised in the southwest Ohio city of Middletown - a rust belt town hit hard economically when a major employer left.

But his family migrated to Middletown from rural Kentucky and displays many of the attributes of the white working class of Appalachia. These people, Vance tells us, identify as "hillbillies". And in Hillbilly Elegy: A Memoir of a Family and Culture in Crisis, Vance describes the attributes of these hillbillies - sometimes through the stories of his own family and neighbors and sometimes through statistics drawn from studies and journals.

Most of those traits are not good. The undereducated, underemployed whites with roots in Appalachia (read "hillbillies) are verbally abusive and prone to violence and share a feeling of hopelessness. They tend to believe that they are not in control of their destiny - that those who succeed were born to better circumstances or were just born smarter. To make matters worse, hillbillies are often dishonest with themselves. They are convinced that they work harder than they actually do and that they attend church more often than they really do. They distrust outsiders; they distrust the government; they distrust the press. These factors combine to keep them poor and exclude them from the American Dream.

They do profess a fierce family loyalty, but only in the sense that they will attack any outsider who insults or otherwise threatens their family. They are generally not supportive of their own family and are often treat one another with cruelty. 

Hillbilly Elegy tells Vance's story of being raised by these folks, the effect it had on him and others like him, and how he was able to escape this culture and graduate from a prestigious law school.

Vance's mother was a drug-addicted single mother, who marched through a plethora of boyfriends and husbands as he was growing up. He nearly flunked out of high school while growing up and many of his friends and neighbors got into trouble and/or made nothing of their lives.

He was largely raised by his gun-toting, foul-mouthed grandmother (aka "Mamaw") and his grandfather (aka "Papaw").

Eventually, Vance graduated high school, enlisted in the US Marine Corps, earned a bachelor’s degree and a Yale law degree.

Three things contributed to Vance's eventual success.

Mamaw succeeded in instilling in him a willingness to work hard and improve himself.

He enlisted in the US Marines right after high school, where he learned discipline and many of the life skills not taught to him growing up.

He was accepted into Yale, where he learned the art of networking to achieve success.

Hillbilly Elegy is an interesting story, about a man who overcome adversity by taking control of his life and rejecting his circumstances.

But is also a social study of an American demographic that is often overlooked - the poor, white working class of Appalachia. These are people whose lifestyle is not well suited to adapting as the economy changed and felt left behind by the rest of America. This feeling of hopelessness may explain why so many of them shifted from the Democratic to the Republican party in less than a generation.

I cannot speak to the generalizations that Vance makes about his people. My ten years living in Kentucky were mostly not spent among the very poor. But I don't doubt his personal experiences and how he was able to overcome his own expectations and his perceived destiny. And I appreciate that he made me think about a group of people in a new light.

Saturday, July 21, 2018 9:09:00 AM (GMT Daylight Time, UTC+01:00)
# Friday, July 20, 2018

I decided I needed to re-image my laptop.

After more than two years, my laptop felt slow. Installing and uninstalling applications and forgotten / unneeded service that are still running made their presence felt in sluggish performance.

I was pleasantly surprised how easy it was do this on Windows 10.


My goal was to completely wipe out everything on my PC and start fresh, so I wanted to know what I was removing and would have to add back.

Step 1 is to back up any data or documents on your laptop. If you are using tools like OneDrive, Dropbox, and GitHub, all your data might already be backed up. This was true for most of my files, but I found a few (most notably my PST email archive) that I needed to back up manually to an external hard drive.

Step 2 is to make note of the applications you will need to re-install after you reset the computer.

Reset PC

Once everything is backed up, you can reset your machine with a clean install.

Click the START button in the bottom left and type "Reset this PC", as shown in Fig. 1.

Fig. 1

This should bring up the "Recovery" screen, as shown in Fig. 2. (Note: If this does not work, you can go to Windows Settings and search for "Reset this PC".)

Fig. 2

On the "Recovery" screen, click the [Get Started] button to launch the "Reset this PC" wizard. The first screen ("Choose an option") of the Wizard is shown in Fig. 3.

Fig. 3

Click the [Remove everything] button to advance the "Do you want to clean the drives, too?" screen, as shown in Fig. 4.

Fig. 4

On this screen, select [Remove files and clean the drive] button to advance to the "Ready to reset this PC" screen, as shown in Fig. 5.

Fig. 5

On this final wizard screen, click the [Reset] button.

This will delete all files, re-install windows, and launch a startup wizard to ask you about things like preferred language and keyboard layout.

When finished, you will have a PC with Windows 10 installed and little else. At this point, you will want to re-install any applications you need and restore desired files from your backup. I used Chocolatey to automate re-installing my applications.

I did this for 2 different laptops. The whole process took about 90 minutes on my 2-year-old Surface Book and about 3 hours on my 4-year-old Surface Pro 3.

The most stressful part was backing up everything and hoping I did not forget an important file. My next project is to make sure everything is included in Dropbox, so I won't need to worry about this.

Friday, July 20, 2018 9:29:00 AM (GMT Daylight Time, UTC+01:00)
# Thursday, July 19, 2018

GCast 7:

Azure SQL Database

Azure MySQL Database

Thursday, July 19, 2018 8:46:00 AM (GMT Daylight Time, UTC+01:00)