TechNet Magazine: May 2010 SQL Q&A column

The May edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column.

This month's topics are:

  • How to change the file locations for a user database
  • The difference between page latches and page I/O latches
  • Why database snapshots are not a good substitute for transaction log backups
  • Why I/O subsystem-caused corruption does not propagate to a database mirror

Check it out at http://technet.microsoft.com/en-us/magazine/ff679223.aspx.

2 thoughts on “TechNet Magazine: May 2010 SQL Q&A column

  1. Paul,

    I think there is a mistake in this article…"As I mentioned, if page checksums are enabled, such corruption would remain undetected when the page is read from disk, and the second-order corruption would not occur."

    should probably read:

    As I mentioned, if page checksums are enabled, such corruption would *be detected* when the page is read from disk, and the second-order corruption would not occur."

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.