How can SQL Server 2005 help me evaluate and manage indexes?

The Microsoft SQL Server Advisory Team has a good article on indexes:

http://blogs.msdn.com/sqlcat/archive/2005/12/12/502735.aspx

They include very useful performance tuning queries. SQL Server 2005 has what they call DMV (Dynamic Management Views) that lets you do diagnostics and tuning. This was not available in SQL 2000. This article answers the following questions:

(1) How can I find out whether my indexes are useful? How are they used?
(2) Do I have any tables or indexes that are not used (or rarely)
(3) What is the cost of index maintenance vs. its benefit?
(4) Do I have hot spots & index contention?
(5) Could I benefit from more (or less) indexes?

Worth a bookmark.

SQL Server 2005 System Views Map

Download the SQL Server 2005 System Views here.

Use it to get familiar with internal workings of SQL Server 2005.

Found this from SQL-Server-Performance.com.

Free calls US and International

NetZero Voice-over-Internet Protocol (VoIP) Service for Dial-Up and Broadband lets you call Anyone, Anywhere in the world, Anytime for Free.

Setup an account with Netzero and you can make calls in the US and Canada for free. They also give you a local US number. So international users can call you for free. i.e. PC to Phone!

Thanks to my friend Sabir for this link.

First Blog

This is my first blog. I actually created another blog at blog.com but their servers seemed to be too slow. Hopefully blogger is faster.
So what will I be writing about...hmm....well, mostly SQL, Business Intelligence, and of course just random thoughts.