With this release Microsoft have introduced the following enhancements:
Simplified and streamlined customer configuration and deployment
Lower cost of operation due to improved health model and reduced false alarms
Meets low-privilege constraints needed for financial and medical industries
New rules, monitors, and knowledge improvements
DMO-less deployment
SxS install with the old SQL 2000 management pack for customers with SQL 2K
For more information and [...]
SQL Server 2008 R2 Express is now available for download from the SQL Server Express site.More importantly SQL Server 2008 R2 Express now supports 10 GB of storage per database.
A new software developer kit (SDK) helps PHP developers work get new business intelligence capabilities with a free SQL Server Reporting Services SDK for PHP.
The library is designed to make simple for developers to call the SSRS remote APIs to perform the following operations:
Query for the list of reports available on the server
Query for the [...]
• Use views and stored procedures instead of heavy-duty queries.
This can reduce network traffic, because your client will send to
server only stored procedure or view name (perhaps with some
parameters) instead of large heavy-duty queries text. This can be used
to facilitate permission management also, because you can restrict
user access to table columns they should not see.
• [...]
You can use all .Net Framework Regular Expressions via MS Server CLR Integration. Microsoft recommends to use CLR Integration in scenarios where CLR-based programming can complement the expressive power of the T-SQL query language.This includes situations such as:
Performing complex calculations on a per-row basis over values stored in database tables.
Using procedural logic to evaluate [...]
1. Intellisense in the SQL Server Management Studio (SSMS). This has been previously possible in SQL Server 2000 and 2005 with use of 3rd party add-ins like SQL Prompt .
In 2008 Intellisense feature is inbuilt
2.Resource governor. Basically it allows the DBA to specify how much resources (e.g. CPU/RAM) each user is entitled to.
3.Filtered Indexes. [...]
