Monthly Archives: July 2011

Geeky Distractions

I saw Captain America recently and enjoyed it. I’ve been following the Marvel comics as they move to the movie screen, having seen Iron Man and Thor as well, and looking forward to The Avengers next year. My kids have enjoyed the movies as well, and it’s likely … Continue reading

Posted in Editorial | Tagged | 2 Comments

You Can Telecommute

I’ve written a number of pieces about telecommuting over the years, and while some people have had success in getting permission to work from home, many of you tell me that your current manager, and likely every manager you’ve ever … Continue reading

Posted in Editorial | Tagged | 4 Comments

When Did That Restore Finish?

I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the default trace, I was thinking msdb.dbo.restorehistory and decided to check. First I hit Books Online. It notes that the restore_date … Continue reading

Posted in Blog | Tagged , ,

Third Times a Charm – SQL Saturday #64 – Baton Rouge

We’re a week away from SQL Saturday #64 in Baton Rouge, LA. It takes place on August 6, 2011 at the Patrick Taylor at LSU again, the same location as the last two years. If you’re in the area, sign … Continue reading

Posted in Blog | Tagged , ,

Time for a ROWID?

One of the things I’ve been doing lately is looking forward to future versions of SQL Server. Not SQL 11/Denali, which has CTP 3 out now, but more towards the future. SQL 12 and beyond, and wondering how the platform can advance … Continue reading

Posted in Editorial | Tagged | 2 Comments

NewSQL Can Save the World

Michael Stonebraker, a database pioneer and researcher, recently said that Facebook’s implementation of MySQL was “a fate worse than death,” and they ought to rewrite their entire infrastructure. I think that analogy is a bit extreme. That statement also shows me … Continue reading

Posted in Editorial | Tagged

Leave Developers Alone

A computer deals with interrupts all the time. They are the mechanism by which it can simulate multi-tasking among many different programs in a modern operating system. However those interruptions have a price, and too many of them can affect … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Patches for SQL 10 and Techniques for SQL 11

A little over a week ago saw a number of patches released for SQL Server, including the much awaited Service Pack 1 for SQL Server 2008 R2. While I wouldn’t caution people to wait for SP1 any longer when a SQL … Continue reading

Posted in Editorial | Tagged

The Cost of Page Checksums

What’s the overhead for a page checksum? I’ve seen various numbers thrown out, but I thought that Paul Randal had written at one point that it was around 1-2%. I can’t find a reference, but in this post, Paul doesn’t … Continue reading

Posted in Blog | Tagged , | 1 Comment

The Market

I’ve been involved in quite a few debates about job hunting and job interviews recently with a number of people that are considering looking for other work. I’ve also seen some intense debates on the subject of how to look … Continue reading

Posted in Editorial | Tagged