Advent of Code

I ran across this site after reading a post from Jeremiah Peschka. It’s an interesting idea, and since I’m trying to improve my development skills in between the rest of my work, I thought this would be fun.

Advent of Code is a site that has a neat idea. A series of puzzles, two a day, that are released each day leading up to Christmas. Since we’re within the 25 days, I’m late (and so are you), but you can join in anytime.  It’s also cool since it’s a fixed font, console looking site.

2015-12-11 10_25_46-Jump List for SQL Server 2014 Management Studio

The idea is that you get requirements for a puzzle, that you must code to solve. The inputs are too long to do by hand, though I suppose if you wanted, you could solve them in Excel. If you solve the first, you get the second.

You can solve them however you’d like. I started doing some in Python, and also then re-solved them in Powershell. It’s mostly to just get some practice coding, and these are good excuses. I have been doing Python first, but I may switch to Powershell first, just to practice. If I get time, I’d like to redo them in C# as well.

If you are looking to do some programming on the side, and practice something, this is a good way to focus on a particular problem and have fun. If you get stuck, there is even a subreddit with people posting questions and answers in a wide variety of languages.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

7 Responses to Advent of Code

  1. Pingback: Advent of Code Contest | SQLAndy

  2. Pingback: Advent of Code | Simple SQL Server

  3. Pingback: Advent of Code - SQL Server - SQL Server - Toad World

  4. way0utwest says:

    Very cool. I haven’t tried any in T-SQL, but I’ll definitely cheat and take your insert statement when I do. Busy with life, so I’m on Day 7, but it’s tricky. One I need to work on more as I get time.


  5. Tom Thomson says:

    I’d like to join in, but the AdventofCode site throws an error when connecting (after the authenticating site has OKd the connection).


  6. Tom Thomson says:

    I don’t know what was going on there, it started working when I tried it again a week or so later.


Comments are closed.