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.

Project Moriarty

This past weekend I started writing notes for what I’m calling Project Moriarty, what I hope will be five questions in a row that have to be solved individually, but then based on information in the questions and correct answers will lead those that complete the challenge to solve the… Read more

0 comments, 104 reads

Posted in SQLAndy on 7 July 2014

Feedback on My Abstracts

Here’s the raw feedback from my submissions for the Summit. To those who wrote the feedback for me (and all the rest), I say nicely done. As much as I’d wish for still more feedback, this is useful. The only complaint I have is about “contractions” being a rule that… Read more

1 comments, 158 reads

Posted in SQLAndy on 3 July 2014

The Selection Process

According to this post from Amy Lewis (PASS Board of Directors) there were 943 abstracts submitted for the 2014 PASS Summit by 335 speakers competing for 144 slots on the schedule. An abundance of riches to be sure, but it also marks a time of expectation, exultation, disappointment, and even… Read more

0 comments, 131 reads

Posted in SQLAndy on 2 July 2014

The Case Of the Downward Pointing Arrow-Question of the Day

The Case Of the Downward Pointing Arrow is written as an abbreviated mystery, Sherlock Holmes style. Had to laugh at the comment about me being Moriarty in disguise! No one has so far figured out the identity of the client mentioned in the question.


Read more

0 comments, 141 reads

Posted in SQLAndy on 2 July 2014

Above Reproach

It’s been a busy few weeks in the world of PASS, lots of good conversations that I’ve followed with interest, in particular this post by Kendal Van Dyke, then follow up posts from Bradley Ball and Andy Leonard, as well as others that were more focused on the… Read more

5 comments, 158 reads

Posted in SQLAndy on 2 July 2014

Speaking at ONETUG on July 10, 2014

I’ll be presenting SQL Server Performance for Developers to the members of the Orlando .Net User Group (ONETUG) on July 10th. It’s been forever since I made it downtown to see the group, looking forward to it and sharing some techniques for making SQL Server go fast. Registration appreciated if… Read more

0 comments, 97 reads

Posted in SQLAndy on 2 July 2014

A Deeply Planted Seed-Question of the Day

Another trivia question today, this one about figuring out which of the options provided has a particular negative identity seed. See if you can get A Deeply Planted Seed right and earn one point for the effort!

Read more

0 comments, 112 reads

Posted in SQLAndy on 1 July 2014

SSC Editorial: The Product Centric Career

The Product Centric Career is my latest editorial for SQLServerCentral, this one from the perspective of my own career and how I sort of made decisions that led me to focus on SQL Server.

Read more

0 comments, 151 reads

Posted in SQLAndy on 30 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 21

Been busy the past week, not as much time on this as I’d have liked:

  • Received the “retro” flyer with the minor revisions we requested
  • Decided flyers are final in design, just need to get them all into PDF
  • Had our first weekly call and talked about the tempo for…

Read more

0 comments, 197 reads

Posted in SQLAndy on 27 June 2014

What is 268435456?

What is 268435456? is the Friday question of the day. It’s a trivia question, but maybe an interesting one for all that. Better than 50% getting it right, not bad for a Friday question!


Read more

0 comments, 207 reads

Posted in SQLAndy on 27 June 2014

The Great Escape-Question of The Day

The Great Escape is the question today, one I think you will like because…it’s about LIKE! It’s a head scratcher. The comments on this one so far have been really good and that’s good, I need to look for more arcane topics (LIKE is common, the ESCAPE part is not).… Read more

0 comments, 101 reads

Posted in SQLAndy on 25 June 2014

Speaking at the 2014 PASS Summit

Finally the email we’d all been waiting for arrived yesterday, the results of session selection for the 2014 PASS Summit. Good news for me, one session of mine was accepted, so I’ll be presenting “Turbocharge Your Career With A Learning Plan” this year. It’s a good topic and one I’m… Read more

2 comments, 109 reads

Posted in SQLAndy on 25 June 2014

Finding Checked Out Files in TFS

There may be an easier way, but this was a quick way to find ALL the checked out files in TFS, something I needed so I could make sure no one from the data team had anything checked out prior to some consolidation/maintenance. The “Developer Command Prompt for VS2012” resolves… Read more

0 comments, 128 reads

Posted in SQLAndy on 24 June 2014

No Files For You

No Files For You is another Question Of The Day. I ended up making this one just a little more ambiguous than I meant to, interesting to see the different takes on it in the comments. I’ll say again, reading that stuff, what a great way to learn about writing…

Read more

0 comments, 138 reads

Posted in SQLAndy on 24 June 2014

SSC Editorial: Bad Meetings or Meeting Badly

Bad Meetings or Meeting Badly is the editorial of the day today. Looking at it today, I wish I had done a better job on the title, because my intent (and execution) is to get attendees to see the other side of the coin on meeting requests. Take a look… Read more

0 comments, 117 reads

Posted in SQLAndy on 23 June 2014

Reading, Writing, and Riskmetic-Question of the Day

Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance while giving not giving them more access than needed. Great conversation that followed it, in particular read the comment here by Gail Shaw.

Read more

0 comments, 124 reads

Posted in SQLAndy on 23 June 2014

Poecilonym Madness-Question of the Day

Poecilonym Madness! is my latest question that tests your knowledge of creating/dropping tables, views, and synonyms. Here’s the fun part – there are six correct answers to this one, that should be enough to challenge you on a Friday!

Read more

0 comments, 166 reads

Posted in SQLAndy on 20 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 20

Next week will begin our weekly planning call, so ahead of that (and perhaps a bit later than I should have) I sent out my draft calendar and marketing plan. It was hard to let go, I really yearn for the detail of a full project plan, but that’s just… Read more

0 comments, 121 reads

Posted in SQLAndy on 19 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 19

Below is the chart Kendal Van Dyke maintains for us in Orlando showing year over year registration counts. Don’t I wish this was baked in to the admin tools! You can see the trend has been remarkably consistent over the years (and we see the same with PASS Summit registrations,… Read more

0 comments, 102 reads

Posted in SQLAndy on 19 June 2014

Building The SQLSaturday Orlando Marketing Plan-Part 18

I’m on vacation this week, but enjoying some quiet time during the day to think a little, going back through my first 17 posts and wishing I had them printed – sometimes marking up a document is good for thinking!

First, a recap of key items on the task list… Read more

0 comments, 150 reads

Posted in SQLAndy on 17 June 2014

Newer posts

Older posts