Click here to monitor SSC
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 and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Speaking at OPASS on February 25, 2016

Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database restores. It’s a still evolving presentation, but one that I think engages attendees. They know how to restore, they know why, so it’s just layering some ideas on top of… Read more

0 comments, 126 reads

Posted in SQLAndy on 2 February 2016

Pausing PASSWatch & What’s Next

I just posted Pausing PASSWatch on the PASSWatch blog, wrapping up a project that ran about 16 months. It’s hard to call it a success, based both on stopping it and not accomplishing as much as I hoped, yet I don’t see it as a failure either. I learned a… Read more

0 comments, 117 reads

Posted in SQLAndy on 2 February 2016

SSC Question of the Day: DBCC Error 6

My latest question of the day on SQLServerCentral is DBCC Error 6. Text of the question below:

As the on-call DBA, you received calls of timeouts and errors on a SQL 2012 SP3 instance used for testing. You track the issue to IO requests that are taking longer than…

Read more

0 comments, 113 reads

Posted in SQLAndy on 2 February 2016

SSC Editorial: Design a Better SQL Server Pricing Model

Design a Better SQL Server Pricing Model ran on January 21, 2016 and as you can guess from the title is about the challenges we have with the current pricing model…and how we might improve it. Nothing simple about that, from our perspective or from that of Microsoft. Ultimately it… Read more

0 comments, 138 reads

Posted in SQLAndy on 1 February 2016

Call for Speakers for Orlando Code Camp 2016 Ends February 6, 2016

Quick reminder that the call for speakers for Orlando Code Camp is open through Feb 6 (next week!).

Read more

0 comments, 164 reads

Posted in SQLAndy on 29 January 2016

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

0 comments, 140 reads

Posted in SQLAndy on 29 January 2016

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

0 comments, 193 reads

Posted in SQLAndy on 22 January 2016

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…

Read more

0 comments, 162 reads

Posted in SQLAndy on 22 January 2016

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

0 comments, 180 reads

Posted in SQLAndy on 5 January 2016

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

3 comments, 233 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, 234 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

2 comments, 355 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, 214 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, 198 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, 237 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, 215 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

8 comments, 281 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

2 comments, 1,329 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, 250 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

3 comments, 269 reads

Posted in SQLAndy on 10 December 2015

Older posts