Microsoft certification path on SQL server:

Technology Specialist (TS):

Microsoft provide MCTS certificate after passing any one Exam of 70-432 for DBA or 70-433 for developer and 70-448 For BI. Here I am giving a rot map which is broadcasted by Microsoft itself on their website. To download the PDF Click here.

More: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2

IT Professional certification (Pro):

Exam 70-450 : Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008.

Exam 70-451 : Designing Database Solutions and Data Access Using Microsoft SQL Server 2008.

Exam 70-452 : Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Visit for more: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3

Advance:

MCM:

Exam 88-970: SQL Server 2008 Microsoft Certified Master: Knowledge Exam. And

Exam 88-971: SQL Server 2008 Microsoft Certified Master: Lab Exam

More: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab5

MCA:

Successfully pass the MCA Board Exam conducted by Microsoft and industry experts.

More: http://www.microsoft.com/learning/en/us/certification/architect.aspx