Service Pack

SP 2 has been released recently for SQL Server 2005.
It has a greater advantage for Database Mirroring.
Database Mirroring does not require traceflag in Developer Edtion with this service pack.

SQL Server 2005 Introduction

This blog is for SQL Server 2005.

SQL Server 2005 is the latest database software released by the popular software vendor Microsoft.

SQL Server 2005 tries to cope up with major other vendors like IBM and Oracle.

SQL Server 2005 has major parts:

1. Database Engine :
2. Notification Services:
3. Service Broker:
4. Replication Services:
5. Integrations Services:
6. Analysis Services: