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.

SSC Editorial: Lessons From Little Green Army Men

This one is about spending time with my daughter – she bought some army men as a toy after a visit to the doctor. It’s also a little bit about diversity because the package of army men was all male.

Writing about father/daughter time is easy compared to writing about… Read more

0 comments, 270 reads

Posted in SQLAndy on 9 March 2016

SSC Editorial: Spousal Surcharges

I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is health insurance and the growing trend of employers charging employees a fee if their spouse has the option to get insurance via a different employer and opts out. Read more

0 comments, 211 reads

Posted in SQLAndy on 9 March 2016

Comments on Proposed Changes to the NomCom Process

On Friday Thomas LaRock posted Changes to the NomCom Process on the PASS blog for comment prior to the Board voting on the changes at the March meeting. If you haven’t read it yet, I encourage you to do so before reading my comments.

First, some quick background and disclosures.… Read more

2 comments, 300 reads

Posted in SQLAndy on 1 March 2016

Building With Iron Pipe

For a while I’ve been wanting to do a project that used black iron pipe for the main structure. Kind of a Lego’ish appeal for grown ups, if such a thing is possible. It’s strong and not hard to work with as long as you can stick to the stock… Read more

2 comments, 302 reads

Posted in SQLAndy on 16 February 2016

Moving to Open Live Writer

I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well enough and I’ve liked having an offline editor. It moved to open source after years of stagnating (though it still worked well enough!) and I’ve finally moved to that version Read more

0 comments, 371 reads

Posted in SQLAndy on 11 February 2016

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, 335 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, 324 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, 335 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, 337 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, 388 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, 340 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, 358 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, 332 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, 345 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, 405 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, 393 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, 550 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, 368 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, 315 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, 362 reads

Posted in SQLAndy on 22 December 2015

Newer posts

Older posts