|
Q1: Feature #1 of 10 of SQL Server 2005 for Developers?
1) .NET Framework Hosting
With SQL Server 2005 developers will be able to create database objects using familiar languages such as Microsoft Visual C# .NET and Microsoft Visual Basic .NET. Developers will also be able to create two new objects—user-defined types and aggregates.
Q2: Feature #2 of 10 of SQL Server 2005 for Developers?
2) XML Technologies
Extensible Markup Language (XML) is an important standard for disseminating data between different applications over local networks and the Internet. SQL Server 2005 will natively support storage and query of XML documents.
Q3: Feature #3 of 10 of SQL Server 2005 for Developers?
3) ADO.NET version 2.0
From new support for SQL Types to Multiple Active Result Sets (MARS), ADO.NET in SQL Server 2005 will evolve dataset access and manipulation to achieve greater scalability and flexibility.
Q4: Feature #4 of 10 of SQL Server 2005 for Developers?
4) Security Enhancements
A new security model in SQL Server 2005 will separate users from objects, provide fine-grain access, and enable greater control of data access. Additionally, all system tables will be implemented as views, providing more control over database system objects.
Q5: Feature #5 of 10 of SQL Server 2005 for Developers?
5) Transact-SQL Enhancements
SQL Server 2005 provides new language capabilities for developing scalable database applications. These enhancements include error handling, recursive query capabilities, relational operator PIVOT, APPLY, ROW_NUMBER and other row ranking functions, and more.
Q6: Feature #6 of 10 of SQL Server 2005 for Developers?
6) SQL Service Broker
SQL Service Broker will provide a distributed, asynchronous application framework for large-scale, line-of-business applications.
Q7: Feature #7 of 10 of SQL Server 2005 for Developers?
7) Notification Services
Notification Services enables businesses to build rich notification applications that deliver personalized and timely information, such as stock market alerts, news subscriptions, package delivery alerts, and airline ticket prices, to any device. With SQL Server 2005, Notification Services is more tightly integrated with technologies such as Analysis Services and SQL Server Management Studio.
Q8: Feature #8 of 10 of SQL Server 2005 for Developers?
8) Web Services
With SQL Server 2005 developers will be able to develop Web services in the database tier, making SQL Server a Hypertext Transfer Protocol (HTTP) listener and providing a new type of data access capability for Web services-centric applications.
Q9: Feature #9 of 10 of SQL Server 2005 for Developers?
9) Reporting Services
With SQL Server 2005, Reporting Services will provide report controls that will be shipped with Visual Studio 2005. Integrated reporting controls will provide improved reporting capabilities for enterprise applications.
Q10: Feature #10 of 10 of SQL Server 2005 for Developers?
10) Full-Text Search Enhancements
SQL Server 2005 will support rich, full-text search applications. Cataloging capabilities will be enhanced to provide greater flexibility over what is cataloged. Query performance and scalability will be improved dramatically, and new management tools will provide greater insight into the full-text implementation.
|