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: September 2008

Notes from the Sep 24, 2008 Orlando .Net User Group Meeting

I don't seem to find the time often, but recently I was able to fit in another visit to the ONETUG meeting. They've got a great venue, a large meeting room at Orlando City Hall, the only downside is finding your way to it the first time and finding parking… Read more

1 comments, 1,371 reads

Posted in SQLAndy on 30 September 2008

Returning Stuff to Amazon

I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return anything (12 video cards that required more power than our machines could provide). The return process was about as simple as they could make it, find the order, click return,… Read more

2 comments, 1,454 reads

Posted in SQLAndy on 29 September 2008

Polos for SQLSaturday

One of things we've tried to do from the beginning is to provide each speaker & volunteer with a good quality polo. Due to luck far more than skill, the shirt picked the first time worked out very well, so rather than be creative we're just sticking with what works.… Read more

0 comments, 1,343 reads

Posted in SQLAndy on 28 September 2008

Cheap Vacation/Travel Books

As you've probably noticed via the blog I read a lot; technical, fiction, and non-fiction. Reading can be an expensive habit. I definitely buy a few books during the year, but especially for vacations I've found it useful to supplement by budget with a visit to my local library (I… Read more

0 comments, 1,709 reads

Posted in SQLAndy on 25 September 2008

Laptops Part 2

EarlierI mused a bit about when and why it makes sense to upgrade to a new laptop. One note I forgot to add is that I use a desktop at work in addition to the laptop (mainly for dev work) and another desktop at home for personal email/finance. So it's… Read more

0 comments, 2,020 reads

Posted in SQLAndy on 24 September 2008

First Time Attendees At User Groups

Several years ago during the first iteration of the Orlando SQL Server Users Group I talked a friend into attending. It was a small group of 10 or less most months, and we strugged for speakers. I had been probably 6-7 times when my friend attended and gotten comfortable -… Read more

0 comments, 1,820 reads

Posted in SQLAndy on 23 September 2008

Mechanical Blog Posts

Mechanical posts are ones that are either auto-generated, or manually input with no real additional work put into them - an example of this in action is if you use Delicious to auto post to your blog each time you add a bookmark. This technique has it's place, but it's easy… Read more

0 comments, 1,028 reads

Posted in SQLAndy on 22 September 2008

Laptops Part 1

I've been using a Dell Latitude for a looong time, probably going back to 2000 or 2001. Decent machine - though I imagine that there's not a lot of difference across brands, was just that the company I worked for at the time was a Dell customer. Recently my partner… Read more

0 comments, 778 reads

Posted in SQLAndy on 21 September 2008

What's Your Favorite Trek Episode?

Most of my posts here are reasonably serious, and really this one is too, but a but of humor mixed in. Fair warning so you don't consider your time wasted. 

I don't mind admitting to being a long time Star Trek fan, though I've never dressed up as a character or… Read more

2 comments, 656 reads

Posted in SQLAndy on 18 September 2008

Tampa Code Camp is December 2, 2008

In recent years this event has been held in July, but this year they ran into problems when the planned venue placed a cap of 250 attendees on the event. Rather than turn people away organizer Keith Kabza postponed the event until a better location could be found. Call for… Read more

0 comments, 451 reads

Posted in SQLAndy on 17 September 2008

Cross Functional Teams & Cross Training

Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking about and I have a short story to support it. Several years ago when I took on management of a team of developers one of the first things I… Read more

0 comments, 550 reads

Posted in SQLAndy on 16 September 2008

Relaunching JumpstartTV.com

We experimented with some video training back in 2004/2005 on SSC, but we just didn't have the time/energy to pursue it, and we didn't see at that time a lot of interest. Eventually Brian decided to put some time into it solo and out of that came JumpstartTV.com. It… Read more

0 comments, 557 reads

Posted in SQLAndy on 15 September 2008

Announcing SQLSaturday #10 - Tampa 2009

Pam Shaw & Wes Dumey are leading the charge for the 2nd annual Tampa SQLSaturday on January 24, 2009. They are just now getting the site set up, but in the next few days I think they'll be issuing the call for speakers. Pam has done a terrific job in… Read more

0 comments, 470 reads

Posted in SQLAndy on 14 September 2008

SQL Code Review - Scalar Variables

One very common mistake I see when reviewing code is the case where the select statement is returning multiple rows, but assigning a column to a scalar variable, like this:

select @ID = ID from SomeTable

It works, but the results aren't necessarily reliable. Probably the most common place I… Read more

0 comments, 514 reads

Posted in SQLAndy on 14 September 2008

Vacations Part II

One of the big decisions around vacations is whether it should be a 'do something' vacation or a 'do nothing' vacation. For example, over the past few years I've vacationed at Disney World (do something), Cocoa Beach (do something), Sarasota (do nothing). Something to be said for both approaches, depending… Read more

0 comments, 1,248 reads

Posted in SQLAndy on 11 September 2008

Blog Review - Yours & Mine

It's pretty common to see a mild plea from blog authors asking for feedback, or ideas about which to write - and typically not much in the way of response. Most of us want to read/learn, not come up with ideas for someone else! Yet it's entirely valid to both… Read more

0 comments, 412 reads

Posted in SQLAndy on 10 September 2008

Upcoming Presentation at the PASS Summit 2008

PASS asked all speakers to update their blogs with news about the event (a good idea), so here's my post!

I'll be doing one sesson this year titled 'So You Want To Be a Manager'. I'm going to talk about the reasons many of us want to move into managment,… Read more

0 comments, 378 reads

Posted in SQLAndy on 10 September 2008

Notes on the Jacksonville Code Camp 2009

I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of the event was 300 attendees, my guess (unconfirmed) was about 100 actual attendees, this due primarily to the hurricane that had just visited the area and having the location of… Read more

0 comments, 460 reads

Posted in SQLAndy on 9 September 2008

Brown Bag Lunches/Training - Do They Work?

I'll define a brown bag lunch as a training event held at lunch time where someone on the team does a technical presentation designed to enlighten/educate others on the team that decide to attend. The original idea was that everyone would bring their lunch in a 'brown bag', but I… Read more

0 comments, 1,035 reads

Posted in SQLAndy on 8 September 2008

Naked Conversations

Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!

I just finished reading Naked Conversations: How Blogs are Changing the Way Businesses Talk with Customers (Hardcover). It's a couple years old now, but still interesting and a lot of ideas for… Read more

0 comments, 351 reads

Posted in SQLAndy on 7 September 2008

Older posts