Microsoft has recently released its first CTP (Community Technical Preview) of the next version of SQL Server, code-named ‘Denali’.

In this first CTP, changes have been made to the Database Engine and Integration Services. Other components remain unchanged.

The Database Engine now includes a new high availability model, named HADR. HADR makes use of Availability Groups in which a selected set of databases can fail over as a single unit. These Availability Groups contain replica’s of the databases. Three types of replica’s can be identified:

  • Primary Role: the current primary replica. Only one replica can be the primary role at a given time.
  • Secondary Role: the availability replica is up-to-date and can become a primary role. Replica’s in the secondary role can be configured for client connections and read-only access making it useful for reporting purposes.
  • Resolving role: indicates that the current state of the availability replica is uncertain or changing.

 

The CTP is available for download here.

Check back soon for more information about the new features of ‘Denali’.

Tom

Bookmark and Share