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

Schedule Announced for SQLSaturday#3 in Jacksonville

Brian has just posted the schedule of sessions for SQLSaturday #3. I haven't gone through to see how many are SSC regulars, but I noticed Brandie Tarvin, Brian Kelley, and Tim Mitchell. Registration still climbing, over 170 registered so far. If you're planning to attend, tell your co-workers! One… Read more

0 comments, 1,327 reads

Posted in SQLAndy on 31 March 2008

Practices Does Make a Difference When Speaking

As I've mentioned a couple times previously I teach a free 'how to be a speaker' course, mainly to encourage those that want to speak at our local user group to take that next step. We focus on a lot of the mechanics and less on true public speaking items,… Read more

0 comments, 1,372 reads

Posted in SQLAndy on 30 March 2008

More Code Per Module = More Bugs, But More Complex Code <> More Bugs?

SDTimes has an article up about Debunking Cyclomatic Complexity that talks about the results of some research that supports what I suspect most of agree with - more lines of code per module/method leads to more bugs. Object oriented program has done a great job in leading away from procedures… Read more

0 comments, 1,491 reads

Posted in SQLAndy on 28 March 2008

More Thoughts on LINQ to SQL

At the recent Orlando Code Camp I had the opportunity to spend a good bit of time discussing LINQ to SQL with Jim Wooley, author of Linq In Action. It was really an interesting conversation. Clearly Jim likes LINQ and sees some opportunities there for developers. As we… Read more

0 comments, 1,661 reads

Posted in SQLAndy on 26 March 2008

Notes About our Raffle of the One Laptop Per Child Laptop at Orlando Code Camp

I've blogged about the OLPC project a couple times already, not as a political statement but just as a fascinating idea based on some interesting technology and a vision - which if bold - could have a long lasting impact on some of the poorest countries in the world. We… Read more

0 comments, 1,362 reads

Posted in SQLAndy on 24 March 2008

Orlando Code Code Follow Up

Although attendance was down this year (around 280 attendees) due to it being held Easter weekend, I thought this was easily the best of the Orlando Code Camps so far. More volunteers, better logistics, and definitely a great site (same as we used for SQLSaturday#1 in Orlando) all combined to… Read more

0 comments, 1,419 reads

Posted in SQLAndy on 23 March 2008

Orlando Code Camp Reminder & A Special Raffle - One Laptop Per Child

Reminder that if you're registered the Orlando Code Camp is tomorrow. If you're registered and plans have changed, please cancel your registration. There's a ton of people on the wait list hoping for a seat at this free event.

I'll be at the Code Camp speaking and representing End to… Read more

0 comments, 1,592 reads

Posted in SQLAndy on 21 March 2008

A Minor Rant About Statistics

If you've ever taken a look at the auto generated statistics that SQL builds (typically on non indexed columns when you reference the column in a where clause) you'll see that they are named _WA_Sys...blahblah. But why? A quick search didn't reveal any good answer (though perhaps I just didn't… Read more

0 comments, 1,327 reads

Posted in SQLAndy on 19 March 2008

Another Take on SP3 & Service Packs In General

Had lunch with a friend in the business yesterday that is involved with vulnerability scans for a large company and one of the things he discussed was that service packs are hard for them. On many of their servers they apply fixes of any type only if critical or fix… Read more

1 comments, 1,577 reads

Posted in SQLAndy on 18 March 2008

Utah Code Camp is April 26, 2008

Tjay Belt forwarded me the information about the Utah Code Camp this year. Still early in the process, no schedule posted yet, and the call for speakers is open if you live near by. Read more

0 comments, 1,509 reads

Posted in SQLAndy on 18 March 2008

Reminder - Orlando Code Camp is Mar 22, 2008

Just a reminder that the event is this Saturday. The tentative schedule has been posted and it looks like I'll be doing my presentation as the last one of the day (hopefully that's good). Overall not a lot of SQL content - if you don't count LINQ that is -… Read more

0 comments, 1,480 reads

Posted in SQLAndy on 17 March 2008

IndyTechFest 2008 Set for Oct 4, 2008

I've been emailing back and forth with IndyTechfest organizer John Magnabosco over the past year as we've traded notes about running community events, so when he invited me to attend as a speaker it seemed like the perfect opportunity to go see first hand how they do things. I've never… Read more

0 comments, 691 reads

Posted in SQLAndy on 16 March 2008

Browse Source Code for .Net Objects in SQL (Reflector.SQL2005Browser)

Saw a mention of this in the latest MSDN Magazine, you can download Reflector.SQL2005Browser and install it as an add-in for the well know Reflector tool (both are free). Point it at a server, pick a database, and you can browse through the deployed CLR objects. From there you can… Read more

0 comments, 774 reads

Posted in SQLAndy on 13 March 2008

Building YOUR Brand - Part 2

Yesterday I posted Building YOUR Brand that described a formula for becoming rich and famous. Well, perhaps richer than you are now anyway. It's fine to have a formula, but in practice there's more to it than having and following the formula. So in that line of thought, I've got… Read more

0 comments, 548 reads

Posted in SQLAndy on 12 March 2008

Building YOUR Brand

Between teaching classes, attending community events, and participating in the local user group I get to have a lot of interesting conversations from a diverse group of people. Diverse in the positive sense. One question I get occasionally is along the lines of 'what can I do to grow my… Read more

0 comments, 669 reads

Posted in SQLAndy on 11 March 2008

SQLSaturday #3 Jacksonville Update

Just spoke with Brian this morning to get an event update for SQLSaturday #3:

  • 122 attendees registered so far (event is set for May 3rd)
  • 20 volunteers
  • 26 sessions submitted (call for speakers open through Mar 15, Brian is looking for SQL 2008 content now)

Very good progress so… Read more

0 comments, 476 reads

Posted in SQLAndy on 11 March 2008

Presenter View in Powerpoint 2007

Friday I gave another iteration of our free Sucessful Technical Speaking class, upgraded some since the last version, and this was my first time using the Presenter View in 2007. If you haven't seen it yet here is a page about it from MS, but basically it makes it very… Read more

0 comments, 536 reads

Posted in SQLAndy on 10 March 2008

Performance Tuning Seminar in Jacksonville, FL on May 2, 2008

I'll be teaching a one day performance tuning seminar that targets beginning DBA's and developers that do data access, hoping to provide some useful insight into things that they can do immediately to address performance problems. It's on May 2, 2008 in Jacksonville and will serve as the 'pre-conference' event for the… Read more

0 comments, 762 reads

Posted in SQLAndy on 9 March 2008

Are All Meetings Bad?

I was mildly amused by my friend Steve Jones blog post Finding a Direction about not really wanting to spend a couple days in meetings. The amusement is in part because I know he's just as contrarian as I am, but really it's because we have an entire generation of… Read more

0 comments, 527 reads

Posted in SQLAndy on 6 March 2008

SQL Server Data Services Announcement (Competitor to Amazon SimpleDB)

Mary Jo Foley reports that MS is signing up testers for a hosted SQL Server solution called SQL Server Data Services that is similar to the idea of Amazon Simpledb. Jump to their FAQ for more info. One interesting note is that it offers unlimited storage, but nothing on pricing.… Read more

1 comments, 703 reads

Posted in SQLAndy on 6 March 2008

Older posts