Microsoft  SQL Server 2008 R2

Microsoft SQL 2008 R2 is one of the Microsoft applications used for creating database apps. It is a database engine that you can implement components either separately or as a group. Server has two types of components- components for managing data and components for delivering business intelligence (BI). This release delivers an award-winning enterprise-class database platform with robust capabilities that improve efficiency through better resource utilization,

end-user empowerment, and scaling out at lower costs. Enhancements to scalability and

performance, high availability, enterprise security, enterprise manageability, data warehousing,

reporting, self-service BI, collaboration, and tight integration with Microsoft

Visual Studio 2010, Microsoft SharePoint 2010, and SQL Server PowerPivot for SharePoint

make it the best database platform available.

Some of the main application and multi-server administration enhancements that allow organizations to better manage their SQL Server environments as Ross Mistry and Stacia Misner in Microsoft SQL 2008 R2 PDF guide has mentioned  include:

■ The SQL Server Utility This is a new manageability feature used to centrally

monitor and manage database applications and SQL Server instances from a single

management interface known as a Utility Control Point (UCP). Instances of SQL Server,

data-tier applications, database files, and volumes are managed and viewed within the

SQL Server Utility.

■ The Utility Control Point (UCP) As the central reasoning point for the SQL Server

Utility, the Utility Control Point collects configuration and performance information

from managed instances of SQL Server every 15 minutes. After data has been collected

from the managed instances, the SQL Server Utility dashboard and viewpoints in SQL

Server Management Studio (SSMS) provide DBAs with a health summary of SQL Server

resources through policy evaluation and historical analysis. For more information on

the SQL Server Utility, Utility Control Points, and managing instances of SQL Server, see

Chapter 2, “Multi-Server Administration.”

■ Data-tier applications A data-tier application (DAC) is a single unit of deployment

containing all of the database’s schema, dependant objects, and deployment requirements

used by an application. A DAC can be deployed in one of two ways: it can be

authored by using the SQL Server data-tier application project in Visual Studio 2010,

or it can be created by extracting a DAC definition from an existing database with the

Extract Data-Tier Application Wizard in SSMS. Through the use of DACs, the deployment

of data applications and the collaboration between data-tier developers and

DBAs is significantly improved. For more information on authoring, deploying, and managing data-tier applications.  

And so many other features … .


  Home Solution Consulting Services  
  CaseStudy Implementation Contact Us Development  
  kcgroup Products Downloads About Us  
HyperLink Microsoft HyperLink HyperLink HyperLink Pinpoint

استفاده از مطالب سایت گروه فناوری اطلاعات کوروش برای مقاصد غیرتجاری و با ذکر نام منبع بلامانع است.
kitgroup.Ir - Copyright © 2003-2012 - All rights reserved