TechNet Magazine: September 2011 SQL Q&A column

The September 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:

  • Online index operations logging changes in SQL Server 2008
  • Is that transaction contained in my full backup?
  • ALTER INDEX … REBUILD vs. ALTER INDEX … REGORGANIZE
  • Avoiding regular log file shrinking

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

TechNet Magazine: July 2011 SQL Q&A column

The July 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:

  • Deferred log truncation from concurrent data and log backups
  • Database mirroring monitoring
  • Multiple transaction log files
  • Best use of SSDs in a SQL environment (high-level)

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

TechNet Magazine: May 2011 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:

  • Tempdb space analysis and tracking
  • The four qualities of a good clustered index key
  • Convincing management of the need for DR planning
  • Considering data compression for OLTP workloads

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