Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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.

oPASS Tonight! (April 17, 2014)

I’m presenting tonight at oPASS, two presentations worth! If you’re in Orlando I hope you’ll attend, details at

Read more

0 comments, 56 reads

Posted in SQLAndy on 17 April 2014

Kevin Kline at MagicPASS Tonight (April 16, 2014)

Kevin Kline is speaking at MagicPASS tonight – on two topics! If you’re in the Orlando area I hope you’ll try to attend – Kevin is a top notch speaker, you won’t be disappointed.

Read more

0 comments, 61 reads

Posted in SQLAndy on 16 April 2014

Farewell Brook Ranne

For members of the SQL community in Orlando and Chicago you’ve probably heard that Brook Ranne died on March 29, 2014. Brook was part of our group here in Orlando, someone growing into SQL Server and always ready to volunteer, especially at SQLSaturday Orlando and Tampa where she was almost… Read more

3 comments, 79 reads

Posted in SQLAndy on 15 April 2014

SQLServerCentral Editorial: Doing What It Takes To Get The Job Done

I wrote Doing What It Takes To Get The Job Done about a conversation with my nephew working late to finish up some work. The comments so far are interesting and reflect the challenge of phrases like “get the job done” that can all to easily be abused into excuses… Read more

0 comments, 66 reads

Posted in SQLAndy on 15 April 2014

Writing a Question Of The Day–More Notes

Today I wrote another question based on an error message. I included the error message in the question this time and it’s reasonably helpful, but the question text will, depending on how you read it, point you to the one good answer or convince you the answer must be somewhere… Read more

0 comments, 57 reads

Posted in SQLAndy on 15 April 2014

It’s Not All About The Keys–Question Of The Day

My latest question is live today, called It’s Not All About The Keys. It’s a three pointer, if score matters to you, and that also indicates it’s not an easy or obvious question. I think it’s an ok question. Re-reading it today and reading the comments I still find… Read more

0 comments, 63 reads

Posted in SQLAndy on 14 April 2014

Simple And Amusing Question Of The Day

I was working on a script today to check the range of some values and trying to take the time to handle edge cases, even though I don’t expect them (edge cases!) and ran across something I knew but hadn’t thought about. Good fodder for a question, but not a… Read more

0 comments, 74 reads

Posted in SQLAndy on 11 April 2014

Quarterly Goals

Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to get done. I still think about my long term goals and I still have to do short term planning, but quarterly goals work out to be the most useful measure… Read more

0 comments, 77 reads

Posted in SQLAndy on 11 April 2014

Writing My Next Question Of The Day

I ran into a simple error last week and saved it to convert to a question. It’s another one where if you saw the error, it’s an easy fix. Minus the error it challenges you to visualize and understand how thing work. Overall I spent about an hour on it… Read more

0 comments, 84 reads

Posted in SQLAndy on 7 April 2014

Follow Up To A Questionable Trigger

This question of the day didn’t turn out well at all – required too big a leap the way it was written to get to the key answer. Four were easy, one was not. I confused the issue with a less than great trigger – not deliberately, sadly. The lesson… Read more

0 comments, 62 reads

Posted in SQLAndy on 4 April 2014

SQLServerCentral Editorial: Team Reputation

Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who doesn’t? Most teams are average and that’s ok, but it’s a lot more fun to be part of the big red machine if you get the chance (and have… Read more

0 comments, 62 reads

Posted in SQLAndy on 4 April 2014

The Untold Story of

Back when SQLSaturday was in the #20’s or so I bought, thinking it would be good for an April Fools joke to build a mock ‘adult’ site that catered to/featured people from the SQL community. I was at SQLSaturday #33 in Charlotte not long after that, talking with… Read more

3 comments, 122 reads

Posted in SQLAndy on 3 April 2014

PASS Election Season Begins

Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the PASS Board of Directors) will start on May 14 this year. I’m debating whether I will be a candidate for the NomCom. It’s a good place for me to add… Read more

0 comments, 97 reads

Posted in SQLAndy on 2 April 2014

A Questionable Trigger–Question Of the Day

A Questionable Trigger is the SQLServerCentral Question of the Day today. It’s my latest and perhaps the hardest. Here is the early score:



The comments on it are so so. It’s a tough and tricky question. More on that in a day or two. While you wait, go… Read more

0 comments, 89 reads

Posted in SQLAndy on 2 April 2014

Solid State Tapes–Prelaunch News!

Note: Sorry for the vague details on the tech part, you’ll get all of that tomorrow – this is what I was allowed to post today

In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters.… Read more

5 comments, 78 reads

Posted in SQLAndy on 1 April 2014

Follow Up on The Unusable User–Question Of The Day

I posted about one of my questions of the day called The Unusable User last week and wanted to return to post some final stats and thoughts on how it turned out. First the stats:



Overall the comments on the question were good, especially about the style. I’m… Read more

0 comments, 71 reads

Posted in SQLAndy on 31 March 2014

SQLServerCentral Editorial: The Perfect Environment

I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them here, so trying to resume doing so. Today it’s The Perfect Environment, which is, as you might guess, discussing to what degree you strive for perfection and how far… Read more

0 comments, 84 reads

Posted in SQLAndy on 28 March 2014

Building the SQLSaturday Orlando Marketing Plan–Part 1

I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the main event as well as any seminars we host on Thursday or Friday. We’ve hit a cap the last few years, never getting beyond the 275-300 range (I’ll get exact… Read more

1 comments, 73 reads

Posted in SQLAndy on 28 March 2014

Can’t See The Forest For the Logins–Question of the Day

My latest question is live today – Can’t See The Forest For the Logins is worth 2 points if you’re playing for score. It’s another question where you have to infer some to get the answer. So far it’s proving to be a tough question, be sure to read the… Read more

0 comments, 61 reads

Posted in SQLAndy on 28 March 2014

Speaking at OPASS – April 2014

If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a long time ago! I’ll be back at oPASS in April doing two presentations (to make up for missing 2013!):

Building A Learning Plan

What should you learn next? How…

Read more

0 comments, 100 reads

Posted in SQLAndy on 26 March 2014

Older posts