Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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!

http://www.sqlsaturday.com/register.aspx

Read more

0 comments, 473 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, 493 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, 540 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, 488 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, 520 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, 539 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, 472 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, 498 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, 499 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, 494 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, 480 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, 524 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, 512 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, 586 reads

Posted in The Voice of the DBA on 11 August 2007

Engagement

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, 482 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, 501 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, 475 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, 560 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, 531 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, 536 reads

Posted in The Voice of the DBA on 7 August 2007

Older posts