New Features in SQL Server 2005

Microsoft SQL Server 2005 is a comprehensive, integrated data management and analysis software that enables organizations to reliably manage mission-critical information and confidently run today’s increasingly complex business applications. SQL Server 2005 allows companies to gain greater insight from their business information and achieve faster results for a competitive advantage.

Those description is given by Microsoft as the overview of SQL Server 2005 in their official website. Although it’s already launched, it’s still interesting to discussed the main a features of this product which distinguished it with their competitors in the market.

By: Adam Sturo

1. Reporting services : In SQL Server Reporting Services increase there benefit to customers. These include centralized report storage and management, control over how reports are processed or administered, and also have ability to fastest changing reports formats (HTML, Excel, PDF, etc.). This entire capabilities make reporting Services is valuable. So Web-based reporting has ability to make up-to-date information available to a distributed group of users. Reporting Services provides a impressive way to find and view reports, the Reporting Services interface may not be the most appropriate one for all report users.
2. Partitioned Tables and Indexes : Sql Server 2005 has ability to partition tables and indexes have always been a design to improve performance and manageability in larger databases. Microsoft SQL Server 2005 has many new features that simplify the design of using this feature.
3. Xml Web services : SQL Server 2005 provides a standard method for getting the database engine by using SOAP via HTTP. With the help of this methods, we can send SOAP/HTTP requests to SQL Server to execute stored procedures, extended stored procedures, T-SQL batch statements and scalar-valued user-defined functions which can have with or without parameters .When we use SQL Server as a Web Service that can for HTTP SOAP requests requires must create an HTTP endpoint and defining the methods that the endpoint exposes. When we create HTTP endpoint, that endpoint must be created with a unique URL that we uses to listen for incoming HTTP requests.
4. Database Mirroring : Database mirroring provides solution to provide high availability at the database level where all things depends upon the database. In Sql Server we can maintained synchronized copies of a database on two separate servers allows switching between them. And its plays its role on failure of primary server.
5. CLR Integration : Microsoft SQL Server 2005 has adopt the database programming model hosting by the Microsoft .NET Framework 2.0 Common Language Runtime (CLR). .Net CLR hosted inside SQL Server to improve performance, security and reliability. This helps developers to write procedures, triggers, and functions in any of the CLR languages.

To know more about Sql Server Interview Questions visit dotnetquestion.info and learn all interview questions related to sql server which is very helpful in interviews for you.