Installation
SQL Server 2008 setup and installation have been improved. Configuration data and engine spaces separately, so it makes the system is not configured to create a basic disk image becomes possible, and it enables distribution to multiple servers becomes easier. From Microsoft's site can also find the latest updates available to install. Another feature is the ability to install SQL, SP and patches to make a single step carried out. Another of the last feature is the ability to uninstall the SP.
Key areas
When the review on the Microsoft SQL Server 2008's document notes that the first term is the classification of the characteristics and uses the characteristics of groups, or key areas. There are four key areas: enterprise data platform, dynamic development, beyond relational databases and ubiquitous vision. This article will try to keep in accordance with these categories of articles related to Microsoft simplistic.
Termination of support for SQL 2000
The mainstream of the SQL 2000 support will be terminated. Mainstream support for the features and benefits including the submission of the request to change the product characteristics, security updates, non-security patches, free support and paid support. On SQL Server 2000 64-bit version, SQL Server 2000 Developer Edition, SQL Server 2000 Enterprise Edition, SQL Server 2000 Standard Edition, SQL Server 2000 CE Edition and SQL Server 2000 version of this working group will mainstream support in April 2008 8 due. Extended support, including security updates and paid support will continue until 2013. Complete description of support in Microsoft Support Lifecycle and the Microsoft Support Lifecycle Policy FAQ found. Many agents in December 2007 sale of SQL 2000. Vista is not supported on any version of SQL 2000, including SQL 2000 Express edition.
Enterprise Data Platform
Enterprise Data Platform category usually refers to the important task of platforms, including the core SQL Server engine features, including data encryption, many benefits, resource management, system analysis and server management features.
Encryption
There are several encryption options. The first one called Transparent Data Encryption. In SQL Server 2008, the entire database can be encrypted by SQL engine. The method of data encryption for all database and database log files. By using this all-encompassing way, all the indexes and tables are encrypted. Do not change your application.
No. 2 is the backup encrypted encryption features. SQL Server 2008 encrypted backups to prevent data leakage and tampering. In addition, the backup restore feature can be limited to the user.
Finally, the external key management to have a new option. If you want to deal with credit card or follow the words of PCI treatment, SQL Server 2008 will support hardware security module (HSM). Hardware security module is independent of local data to protect the key used to store third-party hardware solutions.
Audit
In addition to login / logout and permission to change outside the standard audit, SQL Server 2008 allows monitoring of data changes or access. Audit through the TSQL statement to configure, such as the following example: AUDIT UPDATE (Salary) ON Employee TO MyAuditFolder WHERE Salary> 200000.
Data compression
Typically, data compression and conservation is always hard, smaller physical files, backup times decrease is linked. For SQL Server, data compression, the main purpose of the actual reduction in the size table. Data compression of some of the benefits include the following:
By reducing the I / O and improve cache hit ratio to improve query performance
Provide actual data on the real DW 2 times to 7 times the compression ratio
And other features are orthogonal
Data and index are available
According to Microsoft, the uses of compression, a slight increase in CPU usage, overall system performance because I / O, but much less improve.
Explorer
SQL Server 2008 in Explorer, is brand new. Manager used to restrict user or group to use high-level resources. Can be monitored include CPU bandwidth, timeout waiting for, the execution time, blocking time and idle time. If the resource manager to achieve the threshold, the system can trigger an event or stop the process. In Explorer, use of a series of steps will be introduced later article.
Posted: 2008.01.09 04:36 Source: the developer community on: Bing Yu
Hot-plug CPU
In SQL Server 2008, if a basic hardware support, at run time can add additional CPU.
Performance Data
In SQL Server 208 in the number of performance counters has been expanded compared to previous versions of the. IO and memory usage performance monitor counters can be collected only two of the entries. Counter data collected is stored in a centralized data warehouse. Microsoft claims that the monitor is running on the default properties set will consume less than 5% of the CPU and memory resources.
Now have the ability to read data stored in the performance of the performance dashboard tool. In addition, you can make history and comparison of baseline and used to create action triggers. For example, if the memory usage exceeds a certain threshold value of 5 minutes, then a more detailed data collection can be automatically triggered.
In SQL Server 2008 in Performance Studio is a new tool. The tool is a collection of performance tools. Together they can be used for monitoring, diagnosis, tuning and reporting. In which the data collector can be configured and set up cost is low. It supports several collection methods, including TSQL query, SQL trace, and performance counters. Data can also be programmed to collect. Once the collected data, there is a drill and detailed summary of the report. Microsoft lists the Performance Studio of six client characteristics:
ยท SQL Server dashboard
* Performance Monitoring
* Current and historical data analysis
* Potential performance tuning recommendations
* Based on a collection of the data collection report
* Based on the report of the MDW