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: July 2007

User Groups Moved to New Domain

We've just moved all the PASS chapters that were hosted on ~.ssc.com domains over to ~.sqlgroups.com. This is part of the final cleanup as we try to make sure we don't have anything left pointing at SSC. If you're the leader of one of these groups and are hosting elsewhere…

Read more

0 comments, 1,521 reads

Posted in SQLAndy on 27 July 2007

SQLSaturday in Orlando

I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event that focuses on demo's and code. Brian & I have done SQL presentations at most of them in Fl and they vary from fair to great events, all depending on…

Read more

0 comments, 1,473 reads

Posted in SQLAndy on 23 July 2007

Tampa Code Camp - Again

This turned out to be a nice event, better venue than last year. Well organized is always appreciated even at free events. Kudos to Keith & Keith at VisualGov for a first class job.

Brian, Chris, and I did our presentations on Sat and all went pretty well, we gave…

Read more

0 comments, 1,347 reads

Posted in SQLAndy on 18 July 2007

Buy a $10 Raffle Ticket to Help Katie

Not a happy story, but if you've got a child I suspect it will be easy to decide to buy a raffle ticket to try to help out. My friend Steve Jones posted the raffle over at SSC. Brian, Steve, and I (End to End Training) are doing our…

Read more

0 comments, 1,361 reads

Posted in SQLAndy on 12 July 2007

Wiki For Books Online

Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be tremendously powerful to get not just the official MS line but also the hard lessons learned that you often run across in forums and community generated articles. I haven't looked…

Read more

0 comments, 579 reads

Posted in SQLAndy on 9 July 2007

The Perils of NewID for Randomizing Results

NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its a "true" random, but usually good enough for day to day purposes. It's a decent technique and easy enough to apply, but it can be a performance killer. In the…

Read more

0 comments, 864 reads

Posted in SQLAndy on 9 July 2007

Cursors to Increase Performance?

I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In the previous iteration of tuning they had found that running a portion of the query inside a cursor actually yielded better performance than a one query takes all set based…

Read more

0 comments, 695 reads

Posted in SQLAndy on 6 July 2007

70-444 Exam Prep Book

I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks good! I wrote the SSIS chapter and it is amazing what a couple good editors can do to make it really look professional.

I've enjoyed the simpler rules and spontaneity…

Read more

0 comments, 722 reads

Posted in SQLAndy on 5 July 2007