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

The Pain of Multi-Threading!

Alas, this isn’t really a SQL post, but thoughts on efforts to share work that has been previously done by one person! For the past two years I’ve handled almost all of the work leading up to SQLSaturday Orlando, bringing in volunteers close to the event to help with logistics.… Read more

2 comments, 1,428 reads

Posted in SQLAndy on 31 August 2009

Notes On the Jacksonville Code Camp

I drove up to Jacksonville Friday afternoon for the 2009 Jacksonville Code Camp led by my friend Bayer White. I left early enough to beat the Fri afternoon traffic and to give me some quality book store time before the 7:30 pm speaker party. Attendance at the party was… Read more

1 comments, 1,635 reads

Posted in SQLAndy on 31 August 2009

Baking Cheesecake

Last Friday I discussed baking multiple batches of blueberry muffins so I thought I’d follow up with another baking post. Before we get to the cake of the story though, it’s interesting to think about why I like baking more than cooking at this point in my culinary evolution. Baking… Read more

2 comments, 583 reads

Posted in SQLAndy on 27 August 2009

SQLSaturday #21 Event Update

Thought I’d share some of the event for those you not in the Orlando area. As of today we have 57 sessions submitted by 37 different speakers. Of the 37, two are Microsoft employees and at least are MVP’s. The one area where I wish were doing better is true… Read more

0 comments, 510 reads

Posted in SQLAndy on 27 August 2009

Work Habits

I enjoy woodworking as a hobby and as I try new things I find that my work habits during the learning stage tend towards chaotic and I wind up with stuff every where. Part of that is just enthusiasm, wanting to move ahead and do stuff, part of it… Read more

5 comments, 1,565 reads

Posted in SQLAndy on 26 August 2009

PASS Call for Nominations

The call for nominations for the PASS Board of Directors is open until Sep 3rd and I want to reiterate my own call for the best and brightest of you to consider submitting your name for consideration. We’ve had a good bit of blogging about it so far:

  • Tom Larock…

Read more

1 comments, 1,277 reads

Posted in SQLAndy on 26 August 2009

PASS Connector Editorial for August 26, 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.

In a previous editorial I wrote about networking with a… Read more

1 comments, 530 reads

Posted in SQLAndy on 25 August 2009

Featured Blogger: Alexander Kuznetsov

I’ve been reading his blog for a while and getting consistently good value. I’d categorize it as a SQL blog with an emphasis on TSQL, and Alex always seems to find interesting exceptions that it’s good to know about. He also earns extra points for having a solution (a good… Read more

1 comments, 683 reads

Posted in SQLAndy on 25 August 2009

Kalen Delaney Joins The SQLSaturday Advisory Council

Last but certainly not least we’ve just announced Kalen Delaney as a member of the Advisory Council. Now that we have our four members selected we’ll start sharing with them our ideas and goals for the next year to see what looks good and what doesn’t! Read more

4 comments, 564 reads

Posted in SQLAndy on 25 August 2009

PASS Update #13

It’s been a busy few weeks since update #12. We announced guidelines for submitting content to sqlpass.org, an effort that will be managed by Grant Fritchey. I’m looking forward to seeing some new technical content on the site and growing some new authors. Grant tells me he’s already received a… Read more

3 comments, 731 reads

Posted in SQLAndy on 23 August 2009

Costco & Blueberry Muffins

You’ve probably heard of Costco, one of those warehouse type stores that sells stuff in bulk. We buy stuff there for the office and have used it for stuff at home too. Good prices on most items if you can use the medium to large size quantities they typically… Read more

3 comments, 559 reads

Posted in SQLAndy on 20 August 2009

Partitioning Strangeness

Ran across this in a recent class while covering partitioning. Start by creating a standard partitioning function and the scheme, these intended for demo against the Person.Contact table in Adventureworks:


TO ([primary],…

Read more

0 comments, 2,450 reads

Posted in SQLAndy on 19 August 2009

Looking for SQL Speakers Near Wheeling, WV

I had a great call with John Sterrett last week about the possibility of having a SQLSaturday in Wheeling and it looks like the main concern is finding speakers that live within a reasonable driving distance. I love the idea of bringing training events to smaller cities (we’re looking at… Read more

15 comments, 914 reads

Posted in SQLAndy on 19 August 2009

Buck Woody Joins SQLSaturday Advisory Council

Just announced at http://blog.sqlsaturday.com/2009/08/sqlsaturday-advisory-council-newest.html, Buck makes three – one more to go coming up soon! Read more

1 comments, 540 reads

Posted in SQLAndy on 19 August 2009

Four Kinds of Free – Some Comments

I’ve had this link about four kinds of free (and this link too) on my list for awhile, today seems like a good to write about it. It’s a post by Chris Anderson, author of The Long Tail, and it defines four kinds of free; buy something get something free,… Read more

0 comments, 652 reads

Posted in SQLAndy on 18 August 2009

Swiss SQLSaturday

Jack Corbett sent me an email this morning about the Swiss SQLSaturday, very cool! They did a great job on the graphics. First time we’ve had one outside the US and while I wish they had used the main SQLSaturday site, it’s delivering events to the community that matters.… Read more

7 comments, 737 reads

Posted in SQLAndy on 18 August 2009

How Much Should You Post Online About Your Life?

I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss networking at community events, and it’s worth some thought. I start by assuming that any potential employer/client/customer that deals with me directly is going to search for me on the… Read more

11 comments, 1,246 reads

Posted in SQLAndy on 17 August 2009

How to Add a Pre-Con/Post-Con Session to your PASS Summit Registration

Not obvious how to do this, go to http://www.regonline.com/Checkin.asp?EventId=685107, login, then click on Agenda. You can then add any of the great pre/post conference sessions we have going this year, including my entirely bias favorite, the one on networking! Read more

0 comments, 753 reads

Posted in SQLAndy on 17 August 2009

SQLSaturday Advisory Council – Second Member Announced

Posted today, Andy Leonard is the second person on the Council, and we’re glad to have him. Read the announcement and later this week we’ll announce #3. I’d challenge you to guess but I don’t have a prize ready if someone does guess, so just hang in there a day… Read more

3 comments, 630 reads

Posted in SQLAndy on 17 August 2009

Kevin Kline Joins the SQLSaturday Advisory Council

The official announcement was just posted, Kevin Kline is the first member of the Advisory Council. As I mentioned on Wednesday (and hoped to post yesterday) it was a challenge to pick a few people out of a pool of a lot of good people, but Kevin brings a ton… Read more

2 comments, 1,013 reads

Posted in SQLAndy on 14 August 2009

Older posts