K
Kevin Collins
At the PDC in Los Angeles, the next release of SQL Server CE (code named
Laguna) was announced.
Laguna will be integrated with the next release of SQL Server (Yukon) and
will be integrated in with the Yukon public beta that will be out in the
first half of 2004.
Key features of Laguna are:
Storage Engine:
* Multi-user support. Multiple connections and multiple applications can
access the same database at the same time with row level locking on data
pages.
* ACID transactional support
* Improved management of database size
Query Processor:
* True Show Plan to discover plans on query performance issues
* Optimization Hints to fine tune query performance
* Histogram support to choose much better query optimization plans
* Named parameters
* A true managed accessible updateable scrollable cursor model that is
bindable to all controls that the DataSet is bindable to and providing
orders of magnitude performance improvements over the DataSet
Tools Integration:
* Tight integration into Yukon SQL Workbench (the new Enterprise Manager)
that will provide creating of database on the desktop or on the device, with
full control of managing the schema and querying the database from the
desktop
* Tight integration with Whidbey (the next release of VS.NET) to allow full
data control of the database and to allow drag and drop of schema onto
controls for automatic population of the controls
* Yukon DTS support to gain access to a wide variety of data sources
* VS.NET WinForm support for creating applications on the desktop for the
restricted use of scaling testing and deployment of databases
Synchronization:
* New subscription wizard integrated into SQL Workbench to easily create
subscription databases on the desktop or on the device
* Tight integration into new Yukon merge replication features to increase
scaling performance, overall sync performance and reliability.
* Ability to put multiple subscriptions into one database
* Ability to programmatically get progress information during a sync
* Ability to do multi-user synchronization
Laguna) was announced.
Laguna will be integrated with the next release of SQL Server (Yukon) and
will be integrated in with the Yukon public beta that will be out in the
first half of 2004.
Key features of Laguna are:
Storage Engine:
* Multi-user support. Multiple connections and multiple applications can
access the same database at the same time with row level locking on data
pages.
* ACID transactional support
* Improved management of database size
Query Processor:
* True Show Plan to discover plans on query performance issues
* Optimization Hints to fine tune query performance
* Histogram support to choose much better query optimization plans
* Named parameters
* A true managed accessible updateable scrollable cursor model that is
bindable to all controls that the DataSet is bindable to and providing
orders of magnitude performance improvements over the DataSet
Tools Integration:
* Tight integration into Yukon SQL Workbench (the new Enterprise Manager)
that will provide creating of database on the desktop or on the device, with
full control of managing the schema and querying the database from the
desktop
* Tight integration with Whidbey (the next release of VS.NET) to allow full
data control of the database and to allow drag and drop of schema onto
controls for automatic population of the controls
* Yukon DTS support to gain access to a wide variety of data sources
* VS.NET WinForm support for creating applications on the desktop for the
restricted use of scaling testing and deployment of databases
Synchronization:
* New subscription wizard integrated into SQL Workbench to easily create
subscription databases on the desktop or on the device
* Tight integration into new Yukon merge replication features to increase
scaling performance, overall sync performance and reliability.
* Ability to put multiple subscriptions into one database
* Ability to programmatically get progress information during a sync
* Ability to do multi-user synchronization