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: October 2009

SQLSaturday #21 Shirt Snafu!

Thought I’d share a funny story. Way back before SQLSaturday #1 my friend Shawn recommended a local shirt/embroidery vendor, I went over to meet them, and it’s the proverbial one person shop. Great work, great prices, never failed me yet. The kind of place you call if you need an… Read more

1 comments, 440 reads

Posted in SQLAndy on 16 October 2009

Book Review: The Deceived

The Deceived by Brett Battles

I haven’t post on any fiction lately, thought it was time to write about something more fun than biographies and geek books!

Found this one at the local library, and didn’t take long to realize that I had started at book #2. Good sense would…

Read more

1 comments, 326 reads

Posted in SQLAndy on 15 October 2009

SQLSaturday #21 Is Tomorrow (Oct 17)

I’m writing this in advance because I’ll be busy with all the last minute preparations, but I’m looking forward to a great day tomorrow. We still have a few seats open if you want to attend. The event is free, lunch is $10 (or you can bring your own). We’ve… Read more

0 comments, 245 reads

Posted in SQLAndy on 15 October 2009

SQL Lunch/Call for Speakers

Patrick Leblanc has started a new project called…SQL Lunch! The concept is to present a 30 minute topic every two weeks at lunch. One speaker, one topic, free. I think every other week is sustainable as far as finding speakers, and for those of wanting to make a… Read more

2 comments, 777 reads

Posted in SQLAndy on 15 October 2009

Live Writer Plugin for Amazon

Among the things I’m experimenting with this quarter is changing my book reviews to include an affiliate link to Amazon. I did a couple manually (there are a couple in the pipeline for the next few weeks done that way), but it’s also one extra thing to do, so thought… Read more

2 comments, 303 reads

Posted in SQLAndy on 14 October 2009

PASS Election Voting Has Started

You should get an email if you’re eligible to vote with a subject line beginning with ‘Vote for the 2010/2011 PASS Board of Directors’. Pick three of the four nominees and you’re done. I won’t share who I voted for (yet anyway), but two of them were easy votes, the… Read more

0 comments, 269 reads

Posted in SQLAndy on 14 October 2009

SKUUpgrade =1 in SQL 2005

One of the things on my todo list for this past week was to upgrade a SQL 2005 Standard Instance to Enterprise Edition. I was doing it remote, and started up the install, forgetting – until reminded by the installer – that you have to use SKUUpgrade = 1 when… Read more

1 comments, 598 reads

Posted in SQLAndy on 13 October 2009

PASS Update #15

We just had our October board meeting, this one ran the full hour and was a good discussion, catching up on Summit progress, voting on who will win the PASSion award, and some ideas on future revenue generation to support our efforts. In general I think conference calls are not… Read more

1 comments, 222 reads

Posted in SQLAndy on 12 October 2009

Congratulations to John Magnabosco on SQL MVP Status

See his quiet post about it here. This comes right after finishing up his first book titled Protecting SQL Server Data, available as a free download from SSC. John is a great guy and I’m glad to see that his ongoing efforts in the SQL community have been… Read more

3 comments, 265 reads

Posted in SQLAndy on 12 October 2009

A Not Quite Average Sunday

Ever had a day when a bunch of small things run together to create a day you wish you had missed:

  • Up and at work by 7:30, so far so good
  • Noonish, news that one of my PASS projects appears to be off the tracks, again! Not making my day,…

Read more

2 comments, 301 reads

Posted in SQLAndy on 12 October 2009

Twitter – Should I Twy It?

I try to be balanced on new technology and ideas, trying to find the middle ground between hype and usefulness, time and money, fun and work. When Twitter first came out I didn’t pay a lot of attention besides my usual reading about what’s new, not being a blogger at… Read more

11 comments, 352 reads

Posted in SQLAndy on 11 October 2009

Final Plug for the Networking Seminar at the PASS Summit

If you’re attending the PASS Summit this year I hope you’ve decided to attend the two hour Networking to Build Business Contacts seminar on Monday afternoon. It’s $60, you get a signed copy of How to Start a Conversation and Make Friends by author and seminar presenter Don Gabor, and… Read more

1 comments, 531 reads

Posted in SQLAndy on 8 October 2009

All Offices Should Have A View (Or At Least Windows)

Yesterday was a typical Florida afternoon, sudden down pour of rain, but not a storm. Just slow solid rain for about 45 minutes. Rain always seems to remind me to stop and take a break, watch the world go by a bit. That got me to thinking about having or… Read more

9 comments, 280 reads

Posted in SQLAndy on 8 October 2009

Sparse Columns – ConvertSVtoXML & XMLToResv

Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the  Compute Scalar was backed by… Read more

2 comments, 313 reads

Posted in SQLAndy on 7 October 2009

PASS Editorial for Oct 7, 2009

I currently write the editorial for the PASS Connector which is published every two weeks as part of my role on the Board of Directors. I'm cross posting those editorials here as well as to the main PASS blog.

Just one topic this week – elections! If you haven’t… Read more

0 comments, 301 reads

Posted in SQLAndy on 6 October 2009

Buenos Aires Code Camp

No, I didn’t attend this one!

My friend Jonas Stawski is the organizer and we’ve been pleased to be a minor sponsor the event the last couple years. It’s good karma, and a chance to see how thing work in a different market/culture. For example, one thing you might not… Read more

0 comments, 338 reads

Posted in SQLAndy on 6 October 2009

A Contest for Bloggers – The 2009 PASS Logreader Awards

I’ve been working on an idea for a while with Brent Ozar and Jeremiah Peschka for a contest that recognize the efforts and skills of bloggers in the SQL Server community. We went through a lot of iterations, but we decided to start with a simple contest this time, learn… Read more

6 comments, 1,464 reads

Posted in SQLAndy on 6 October 2009

Spaces in Object Names Revisited

I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and probably not be all upper case either. The spaces are a practical consideration, as soon as you use them you’re forced into bracketing the offending the name ([First Name]). There’s… Read more

5 comments, 759 reads

Posted in SQLAndy on 5 October 2009

A Hint For Recruiters (And You!)

Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we always give them a few minutes to make their pitch. I don’t envy them the task, they get 5-10 minutes to talk to a crowd that is mildly receptive, sitting… Read more

2 comments, 302 reads

Posted in SQLAndy on 4 October 2009

MVP Again

It was nice to work through my email and find a bit of positive news instead of more work! I’m in for another year it seems, and was great to see both Brent and Jeremiah make it onto MVP Island without booting me off. I did about the same amount… Read more

7 comments, 364 reads

Posted in SQLAndy on 2 October 2009

Newer posts

Older posts