SQL Server 2008 patching has begun – and the PSS blog

Just over a month since SQL Server 2008 went to RTM and the first Cumulative Update (CU1) has been released. Bob Ward, a very good friend of mine, and a Principal Escalation Engineer in the SQL Server Product Support team published a detailed blog post on Friday explaining how to get it and install it.

If you’re not subscribed to the PSS blog, you should be. They post a ton of great info on how things work and how to work around bugs. Bob just blogged again today about how SQL Server 2008 Setup itself can be patched – not a trivial problem to engineer around.

Checkout the PSS blog at http://blogs.msdn.com/psssql/default.aspx.

RunAs Radio interview on indexes (and future projects…)

For the first time in ages, Kimberly sneaked in an interview without me! I was teaching a class on Database Maintenance for some Microsoft DBAs and Kimberly recorded a RunAs Radio interview on her favorite subject – indexes. I love listening to her talk about indexes – or maybe I just like the sound of her voice :-)

Check it out at http://www.runasradio.com/default.aspx?showNum=76.


PS She also drops some hints about an upcoming project of ours…

TechNet Magazine: October SQL Q&A column

It’s been almost two weeks since my last post as we’ve been offline in Scotland (another photo post to follow – I owe you two now…) but now we’re back for the crazy Fall conference and teaching season.

The latest installment of my regular Q&A column in TechNet Magazine is available at http://technet.microsoft.com/en-us/magazine/cc895648.aspx. This month I cover the following topics:

  • How backups and restores work and why the times for each may differ
  • The difference between log shipping and database mirroring around BULK_LOGGED operations
  • How other factors apart from log backups can contribute to excessively large transaction logs
  • Why database repair exists and why it shouldn’t be used
  • Tracking index usage with sys.dm_db_index_usage_stats