sqlskills-logo-2015-white.png

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.

Check It Out!

SQL Server Jumpstart+ Bundle

SQL Server Jumpstart+ Bundle

Original price was: $4,070.00.Current price is: $999.00.

View Course

Posted Under:

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."

    Reply

Leave a Reply

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

Other articles

Summer Sale: $699 Blackbelt Bundle!

Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: Check It Out! SQLskills Complete Short Course Bundle $4,575.00 Original

Explore

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.

Collaborate With Us
Choose a Course