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

Notes From My Visit with the Charlotte SQL Group

I'm headed back to Orlando after a quick trip to Charlotte. Flew in yesterday and spent some time with my friend Peter Shire and team (including Brooke!) of SQLSentry talking about all manner of stuff that comes up when you get some techies in a quiet room; business, user groups,… Read more

0 comments, 1,290 reads

Posted in SQLAndy on 28 February 2008

Using TripIt for Travel Plans

Not a SQL related topic today. 

I first noticed Tripit on Joels Blog and so far it solves a problem I've had from time to time; making sense out of all the various email messages I get when I book a trip. Their implementation is simple, just forward the email… Read more

0 comments, 1,279 reads

Posted in SQLAndy on 26 February 2008

Snapshots Part 1 Published on SSC

Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In Part 2 coming up in the next couple weeks I dig a little more into the underlying process -  not critical to know but helps dispel the black box syndrome. Read more

0 comments, 1,239 reads

Posted in SQLAndy on 26 February 2008

Perks at Work - A Good Thing?

Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone forwarded to me. But are these good things? Don't get me wrong, free is good, but there are a few things I think about when it comes to perks:

  • Are…

Read more

0 comments, 1,413 reads

Posted in SQLAndy on 25 February 2008

Lessons Learned from SQLSaturday #2 - Tampa 2008

I posted earlier about the event being a great success with more than 200 attendees, in this post I want to focus on things that went not so well because we learn more from our mistakes. Please don't think Im criticizing Team Tampa - Im not - I suspect they… Read more

0 comments, 1,472 reads

Posted in SQLAndy on 24 February 2008

LINQ Again!

I recently attended SQLSaturday#2 in Tampa and had the brief chance to chat with David Hayden about LINQ (I suspect I am one of the passionate DBA's he mocks a little in that post!) and it really reinforced yet again for me how wide the chasm is between DBA and… Read more

1 comments, 1,802 reads

Posted in SQLAndy on 21 February 2008

Call for Speakers for PASS Summit is Open Through March 28, 2008

The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's a great venue for SQL Server professionals and if you've been practicing at local events, maybe now is the time to try to move up to a national audience! The… Read more

0 comments, 1,421 reads

Posted in SQLAndy on 21 February 2008

New Book from Celko - Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL is available on Amazon for about $24. Here's an excerpt of the excerpt:

"Joe Celko has looked deep into the code of novice SQL programmers and found a consistent… Read more

0 comments, 1,491 reads

Posted in SQLAndy on 20 February 2008

Dry Erase Board v2

When we first set up shop for End To End Training we knew we wanted both a flip chart and a dry erase board. For the latter we did some research and many people recommended tileboard, available from the local home supply type store for about $10 for a 4'x8'… Read more

0 comments, 1,594 reads

Posted in SQLAndy on 19 February 2008

SQLSaturday #3 - Jacksonville 2008 - Registration and Call for Speakers is Open

My business partner Brian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University of North Florida in Jacksonville on May 3rd. If you want to attend, speak, or just see what's up, head to SQLSaturday.com. We're setting a goal of about… Read more

0 comments, 1,207 reads

Posted in SQLAndy on 19 February 2008

Ideas for Managing Cables

I had to run all the cables for all the machines in our classroom recently and you know how messy it is with all the various cables needed to make a PC run. Last time we used zip ties, this time we tried a product called Cable Zipper that I've… Read more

0 comments, 1,454 reads

Posted in SQLAndy on 18 February 2008

SQLSaturday #2 (Tampa 2008) Notes

Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very little went wrong that I could see and everyone was having a great time. I did my usual presentation on Beginning Transactional Replication and I think it removed the fear… Read more

0 comments, 1,400 reads

Posted in SQLAndy on 18 February 2008

Management Article Posted on SSC

I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for a great manager except working for one that is also a great leader, and perhaps nothing worse than working for a terrible manager. The tragedy of our profession is that… Read more

0 comments, 645 reads

Posted in SQLAndy on 18 February 2008

Getting Geeks (IT Pro's) To Talk at User Group Meetings

User groups have to be about more than technical content if you want to sustain them over the long term, and the best way to create that 'more' is to work on getting attendees to talk to each other. Here in Orlando we experiment with different ways of doing this… Read more

0 comments, 484 reads

Posted in SQLAndy on 14 February 2008

Should Code Camp/SQLSaturday Be Free?

Recently I posted about making sponsorship work to lay out some ideas for events that are seeking sponsors. My friend Shawn Weisfeld manages the Orlando .Net group and he posted his thoughts on sponsorship yesterday. The Code Camp Manifesto is where it all started and it definitely focuses not just… Read more

0 comments, 623 reads

Posted in SQLAndy on 13 February 2008

Speaker Eval Form, Part 2

My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've incorporated below. I know it probably needs some work on formatting! I think there is also a mix of speaker vs room specific stuff in the eval, making it more of… Read more

0 comments, 973 reads

Posted in SQLAndy on 12 February 2008

Computed Columns Published on SSC

I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level performance tuning class. It's not a technique you'll apply that often, but I think it's used less often than perhaps it should be. Hope you'll take a look… Read more

0 comments, 437 reads

Posted in SQLAndy on 12 February 2008

Making Sponsorship Work at Community Events & User Groups (My Wish List)

This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and there, it's probably worth writing down some thoughts about what events like Code Camp and SQLSaturday can do to make being a sponsor more attractive.

  • Treat me like a…

Read more

0 comments, 781 reads

Posted in SQLAndy on 11 February 2008

Next oPASS Meeting is Feb 12

For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the offices of End to End Training, 225 S Westmonte Dr Ste 2010, Altamonte Springs. We have two speakers scheduled; Dan Wolford doing a product demo of one product from… Read more

0 comments, 494 reads

Posted in SQLAndy on 11 February 2008

SQLSaturday Tampa 2008 is This Weekend (Feb 16)

The Tampa crew of Wes Dumey and Pam Shaw and many volunteers have been working on this for the past couple months and it's all about to come together. The almost final schedule is posted and it looks like attendance is going to be very good. I'll be there doing… Read more

0 comments, 556 reads

Posted in SQLAndy on 11 February 2008

Older posts