Microsoft sql training is important for technology related persons even more important is to learnabout new variation of microsft sql server . like sql 2000
training is needed if one wants to learn micosoft ms sql server 2000. for increment of income one should take all the basic classes so that he will have strong gasp about the main subject here we are giving a basic idea of new features of Microsoft sql server 2005:
T-SQL procedure; it is known as transact-SQL and is a version of sql , it is mainly used in Microsoft sql server 2005. this is useful for stores procedures.
TDS: its acronym for tabular data system which lets Microsoft sql server 2005 and Sybase /ase to communicate to each other , it was also used in the free tds system
Sql server 2005 protocol : the newest is SOAP protocol which is web service protocol, it lets users communicate to microsoft sql server 2005 even when they are not using windows environment .
Java support: Microsoft released a new JDBC driver that enables any java application to microsoft sql server 2005.
Clustering and mirroring of databases :
ms sql server 2000 supports clustered database access to multiple computer in which many computer can work simultaneously and share the whole work load for maximum efficiency.
Backup image : Microsoft sql server 2005 and ms sql server 2000 take backup image which is kind of snapshot of running computer and in case of any failures the system can be restored to previous condition with the help of backup image.
Merge replication:it is kind of synchronising service that enable Microsoft sql server 2005 and ms sql server database of clustered computers synchronise in real time to avoid inconsistencies.
Native support for .NET: Microsoft sql server 2005 supports .NET natively ,any stored procedure now can be written in .NET framework and it would work just fine
Those were some of the core features of Microsoft sql server , as time moves on we shall find new features and increased productivity by using Microsoft sql server.
