Home > SQL Basic > What is New in SQL Server 2005

What is New in SQL Server 2005

August 15, 2010

Last Topic we have seen what are all the SQL Server Version Released So far. already SQL Server 2000 Mainstream supports has ended and MS support 2000 SP4 and this will also gets end soon. so we will focus on the recent version SQL Server 2005 and 2008. Now i am going to Provide What is New in SQL Server 2005.

Net CLR Integration: 
   We can write User-Defined Data type,triggers,functions,Stored Procedures in any .Net Languages.
New XML data type:
   We can store xml data into an own column of xml data type.
Error Handling :
    We can write error handling using TRY-Catch.
DDL Triggers :
    This trigger will fire when the Created and alter or drop statement.
Failover Clustering:
     Failover clustering is extended to 8 nodes on 32-bit systems and 4 nodes on 64 bit systems.
Database Mirroring:
     This is a new features introduced on SQL Server 2005. using this we can configure stand-by database to database.note it has not come default with the RTM version. need to apply SP1 or later to configure mirroring. in RTM we need enable the trace flag to configure mirroring.
Multiple Active Result Sets :
     Multiple SQL statement to return result set at the same time of execution on the single connection
DTS Removed :
     No more DTS from SQL Server 2005 and later version as it has introduced SQL server Integration services.This is the Primary ETL tool with free of charge.
Dedicated administrator Connection:
     Formally called as DAC. This will help Administrator to access running instance of SQL Databases to figure out the    problems even if the SQL server is unresponsive to client.
SMTP Mails:
     SQL Server 2000 also sent mail directly however MS SQL 2005 will directly interact with SMTP.
Data Encryption:
    Data encryption is possible on user databases on MS SQL 2005.
Service Broker:
    Service Broker handles messaging between sender and receiver about coupled manner.Message can be sent a queue on the same databases and receive the message on different database on the same instance or the remote instance.


Categories: SQL Basic
%d bloggers like this: