FW: SQL Server Denali
Here is some highlight of the new Denali release for SQL Server, that I thought
worth sharing.
Number 5 is interesting because of the Oracle interface !!!
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
The next release of Microsoft SQL Server, code-named Denali, is right around the
corner. Microsoft has just released Denali CTP3, and the final release is
expected by the end of the year. Denali continues SQL Server’s climb into the
enterprise with a number of important features. Here are the top 10 most
significant new features in the SQL Server Denali release.
-
SQL Server Developer Tools—One of the most obvious improvements in SQL
Server Denali is the new development environment, SQL Server Developer Tools,
coded-named Juneau. Juneau uses the Windows Presentation Foundation
(WPF)–based Visual Studio 2010 shell, and it unifies development for
Business Intelligence Development Studio (BIDS) and Visual Studio. One goal for
Juneau is to make the development environment consistent for both SQL Azure and
the on-premises version of SQL Server. -
Contained databases—Contained databases make it easy to move databases
between different instances of SQL Server. With Denali, login credentials are
included with contained databases. Users don’t need logins for the SQL Server
instance because all authentications are handled by the contained database.
Contained databases have no configuration dependencies on the instance of SQL
Server that they’re hosted on and can be moved between on-premises SQL Server
instances and SQL Azure. -
Project “Crescent”—The new data visualization tool,
code-named Project “Crescent,” is Closely integrated with SharePoint
2010 and Silverlight. Microsoft has called the Crescent feature “PowerPoint
for your data.” Crescent makes it easy for users to create great-looking
data pages and dashboards by using data models that are built using PowerPivot
or from tabular data from SQL Server Analysis Services. -
Data Quality Services—Valid data is critical for making effective
business intelligence (BI) decisions. Data Quality Services lets you set up a
knowledge base that defines your metadata rules. You can then run Data Quality
Services projects to apply those rules to data stored in a SQL Server data
source. The Data Quality Services projects cleanse the data and allow viewing of
good, invalid, and corrected rows. -
User-defined server roles—An important security-related feature in
Denali is the addition of user-defined severs roles. Earlier releases had fixed
server roles that were predefined by Microsoft. These roles covered most
situations, but they weren’t as flexible or granular as some organizations
wanted. The new user-defined server roles give organizations more control and
customization ability over SQL Server’s server roles. -
Change data capture (CDC) for Oracle— CDC lets you keep large tables in
sync by initially moving a snapshot to a target server, then moving just the
captured changes between the databases. With the SQL Server 2008 release, CDC
was limited to SQL Server, but many organizations also have other database
platforms they want to use CDC with. A big improvement in the Denali release is
the addition of CDC for Oracle. -
T-SQL enhancements—Two of the most important T-SQL enhancements in
Denali are the addition of the Sequence object and the window functions. Unlike
the similar Identity column, Sequence lets you tie unique row identifiers across
multiple tables. The new window functions apply to sets of rows using the new
OVER clause. You can read more about window functions in “Window Functions
(OVER Clause)—Help Make a Difference.” -
Columnar store index— The columnar store index or, as it is sometimes
called, the column-based query accelerator, uses the same high performance/high
compression technology that Microsoft uses in PowerPivot, and it brings that
technology into the database engine. Indexed data is stored according to the
data of each column rather than by the rows, and only necessary columns are
returned as query results for columnar indexes. Microsoft states this technology
can provide up to 100 times improvement in query performance in some cases. -
Support for Windows Server Core—The ability to run SQL Server on
Windows Server Core has been missing from previous releases of SQL Server.
Server Core is designed for infrastructure applications such as SQL Server that
provide back-end services but don’t really need a GUI on the same server.
Denali’s support for Server Core enables leaner and more efficient SQL Server
installations and at the same time reduces potential attack vectors and the need
for patching. -
AlwaysOn—Without a doubt, the most important new feature in SQL Server
Denali is the new SQL Server AlwaysOn feature. AlwaysOn is essentially the next
evolution of database mirroring. AlwaysOn supports up to four replicas, the data
in the replicas can be queried, and backups can be performed from the replicas.
Although it’s still early, AlwaysOn seems more complicated to set up than
database mirroring because it requires Windows Failover Clustering, but the
advantages appear to make it well worth the extra effort.
Here is some highlight of the new Denali release for SQL Server, that I thought
worth sharing.
Number 5 is interesting because of the Oracle interface !!!
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
The next release of Microsoft SQL Server, code-named Denali, is right around the
corner. Microsoft has just released Denali CTP3, and the final release is
expected by the end of the year. Denali continues SQL Server’s climb into the
enterprise with a number of important features. Here are the top 10 most
significant new features in the SQL Server Denali release.
-
SQL Server Developer Tools—One of the most obvious improvements in SQL
Server Denali is the new development environment, SQL Server Developer Tools,
coded-named Juneau. Juneau uses the Windows Presentation Foundation
(WPF)–based Visual Studio 2010 shell, and it unifies development for
Business Intelligence Development Studio (BIDS) and Visual Studio. One goal for
Juneau is to make the development environment consistent for both SQL Azure and
the on-premises version of SQL Server. -
Contained databases—Contained databases make it easy to move databases
between different instances of SQL Server. With Denali, login credentials are
included with contained databases. Users don’t need logins for the SQL Server
instance because all authentications are handled by the contained database.
Contained databases have no configuration dependencies on the instance of SQL
Server that they’re hosted on and can be moved between on-premises SQL Server
instances and SQL Azure. -
Project “Crescent”—The new data visualization tool,
code-named Project “Crescent,” is Closely integrated with SharePoint
2010 and Silverlight. Microsoft has called the Crescent feature “PowerPoint
for your data.” Crescent makes it easy for users to create great-looking
data pages and dashboards by using data models that are built using PowerPivot
or from tabular data from SQL Server Analysis Services. -
Data Quality Services—Valid data is critical for making effective
business intelligence (BI) decisions. Data Quality Services lets you set up a
knowledge base that defines your metadata rules. You can then run Data Quality
Services projects to apply those rules to data stored in a SQL Server data
source. The Data Quality Services projects cleanse the data and allow viewing of
good, invalid, and corrected rows. -
User-defined server roles—An important security-related feature in
Denali is the addition of user-defined severs roles. Earlier releases had fixed
server roles that were predefined by Microsoft. These roles covered most
situations, but they weren’t as flexible or granular as some organizations
wanted. The new user-defined server roles give organizations more control and
customization ability over SQL Server’s server roles. -
Change data capture (CDC) for Oracle— CDC lets you keep large tables in
sync by initially moving a snapshot to a target server, then moving just the
captured changes between the databases. With the SQL Server 2008 release, CDC
was limited to SQL Server, but many organizations also have other database
platforms they want to use CDC with. A big improvement in the Denali release is
the addition of CDC for Oracle. -
T-SQL enhancements—Two of the most important T-SQL enhancements in
Denali are the addition of the Sequence object and the window functions. Unlike
the similar Identity column, Sequence lets you tie unique row identifiers across
multiple tables. The new window functions apply to sets of rows using the new
OVER clause. You can read more about window functions in “Window Functions
(OVER Clause)—Help Make a Difference.” -
Columnar store index— The columnar store index or, as it is sometimes
called, the column-based query accelerator, uses the same high performance/high
compression technology that Microsoft uses in PowerPivot, and it brings that
technology into the database engine. Indexed data is stored according to the
data of each column rather than by the rows, and only necessary columns are
returned as query results for columnar indexes. Microsoft states this technology
can provide up to 100 times improvement in query performance in some cases. -
Support for Windows Server Core—The ability to run SQL Server on
Windows Server Core has been missing from previous releases of SQL Server.
Server Core is designed for infrastructure applications such as SQL Server that
provide back-end services but don’t really need a GUI on the same server.
Denali’s support for Server Core enables leaner and more efficient SQL Server
installations and at the same time reduces potential attack vectors and the need
for patching. -
AlwaysOn—Without a doubt, the most important new feature in SQL Server
Denali is the new SQL Server AlwaysOn feature. AlwaysOn is essentially the next
evolution of database mirroring. AlwaysOn supports up to four replicas, the data
in the replicas can be queried, and backups can be performed from the replicas.
Although it’s still early, AlwaysOn seems more complicated to set up than
database mirroring because it requires Windows Failover Clustering, but the
advantages appear to make it well worth the extra effort.