SSC Editorial: Turn Out the Lights

This ran a couple weeks ago (Turn Out The Lights) to see if I could spark a discussion about how/when/why we might think more about costs incurred by the way we provide solutions. Based on the follow-on discussion I didn’t quite achieve that. It reminds me that there is a fair amount of resentment (for […]

Notes from the January 2016 MagicPASS Meeting

I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with two different parts; one is about a pattern, the other is about implementing the pattern. We had a much better discussion this second time, but often about the quirks/complexities of my environment rather than the […]

Notes from SQLSaturday #480 in Nashville

Late posting, so reduced notes! Speaker party was good. Room was loud when full due to wood walls and nothing to dampen sound. Finding the college was easy. Finding the building wasn’t quite so obvious. A couple more signs would help and maybe call out where to park a little better – more than one […]

Powershell Saturday in Tampa on March 19th, 2016

I was interested/intrigued to see that we’ll have a Powershell Saturday on March 19th in Tampa. This will be the 10th event in the series – that’s very good progress! I haven’t decided if I’ll attend yet. Definitely interested, but it’s a 2 hour drive, and I’ll be making that drive a couple weeks earlier […]

Thinking About PASS – Operating Reserves

Note 1: I started this post two years ago and am finally publishing even if its not as detailed as the topic deserves. I wrote this to build awareness of reserves in general because they are one of the key indicators of fiscal health for an org. My best guess is that PASS is “somewhat […]

Thoughts on Advent of Code

Over the past couple of days I’ve posted several times about the Advent of Code Contest and worked my way through the first three puzzles, now I’d like to share some thoughts about how it works and what I’ve learned so far: The site is well done. Simple to use and the xmas tree provides a […]

Advent of Code #3 – Part 2

Adding to my solution for #3 part 2, I finally got it, but I paid the price for not adding the “0, 0” to the data set and just assumed I should add one. Bad assumption! Wound up being off by 1 and it took too long to figure that out. select distinct xvalue, yvalue from […]

Advent of Code #3 – Part 1

Part 1 isn’t bad. Parse a string that has direction indicators and track each location you stop at. I’m trying to do one more today and running out of time, so I hurried to a solution that works, but will just suck when I get to part 2 of #3 (2 movers). Skip down to […]

Advent of Code #2

This one gives you a 1000 rows of package dimensions. You calculate the surface area needed for wrapping paper, plus some ‘slack’ that is the area of the two smallest dimensions. The first part is easy, the second – how do you figure out the two smallest numbers when represented as “4x2x10”? First part was […]

$10 to Support Wikipedia Too

I just donated $10 to Wikipedia. I use it and find it useful, so I don’t mind contributing so that it continues and improves.

SQLAndy

Author: SQLAndy