Other SQL Server Blogs around the Web

Browse by Tags

• Backup/Restore
• Bad Advice
• compression
• Conferences
• Database Maintenance
• database mirroring
• disaster recovery
• DMF
• encryption
• Example Scripts
• Interviews
• Page Checksums
• performance
• replication
• SQL Server 2008
• tools

• How hard is it to pick the right non-clustered indexes?

  Kimberly and I were presenting at our local (Redmond) .Net Developers Association on Monday and the following question came up while Kimberly was talking about missing and extra indexes (paraphrasing): What's the best non-clustered index to use for... Posted May 14 2008, 05:13 PM by SSQA.net Filed under: performance, Indexes From Every Angle, Bad Advice

• Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?

  While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and... Posted Dec 12 2007, 12:07 PM by SSQA.net Filed under: performance, database mirroring, replication, tools, disaster recovery, encryption, SQL Server 2008, compression, Indexes From Every Angle, Database Maintenance, Interviews, Backup/Restore, Conferences, DMF, Page Checksums

• Auto-shrink – turn it OFF!

  I’m in the middle of a flight from Washington D.C. to Zurich on the way to Barcelona for TechEd IT Forum and I can’t sleep – Kimberly’s out like a light so what else is there to do except write another blog post? :-) OK - actually posting this from Barcelona... Posted Nov 12 2007, 10:28 PM by SSQA.net Filed under: performance, Indexes From Every Angle, Database Maintenance

• Indexes From Every Angle: How can you tell if an index is being used?

  (This is an updated repost from earlier this year on my old blog) Whenever I’m discussing index maintenance, and specifically fragmentation, I always make a point of saying ‘Make sure the index is being used before doing anything about fragmentation’... Posted Oct 04 2007, 08:39 PM by SSQA.net Filed under: performance, Indexes From Every Angle, Example Scripts