Category Archives: Development

How To Get a Free Azure Database

I’ve been doing some testing on Azure database over the past few weeks. Obviously when you move to databases being used as a service you need to pay to get this service, but I did find a nice little workaround that unlocks the “free tier” for SQL Database.

The process is outlined below, but the TLDR version is – create a “WebApp + SQL” in the free tier and the database becomes free. There are some downsides to this of course – the free tier is limited to 5DTU and 32MB size, and it vanishes after a year. But for playing around those values should be fine – and if you need more than that it gives you a good marker for how much Azure Database will cost you, because don’t forget what you are paying based on in Azure DB.

To get your free Azure Database Click on “Create a Resource” and search for “WebApp + SQL”. Select it then click create and you’ll see something like this:

The elusive “Free” tier.

The free tier can be selected from within the Dev\Test toolset:

Free is good.

Then when you select the information for your database the super secret free Azure Database Tier has been unlocked.

Oh look…a secret thing.

Please remember the limits on that free database:

It expires after 365 days

It has only 5DTU

It cannot be larger than 32MB.

Easily enough to run my new CRM on…

A Merry Christmas to the Nephews

Following on from the Birthday Present I made my daughters, I promised my sister some games for her boys Christmas presents.  December turned into a pretty crazy month, but I got the last one finished on Christmas eve.

James Space game is here.

Alex’s Very Noisy motorbike game is here.

And Daniels memory game is here.

 

Best played in Google Chrome or Mozilla Firefox, because some versions of Internet Explorer will not deal with the sound files correctly.

 

A Happy Birthday to My Daughters

I have twin daughters who turned five years old today.  They’ve had a fun weekend of partying, first with their kindy friends on Friday and then with both sides of the family on Sunday.  They have been thoroughly spoilt with all types of different presents, but I’m a strong believer in giving gifts that didn’t just come off the shelf of the local store.  To me that shows a bit of a personal touch and some thought about what it is the recipient of the gifts will like.  It has nothing at all to do with me being cheap:)

Now being a database guy there’s not much of my job that I can share with the girls.  Even though Kaylee asked for a database for her Birthday, we later deciphered she actually meant her own laptop, which is probably a bit much for a five year old.  But a week before the girls birthdays I started dabbling with a tool called construct 2, which allows even a programming Muppet like me to be able to put together a reasonable sort of a game in a short space of time.

So apart from the scooters and My Little Ponies, the girls also got this game made for them for their birthday:  http://www.gumptiongames.net/happybirthday/index.html

Check it out and let me know what you think.