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

Archives: February 2008

New DBA type: Test DBA

In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA or production DBA, As for the responsibility of the two types, here is a good summary article http://www.craigsmullins.com/dbta_023.htm

However I believe now we should add another type, Test DBA, and I… Read more

0 comments, 1,860 reads

Posted in DBA Philosophy on 29 February 2008

New Benchmarks

There are new TPC-E benchmarks available for SQL Server 2008. And it's not even out!!!!

The 3rd place, the IBM entry, is the interesting one. Less CPUs and cores and getting close to the second place entry. 

I'm not sure what these benchmarks mean, especially the new TPC-E one, but… Read more

0 comments, 1,466 reads

Posted in The Voice of the DBA on 28 February 2008

Notes From My Visit with the Charlotte SQL Group

I'm headed back to Orlando after a quick trip to Charlotte. Flew in yesterday and spent some time with my friend Peter Shire and team (including Brooke!) of SQLSentry talking about all manner of stuff that comes up when you get some techies in a quiet room; business, user groups,… Read more

0 comments, 1,290 reads

Posted in SQLAndy on 28 February 2008

Using TripIt for Travel Plans

Not a SQL related topic today. 

I first noticed Tripit on Joels Blog and so far it solves a problem I've had from time to time; making sense out of all the various email messages I get when I book a trip. Their implementation is simple, just forward the email… Read more

0 comments, 1,277 reads

Posted in SQLAndy on 26 February 2008

The Launch

The launch event is tomorrow in LA and I'm not going, and find myself a little disappointed. There will be a Denver event on Mar 20 and I'm planning on going, but with kids out of school, we'll have to see how that goes with my wife.

I think it's… Read more

0 comments, 1,380 reads

Posted in The Voice of the DBA on 26 February 2008

Snapshots Part 1 Published on SSC

Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In Part 2 coming up in the next couple weeks I dig a little more into the underlying process -  not critical to know but helps dispel the black box syndrome. Read more

0 comments, 1,239 reads

Posted in SQLAndy on 26 February 2008

Perks at Work - A Good Thing?

Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone forwarded to me. But are these good things? Don't get me wrong, free is good, but there are a few things I think about when it comes to perks:

  • Are…

Read more

0 comments, 1,413 reads

Posted in SQLAndy on 25 February 2008

Lessons Learned from SQLSaturday #2 - Tampa 2008

I posted earlier about the event being a great success with more than 200 attendees, in this post I want to focus on things that went not so well because we learn more from our mistakes. Please don't think Im criticizing Team Tampa - Im not - I suspect they… Read more

0 comments, 1,472 reads

Posted in SQLAndy on 24 February 2008

The Advantages of Telecommutting

It isn't often that I see what the real advantages are, and I've been doing it so long that I almost take it for granted, but here's a look at my last 12 hours.

  • Tosing and turning in bed, sore back, alternating between chills and sweating as a fever came…

Read more

0 comments, 1,333 reads

Posted in The Voice of the DBA on 22 February 2008

LINQ Again!

I recently attended SQLSaturday#2 in Tampa and had the brief chance to chat with David Hayden about LINQ (I suspect I am one of the passionate DBA's he mocks a little in that post!) and it really reinforced yet again for me how wide the chasm is between DBA and… Read more

1 comments, 1,802 reads

Posted in SQLAndy on 21 February 2008

Call for Speakers for PASS Summit is Open Through March 28, 2008

The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's a great venue for SQL Server professionals and if you've been practicing at local events, maybe now is the time to try to move up to a national audience! The… Read more

0 comments, 1,421 reads

Posted in SQLAndy on 21 February 2008

New Book from Celko - Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL is available on Amazon for about $24. Here's an excerpt of the excerpt:

"Joe Celko has looked deep into the code of novice SQL programmers and found a consistent… Read more

0 comments, 1,491 reads

Posted in SQLAndy on 20 February 2008

Changing the Command Prompt

I spend a lot of time at the command prompt and to be perfectly honest, I'm tired of looking at:

  C:\Documents and Settings\Brian>

Or whatever directory I happen to be in. Back in the old DOS days we got rather creative with command prompts, usually through the use of… Read more

0 comments, 1,729 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 20 February 2008

Dry Erase Board v2

When we first set up shop for End To End Training we knew we wanted both a flip chart and a dry erase board. For the latter we did some research and many people recommended tileboard, available from the local home supply type store for about $10 for a 4'x8'… Read more

0 comments, 1,594 reads

Posted in SQLAndy on 19 February 2008

Errata for SQL Server Certification Books

Back in this blog post, I indicated which books I was using to complete the MCITP certifications for SQL Server. Of course, there are always mistakes found after a book goes to press. I've gone ahead and tracked down the errata pages for them (some may not be populated… Read more

0 comments, 1,716 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 February 2008

SQLSaturday #3 - Jacksonville 2008 - Registration and Call for Speakers is Open

My business partner Brian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University of North Florida in Jacksonville on May 3rd. If you want to attend, speak, or just see what's up, head to SQLSaturday.com. We're setting a goal of about… Read more

0 comments, 1,206 reads

Posted in SQLAndy on 19 February 2008

How Stable is SQL Server 2005?

I've been calling for Service Pack 3 and I've been debating the need, the criticality, and even the problems with the process. There's been an interesting debate with people both at SQLServerCentral.com, internal Microsoft people I know, and in the MVP forums. What's amazing to me is how many people… Read more

0 comments, 1,516 reads

Posted in The Voice of the DBA on 19 February 2008

A Welcome Delay

I get a bit of a delay in working on the set down in the basement thanks to the weather. It was beautiful today, nearly 60F and without much wind, so I did my semi-weekly podcast work outside, getting 4 done today that I'd previously written.

 Hopefully the wind wasn't… Read more

0 comments, 1,391 reads

Posted in The Voice of the DBA on 19 February 2008

Ideas for Managing Cables

I had to run all the cables for all the machines in our classroom recently and you know how messy it is with all the various cables needed to make a PC run. Last time we used zip ties, this time we tried a product called Cable Zipper that I've… Read more

0 comments, 1,454 reads

Posted in SQLAndy on 18 February 2008

SQLSaturday #2 (Tampa 2008) Notes

Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very little went wrong that I could see and everyone was having a great time. I did my usual presentation on Beginning Transactional Replication and I think it removed the fear… Read more

0 comments, 1,400 reads

Posted in SQLAndy on 18 February 2008

Older posts