Enhancements in SQL Server 2005 - Part I

Enhancements in SQL Server 2005 worth consideration are for the following features: Database Engine, Analysis Services, Integration Services, Full Text Search, and Replication

Database engine is the heart of SQL Server. If provides all the services for adminstering the data right from storage to backing up the data. There has been many many great improvements in the database engine.

1) The first among them is the xml datatype. There is also good support for using XQuery expressions.
2) With the integraton of CLR with the database engine, it's now possible to build database objects with the language of your choice like VB.Net or C# for example.
3) Table partioning has improved a lot which yields performance gains.
4) DDL Triggers are a new feature avaialable in SQL Server 2005. These triggers get triggered when DDL statements are executed.
5) MARS i.e. Multiple Active Result Sets allows more than one pending request per connection.
6) A completely new secuirty architecture is available which provides enhanced database protection.

In my next post, I would come out with Part II - Analysis Services, which would summarize the new improvements in Analysis Services.

Siddharth Mehta
[MSc (I.T.), MCP, MCAD, MCSD]