Tag Archives: AdventofCode

Advent of Code 2017 Day 5–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

tSQLt tests for Day 5 Advent of Code 2017

This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

tSQLt Tests for Advent of Code 2017 Day 4

This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading

Posted in Blog | Tagged , , ,

Advent of Code 2017 Day 4–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , ,

tsqlt Tests for Advent of Code 2017 Day 2

This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading

Posted in Blog | Tagged , , ,

Advent of Code 2017 Day 1–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the Advent of Code. I stumbled on the site a few years ago and enjoyed working through … Continue reading

Posted in Blog | Tagged , , | 6 Comments

CROSS APPLY v InLine Functions

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function in SQL Server. This is a computation and given the problem, there is no … Continue reading

Posted in Blog | Tagged , ,

Advent of Code–Day 2

I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it was tricky in SQL I decided this one was worth a post, since I had to futz around a few … Continue reading

Posted in Blog | Tagged , ,

Hash Tables in PowerShell–Advent of Code Day 3

I continue to work on solving the Advent of Code puzzles in both PowerShell and T-SQL after completing them in Python. When I hit day 3 in PowerShell, it was a few new tricks to learn, one of which was … Continue reading

Posted in Blog | Tagged , ,

Advent of Code Day 1, Puzzle B

As I continue through the Advent of Code, albeit slowly, I’m solving each puzzle 3 days. I worked through 6 of them in Python before moving on to other languages, and this is my chance to catch up with both … Continue reading

Posted in Blog | Tagged , , , ,