SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Archives: December 2015

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…

Read more

0 comments, 706 reads

Posted in SQLAndy on 24 December 2015

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… Read more

0 comments, 680 reads

Posted in SQLAndy on 23 December 2015

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… Read more

0 comments, 958 reads

Posted in SQLAndy on 23 December 2015

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… Read more

0 comments, 657 reads

Posted in SQLAndy on 23 December 2015

$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.

Read more

0 comments, 554 reads

Posted in SQLAndy on 22 December 2015

Immunizations – Not Just for Kids

It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations. This chart shows the suggested immunizations. As soon as I looked at it I realized I need to get an updated tetanus vaccination.  The shingles vaccine is interesting. The… Read more

0 comments, 626 reads

Posted in SQLAndy on 22 December 2015

Thanks to Rodney & Karla

Sometime in the next couple weeks Rodney & Karla Landrum are moving from Orlando to Pensacola (home). I’m happy for them – going home is good!

It’s funny how things work out sometimes. We’ve tried to work at having a plan in place to grow the next generation of leaders… Read more

0 comments, 611 reads

Posted in SQLAndy on 21 December 2015

Advent of Code Contest

I saw the post from Steve Jones about the Advent of Code contest and decided to take a look. The first one is about figuring out which floor Santa is on based on the characters in the string. I don’t know that I’ll do all of them, but it was… Read more

0 comments, 641 reads

Posted in SQLAndy on 18 December 2015

Supporting Khan Academy

Khan Academy is doing a fund raiser and I just donated $10 to help out – my kids have easily gotten that much value out of it (and I wish I could get them to use it more!). Every little bit helps.

Read more

0 comments, 1,726 reads

Posted in SQLAndy on 14 December 2015

SQLSaturday Message Templates – Copy From Other Events

For those of you with access to the SQLSaturday admin site (used by event leaders) one of the things you can do is ‘borrow’ message templates from any event. Start at Message Center on the main menu, then Message History. Pick an event to see all the message they sent.… Read more

0 comments, 575 reads

Posted in SQLAndy on 10 December 2015

The Hour of Code 2015

This year I was interested to see that they did the Hour of Code in the elementary school my daughter attends. Seems like it is catching on. Both of my children did the Minecraft exercise to completion and were pleased to be able to print out the certificate at the… Read more

0 comments, 618 reads

Posted in SQLAndy on 10 December 2015

New Vacancy on the PASS Board

Last week James Rowland-Jones announced that he would be resigning from the PASS Board to accept a position with Microsoft. JRJ was the incoming VP this year  and that causes a certain amount of turmoil:

  • JRJ was appointed to be VP starting in 2016, but because his seat wasn’t technically…

Read more

0 comments, 1,529 reads

Posted in SQLAndy on 7 December 2015

Speaking at SQLSaturday Nashville in January 2016

I’m starting the new year with a trip to Nashville for SQLSaturday #480 to do presentation on automating restores. New topic, trying it out early to see if it will be my ‘presentation of the year’ or not. Hoping to plan my trip so I have time to see more… Read more

0 comments, 553 reads

Posted in SQLAndy on 3 December 2015

Question of the Day: Check, Please

This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on. It should be an easy question for you – how’s that for a challenge?


Read more

0 comments, 549 reads

Posted in SQLAndy on 3 December 2015