SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: August 2007

Registration is Open for SQLSaturday Orlando

It's taken a while to get here, but we're finally accepting registrations for the event. This link will take you direct to the page!


Read more

0 comments, 1,251 reads

Posted in SQLAndy on 31 August 2007

The End of an Era

I went and cleaned out the Central Publishing Group colocation cage at Viawest. We've been there for 3 years and now we are finally moving out. Half the life of the company was spent there and 5/6 of our life was on the one Dell 2650 that I just unloaded…

Read more

0 comments, 1,320 reads

Posted in The Voice of the DBA on 30 August 2007

Blogging on Blogs & Professional Development

Steve posted an interesting editorial on blogs at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=393904 and the follow up discussion was pretty interesting. Read that if you have time, but the short story was he recommended that you separate personal/professional blogs. Easy enough to understand why, but that really leads to a larger discussion of when/why…

Read more

0 comments, 1,434 reads

Posted in SQLAndy on 30 August 2007

Getting Random Results Posted on SSC

I previously blogged about using newid() to get random ordering and after chatting with Steve about it, decided to write about it a little more detail for two reasons. One is that sites like SSC thrive by increasing their surface area and it's always good to have an article that…

Read more

0 comments, 1,249 reads

Posted in SQLAndy on 30 August 2007

The Blogging Debate

It's an interesting debate on blogging in response to my editorial. I definitely thing blogging is worth a try. You might really enjoy it. If not, you've tried it.

If you do a professional blog, keep it focused on your career and technical stuff you do. Don't put in…

Read more

0 comments, 1,379 reads

Posted in The Voice of the DBA on 28 August 2007

SQLSaturday Schedule Announced

Our one day free SQL Server event is slowly gaining momentum! Draft schedule is at http://www.sqlsaturday.com/schedule.aspx. 30 sessions total and a great list of speakers. If you're near Orlando on Nov 10th hope you'll plan to attend.

Mike AntonovichUsing CASE in TSQL
Joe HealyADO.NET Synchronization Services in…

Read more

0 comments, 1,482 reads

Posted in SQLAndy on 27 August 2007

Comments on the 2007 Jacksonville Code Camp

I attended for the morning and Brian attended in the afternoon and did a session as well. It was interesting to compare it to the Orlando and Tampa events that we've been to recently. I think Orlando was the most well run in terms of most of the details. Orlando…

Read more

0 comments, 1,227 reads

Posted in SQLAndy on 27 August 2007

Getting Close

Actually we had a long meeting with the developers this morning and PMs over a remote desktop session and I was able to show the specific points that were a problem. After some changes yesterday and some testing last night, I had a number of issues, but two main showstoppers.…

Read more

0 comments, 1,298 reads

Posted in The Voice of the DBA on 24 August 2007

Do You See What I See?

Working with developers is always very interesting, especially when you are a client. I'm sure that I'm not the best client, being a technical person myself, and arguing about architecture at times. However it's a good experience to see exactly where I went wrong with the design and specification of…

Read more

0 comments, 1,319 reads

Posted in The Voice of the DBA on 21 August 2007

SQLSaturday Update

We went for a site visit Tues and I think it will really work out well for us. Good parking, easy to find, and brand new building so all is clean and shiny. Everyone has pretty much the same formula for these events; welcome and keynote, sessions, lunch, sessions, closing…

Read more

0 comments, 1,303 reads

Posted in SQLAndy on 17 August 2007

Replication Book Review/Intereview Posted on SSC

Book reviews aren't easy and it's always hard to tell if you're telling the reader anything they can't learn from Amazon. The comments on Amazon have to be taken with a grain of salt, as should my review of course. We're in the age of multi author books where multi-author…

Read more

0 comments, 1,251 reads

Posted in SQLAndy on 17 August 2007

The Beta Cycle

I live in Denver. That's in the Mountain time zone, either MDT or MST depending on the time of year, and basically it's GMT -7.

The new version of the SQLServerCentral.com site is being built (hopefully as we speak), but for the most things go like this.

1. Get a…

Read more

0 comments, 1,333 reads

Posted in The Voice of the DBA on 14 August 2007

The Performance Game

I've posted in the forums fairly often that there's kind of a black art to performance tuning. As with most things, some people agree, some disagree, some don't care, and some don't know.

I stand by what I said for the most part, even though Andy teaches a Performance Tuning…

Read more

0 comments, 1,338 reads

Posted in The Voice of the DBA on 14 August 2007

Queueing Theory

There has been tons of work over the last few decades on queueing theory, mainly in regard to operating systems and scheduling, but more and more with business intelligence systems, it's being applied to other fields to increase efficiency. Supply chains, inventory management, product placement (physical), etc., all can benefit.

Read more

0 comments, 1,559 reads

Posted in The Voice of the DBA on 11 August 2007


I got a note from someone at Red Gate about disengagement with the newsletter and site. Actually it was my boss, not really someone, and he had some trends that bothered him regarding less and less referrals from the newsletter to the site. It appeared that even though traffic was…

Read more

0 comments, 1,308 reads

Posted in The Voice of the DBA on 9 August 2007

Table Partioning Article Posted on SSC

Article is at http://www.sqlservercentral.com/columnists/awarren/3135.asp. I'll have quite a few more on this subject over the next few months. As I mentioned in my recent article on Professional Development Plans partitions have been my recent focus and there is no better way to see if I have absorbed most of…

Read more

0 comments, 1,264 reads

Posted in SQLAndy on 9 August 2007

Fewer Seats Make for Better User Group Meetings?

We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of feedback was because we had filled every seat the visitor felt it made for a better experience because people talked more to each other - due to sheer proximity, where…

Read more

0 comments, 1,235 reads

Posted in SQLAndy on 9 August 2007

User Groups, Geeks, and Puzzles

Last night we had one of bi-monthly meetings of oPASS (Orlando SQL Servers User Group) and we had a pretty good time, ranging from some nice raffle prizes to a good presenation on XML to our now standard puzzle event. There's nothing quite like a puzzle in any form to…

Read more

0 comments, 1,342 reads

Posted in SQLAndy on 8 August 2007

Dell Laptops, D-Link routers and Cisco VPN

It's not directly SQL Server, but it does prevent me from working with SQL Server :)

So I'm in Virginia this week, traveling to my Mom's house with the kids (all three of them, Yikes!!) so they can see Grandma. It's been a good trip, the little ones argueing about…

Read more

0 comments, 1,534 reads

Posted in The Voice of the DBA on 8 August 2007

Am I a Good Customer?

Maybe not. This is a great post and cartoon from David Reed (a friend) mentioning me.

We've had some good arguements in email about my "don't upgrade" advice. I still stand by the advice, though I think that I rather in-eloquently and improperly stated my arguement. And to…

Read more

0 comments, 1,483 reads

Posted in The Voice of the DBA on 7 August 2007

Older posts