Archives: February 2008
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
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
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
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
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
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
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:
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
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…
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
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
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
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, 503 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 20 February 2008
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
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, 593 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 February 2008
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
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
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
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
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