Eric Wild Blog

Getting Let's Encrypt Working with Azure Functions

Who this will help? This will help anyone who falls into the two cases below. Create an Azure Functions app that has a custom domain, and an SSL certificate from Let’s Encrypt. If you just need SSL you can use the Microsoft URLs for the site. Create a cheap Static Website with a custom domain and an SSL certificate. Azure Functions can use a consumption model plan to run.

Hearthstone, Entity Framework and JSON

Introduction Sometimes the productivity that .NET offers is stunning! Today was one of those days that I used Entity Framework 6.0 and JSON.NET and a few lines of code to dump a JSON file into SQL server Hearthstone Hearthstone is a popular online card game, but for some reason in the last week 3 people I know have started playing. One was coming off a hard breakup with a smartphone game, Castle Clash, the other likes card games and the last and most important for this story is a statistician, who wants to use his skills to make his mark in Hearthstone.

Misleading SQL server error

The problem This error has caught me more than once, and when you realize what the problem is you understand why. The error you receive is this: >System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Initial thoughts My initial thought was that we were having network issues, and started looking in that direction, which seemed reasonable.

Restoring SQL 2014 Managed Backups to another SQL server

Background Managed or “Smart” backup is a new offering for SQL Server starting in 2014 where you setup a storage device in Azure, setup credentials to that storage device, and then turn it on for the entire server. From that point forward any new database created on the the server, with Full recovery, will do the full and incremental backups, based on the database needs, automatically to your Azure storage.