The MS SQL Server 2005 was developed in the year 2005 and was released in the market in the year of 2006 November under the code name Yukon. This the version identified as the 9.0 version where more features and database capabilities are expected to be incorporated on this newer version.  This is the successor of the MS SQL Server 2000.

The MS SQL Server 2005 has the massive support for the efficient management of the Extensible Markup Language data apart from the traditional support given to the relational data.  XML data is a data that is represented being either a type of data in the database matrix or as literal data in the queries box.  

When an XML data is stored or deposited it is being tested and verified against a set of schematic data to ensure the integrity of the data that is being stored.  Further, to make sure that rigid testing is being done, the XML data that is going to be stored shall be converted into a binary type of data prior to it being stored on the database.  

The MS SQL Server 2005 has embedded some database file extensions to the T-SQL engine to allow for further embedding any XQuery inquiries in the T-SQL.  Moreover, the MS SQL Server 2005 clearly identified new file extensions named as XML and DML which will permit modifications on the query based on the XML data.  

The MS SQL Server 2005 or the Yukon adapted to the SL CLR technology to allow for the integration of the NET structure on it making Yukon incomparably powerful and robust.  

Categories: News