Freigeben über


Масса полезного о SQL Server 2008 (Katmai)

Сегодня утром в RSS фиде наших зарубежных коллег наткнулся на крайне полезный пост. Позволю многое из него процетировать и в нашем блоге, но уже на русском

David выделяет следующие ОЧЕНЬ важные нововведения в SQL Server 2008:

  1. Enhanced Security – Easily encrypt the entire database, data files, or log files, without the need for application changes. Also, integrate key management with other 3rd party key management and HSM solutions for additional security and compliance.
  2. Hot Add CPU – You can now add one or more CPUs on the fly. You can still hot add memory like you could in SQL 2005.
  3. Database Mirroring improvements – clients can add database mirroring without requiring application changes, database mirroring implementations enable automatic recovery of the corrupted pages from the mirror database (in the event of a hardware failure), transparent to the end user or application
  4. Enhanced Reporting – new enterprise reporting engine is more scalable, easier to create and share reports internally and over the internet, has the ability to manage multiple reporting servers and infrastructure, and has integration with Office 2007
  5. Policy Based Management – Policies for database operations such as query optimizations, naming conventions, backup and restore operations, and index management will automatically be enforced and monitored and will enable users to publish these policies to thousands of servers
  6. Data Compression – Automatically shrinks data warehouse fact tables while improving performance, also decreases database backup times and storage space required.

Чтобы начать свое знакомство с SQL Server 2008 нужно :

  1. Зарегистрироваться здесь.
  2. Скачать SQL Server 2008 June CTP здесь.

Полезные ресурсы :

Технически й документ : Обзор SQL 2008

Веб-трансляции:

TechNet Webcast: SQL Server Code Name "Katmai" Overview (Level 100)

TechEd SQL Server 2008 Webcast – SQL Overview (DAT201)

Презентации с TechEd: