Monthly Archives: July 2011

Geeky Distractions

Posted on July 29, 2011 by

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

Posted on July 28, 2011 by

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?

Posted on July 28, 2011 by

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

Posted on July 27, 2011 by

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?

Posted on July 27, 2011 by

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

Posted on July 26, 2011 by

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

Posted on July 25, 2011 by

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

Posted on July 25, 2011 by

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

Posted on July 25, 2011 by

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

Posted on July 22, 2011 by

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