�
�
The enhancement of �
Here, I am going to briefly discuss about these areas:
As far as a database developer is concerned, the productivity is the major factor during the development of database applications especially lack of developer experience in the integrated tool for database development and debugging.
o It allows .NET framework hosting
This interesting feature helps the software designers and developers to utilize the full functionality of .NET runtime, and the .NET Base class libraries. Now, Yukon SQL Server runs on CLR environment, which will be more secure than the traditional SQL Server stored procedure. This allows mixing the DML in Yukon and the computation intensive tasks in .NET, which solves a lot of the business problems.
Consider, for example, if you have written stored procedure which contains the string manipulation tasks, you can use the same task using .NET language and thus way you can utilize the full functionality of .NET framework and take full advantage of the faster processing of stored procedure, which enhancing the data storing and querying capabilities.
Developers can select any of the programming language such as C#, VB.NET, C++ etc. for .NET integration with
o It supports native XML language
The new XML Query feature allows the developer to build complex queries that allows retrieving data the user wants. This is based on the new XML technology, which implements the mechanism in
Document Management capability supports the developers to a great extend to query, update and indexing the XML data. It is accessible over HTTP and SOAP technologies and can be programmed just like a web service.
Note: Two newly created objects in
o Integrated Web Service is a part of
XML and Web services will play a key role in
o It has a well defined distributed application framework
A well
� SQL Service Broker
� Notification Services
� Reporting Services
As far as a database developer is concerned, the productivity is the major factor during the development of database applications.
o SQL Service Broker
SQL Service Broker is a new application framework, which provides an asynchronous processing environment using the loosely couple programming pattern and also it enhances to handle greater loads from the server.
It supports for queues and service processes. The prime function of the technology implements a message routing system, which allows sending and receiving messages. If the receiving component is busy while sending a new message, SQL Service Broker puts these messages in a queue. Also, it would handle the roll back and commit procedures based on the execution results.
o Notification Services
The new version of pre-beta release of
The inbound messages arrived on protocol pipe, which will be authenticated and dispatched to appropriate queue. The following figure 1 shows the SQL Service Broker in
Fig.1 SQL Service Broker
Note: The earlier version of SQL Server 2000 has already had functionality, which was through the Notification Services 2.0.
o Reporting Services
The following features of Reporting Services are allows developers for developing, managing and distributing reports. This server based technology for reporting allows the following features:
So, the business intelligence helps an organization for information management system in the areas of integrated platform, improved decision-making, security and availability and enterprise analytical capabilities.
SQL Server �
New Microsoft SQL Server Yukon�s enhanced security architecture helps to understand Database Administrators and Developers a well defined set of rules using server�s security framework, which includes in various areas such as password policy, user schema separation, permissions, SQL � CLR security etc.
The various levels of security principals includes windows, SQL Server and Database levels, which secures Microsoft SQL server Yukon database elements such as login, cmdpoint, certificates and event notifications.
The top ten features of
The table listed below explains these features.
|
Database Administration |
Development |
Business Intelligence |
|
1. Database Mirroring |
1. .NET Framework Hosting |
1. Analysis Services |
|
2. Online Indexing Operations |
2. XML Technologies |
2. Data Transformation Services (DTS) |
|
3. New Integrated Toolset |
3. ADO.NET 2.0 |
3. Data Mining |
|
4. Snapshot Isolation |
4. Transact-SQL Enhancements |
4. Reporting Services |
|
5. Data Partitioning |
5. SQL Service Broker |
5. Clustering Support |
|
6. Mirrored Backups |
6. Notification Services |
6. Key Performance Indicators |
|
7. Online Restore |
7. Web Services |
7. Scalability and Performance |
|
8. Fast Recovery |
8. XQuery Support |
8. One-Click Cube |
|
9. Dedicated Administrator Connection |
9. Full-Text Search Enhancements |
9. Architecture Enhancements |
|
10. Replication Enhancements |
10. Security Enhancements |
10. Integration with the Microsoft Office System |
For more information about this, visit the Microsoft web site, http://www.microsoft.com/sql/yukon/productinfo/top30features.asp.
In this article, I briefly discussed about the functionalities and features of Microsoft�s next generation information management solution called SQL Server �
| You must Sign In to use this message board. | |||||||||||
|
|||||||||||
|
|||||||||||
|
|||||||||||
