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: June 2010

MS Access Annoyance: Doesn’t Link Synonyms

I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data in smaller projects. Linked tables work reasonably well, just have to create a DSN first.

Except…it doesn’t seem to work (at least obviously) for synonyms. Here’s one I created (viewing… Read more

2 comments, 3,132 reads

Posted in SQLAndy on 30 June 2010

The Breakfast Plan Goes Awry

Here’s the editorial for SSC today and while it’s a humorous story about asking for donuts and getting a free breakfast for everyone, it’s also a cautionary tale for those trying to do good as managers, and even for employees submitting suggestions.

Looking back, I still think it was a… Read more

0 comments, 1,420 reads

Posted in SQLAndy on 29 June 2010

Conference Calls Are Hard

Conference calls are a fact of life for most of us. Remote offices, remote workers, clients – lots of reasons to do a call. Hard to argue with the cost, definitely a money saver. For some things they work well, for situations requiring a lot of collaboration though, they take… Read more

1 comments, 1,420 reads

Posted in SQLAndy on 29 June 2010

PASS Update #35

It’s been a busy month for me for PASS activities. I spent almost the entire week last week on PASS related items and probably 60+ hours for the month:

  • Reviewing the annual budget
  • A call on SQLSaturday to work on plans for 2011
  • Tons of time on the Spring Event

Read more

0 comments, 698 reads

Posted in SQLAndy on 28 June 2010

Growing the SQL Community – Carefully

If you’re a blogger or a twitterer or a SQL speaker or PASS volunteer, you do it because you have found it to be fun, worthwhile, even challenging perhaps. I bet you remember doubting the value before you started and hesitating to take the leap, and maybe you tried it… Read more

1 comments, 551 reads

Posted in SQLAndy on 25 June 2010

Building a PASS Voting Solution – Part 6

Today we’ll try to finish up by looking at a couple of the semi-interesting parts of the code in this one page application. We’ll start with the page load event. On the first run of the page (not postback) I’m grabbing the two keys I need if they exist and… Read more

0 comments, 637 reads

Posted in SQLAndy on 24 June 2010

PASS Board Call For Nominations Open

Nominations opened today and will run through July 21st. Whether you’re planning to be a candidate or not, I hope you’ll visit the election page and review the documents posted. Those documents reflect a lot of time and effort from Hannes and a lot of others to try to improve… Read more

0 comments, 544 reads

Posted in SQLAndy on 24 June 2010

Guest Editorial on SSC – Selling Used Cars/Experience Requires Repetition

I’ve been experimenting with stories in the editorial, experiences of my own that are amusing and have some kind of interesting lesson embedded. Stories can be interesting, uplifting, even tiresome, not sure at all where the boundary is yet, or if it can even be defined that way. The good… Read more

0 comments, 926 reads

Posted in SQLAndy on 24 June 2010

SQLSaturday Orlando Signs

Life in the event leader fast lane, finally got the signs for our upcoming #49 here in Orlando. In past years we’ve gone with the low budget version, but this year since we’ve got ace fund raiser Jack Corbett working on sponsors, we’re investing a little. Ordered 25 of the… Read more

0 comments, 534 reads

Posted in SQLAndy on 23 June 2010

Building a PASS Voting Solution – Part 5

Today we move over to the web side of things. I put this together with VS 2010, and it’s a single aspx page with a single class and a user control. I’m using DevExpress controls (they provide me with a free subscription, good stuff).

Here’s the normal view that a… Read more

0 comments, 572 reads

Posted in SQLAndy on 23 June 2010

Building a PASS Voting Solution – Part 4

We’re almost at the end of the SQL side of things, just needing to send out notifications/reminders. I was torn here, I already had a proc to send a link to a single user, but using it here would mean a loop. Even if it was slow it wouldn’t matter,… Read more

0 comments, 527 reads

Posted in SQLAndy on 22 June 2010


Another “didn’t know” for me, we have multiple feeds from PASS HQ that focus on various areas – grab the entire list from http://www.sqlpass.org/Home/RSS.aspx.

Read more

0 comments, 660 reads

Posted in SQLAndy on 21 June 2010

PASS 2010 Election Nominating Committee Announced

Actually came out last week and I missed it, here is the link to the details of the nominating committee led by Immediate Past President and Big Kahuna Wayne Synder! Call for nominations will open June 23, 2010 – watch sqlpass.org for details on that.

Read more

0 comments, 646 reads

Posted in SQLAndy on 21 June 2010

SQLSaturday Schedule Changes

As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches them so as not to show up and have no one there!

SQLSaturday #45 in Louisville has been moved to January 22, 2011. This will be their second annual event,…

Read more

0 comments, 478 reads

Posted in SQLAndy on 21 June 2010

PASS Update #34 (The “Spring Event”!)

The minutes of the June 2010 Board meeting have been posted and if you haven’t read them yet, you missed a minor but interesting vote embedded there – we’ve voted to hold an event in Orlando in late April/early May 2010 that will consist of 2 full days of sessions… Read more

5 comments, 667 reads

Posted in SQLAndy on 18 June 2010

Building a PASS Voting Solution – Part 2

Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should be interesting to see how I fare with you all:-)

Here are the tables I ended up with:


As you might guess Ballot holds the overall description of what… Read more

0 comments, 739 reads

Posted in SQLAndy on 18 June 2010

Notes from the June 2010 oPASS Meeting

We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may have been a factor in the low turnout of 13 attendees, along with the hard rain shower around 4 pm.

Started just a couple minutes late, ran through the standard… Read more

0 comments, 536 reads

Posted in SQLAndy on 17 June 2010

PASS Update #33

It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and off the cuff voting booth project, trying to give PASS a better solution for voting this year than we had last year. A good 10 hour project to get a… Read more

3 comments, 698 reads

Posted in SQLAndy on 17 June 2010

Building a PASS Voting Solution – Part 1

Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst solution – easy to use, low cost, no real testing to do. But in practice it caused some pain. Quite a few emails to voters were lost to spam filters… Read more

0 comments, 508 reads

Posted in SQLAndy on 17 June 2010

24 Hours of PASS Recordings Now Available

Our most recent 24 Hours of PASS celebrated the SQL 2008 R2 launch. 24 great sessions, 23 of which were recorded, somehow we missed recording the one by Donald Farmer (sorry Donald!) That’s 23 hours of great education (and a little entertainment) that is free for PASS members to view… Read more

2 comments, 578 reads

Posted in SQLAndy on 16 June 2010

Older posts