SQL Geeks Indonesia

Feature

Description

Database Mirroring

Extend log shipping capabilities with the new database mirroring solution. Database mirroring can be used to enhance the availability of SQL Server systems by setting up automatic failover to a standby server.

Online Restore

With SQL Server 2005, database administrators will be able to perform a restore operation while an instance of SQL Server is running. Online restore improves the availability of SQL Server because only the data being restored is unavailable; the rest of the database remains online and available.

Online Indexing Operations

The online index option will allow concurrent modifications (updates, deletes, and inserts) to the underlying table or clustered index data and any associated indexes during index data definition language (DDL) execution. For example, while a clustered index is being rebuilt, administrators can continue to make updates to the underlying data and perform queries against the data.

Fast Recovery

A new faster recovery option will improve availability of SQL Server databases. Administrators will be able to reconnect to a recovering database after the transaction log has been rolled forward.

Security Enhancements

SQL Server 2005 includes security enhancements such as database encryption, secure default settings, password policy enforcement, fine grained permissions control, and an enhanced security model,

New SQL Server Management Studio

SQL Server 2005 will introduce SQL Server Management Studio, a new integrated suite of management tools. This toolset will include new functionality to develop, deploy, and troubleshoot SQL Server databases, as well as enhancements to previous functionality.

Dedicated Administrator Connection

SQL Server 2005 will introduce a dedicated administrator connection that administrators can use to access a running server even if the server is locked or otherwise unavailable. This capability will enable administrators to troubleshoot problems on a server by executing diagnostic functions or Transact-SQL statements.

Snapshot Isolation

A new Snapshot Isolation (SI) level will be provided at the database level. With SI, users will be able to access the last committed row using a transitionally consistent view of the database. This capability will provide greater scalability.

Data Partitioning

Data partitioning is enhanced with native table and index partitioning that enables efficient manageability of large tables and indexes.

Replication Enhancements

For distributed mobile databases, SQL Server 2005 provides new peer-to-peer replication capabilities, including the ability to publish Oracle databases. SQL Server 2005 will also include new enhancements to the tools and scalability of replication.

Feature

Description

.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.

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.

ADO.NET Version 2.0

From new support for SQL Types to Multiple Active Result Sets, ADO.NET in SQL Server 2005 will evolve dataset access and manipulation to achieve greater scalability and flexibility

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.

Transact-SQL Enhancements

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.

SQL Service Broker

SQL Service Broker will provide a distributed, asynchronous application framework for large-scale line-of-business applications.

Notification Services

Notification Services enables business 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.  Notification Services will take advantage of new technologies and features in SQL Server 2005.

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 which will provide a new type of data access capability for Web services-centric applications.

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.

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.

Feature

Description

Analysis Services

With SQL Server 2005, Analysis Services moves into the realm of real- time analytics. From scalability enhancements to deep integration with Microsoft Office, SQL Server 2005 will help extend business intelligence to every level of the business.

Integration Services

Integration Services, formerly known as DTS, is a set of graphical tools and programmable objects that can be used to extract, transform, and load (ETL) data from disparate sources and move it to a single or multiple destinations. SQL Server 2005 will introduce a complete redesign of Integration Services that provides a comprehensive ETL platform.

Data Mining

Four new data mining algorithms will be introduced, as well as improved tools and wizards that will make data mining easier for businesses of any size.

Reporting Services

With SQL Server 2005, Reporting Services will provide self service, end-user ad hoc report creation, enhanced query development for OLAP environments and enhancements in scale allowing for rich and easy to maintain enterprise reporting environments.

Clustering Support

Analysis Services improves availability with support for failover clustering, enhanced multi-instance support, and support for backing up and restoring Analysis Services objects and data. 

Key Performance Indicators

Key performance indicators (KPIs) provide businesses with the capability to define graphic, customizable business metrics to help generate and track key corporate benchmarks.

Scalability and Performance

Features such as parallel partition processing, creation of remote relational online analytical processing (ROLAP) or hybrid online analytical processing (HOLAP) partitions, distributed partitioned cubes, persisted calculations, and proactive caching will greatly improve the scalability and performance of Analysis Services in SQL Server 2005

One-Click Cube

When creating a cube in a data warehouse project, the Cube Wizard will include an option to enable one-click-cube detection and suggestions. This option will examine the relationships in a data source view and make suggestions for fact tables, dimension tables, and measures.

Proactive Caching

Proactive Caching combines MOLAP class query performance with Real-Time data analysis and eliminates the need to maintain OLAP stores. The Proactive Cache transparently synchronizes and maintains an updated copy of the data organized specifically for high speed querying and for isolating end-users from overloading the back-end relational databases. The structure of the cache is automatically derived from the Universal Data Model (UDM) structure and can be finely tuned to balance performance with latency of data.

Integration with the Microsoft Office System

Reports that are served up by the report server can run in the context of Microsoft SharePoint Portal Server and Microsoft Office applications such as Word and Excel. SharePoint can be used to subscribe to reports, create new versions of reports, and distribute reports. Reports can also be opened with Word or Excel, or viewed in HTML.
 
SQL Server and Analysis Services users can define reports that are based on queries against relational databases and multidimensional data. Queries defined in Query Builder can be processed by using the built-in data processing capabilities of a report server.