SQL Server
Open Jobs: SQL Server DBA
6 month contract in Clearwater, FL.
Please fill out our contact form or call us 24/7 at: (813) 322-3240
Product Updates
SQL Server 2008 R2
SQL Server 2008 added some long awaited features like data compression, backup compression, FILESTREAM data files and improved security.
SQL Server 2008 R2 added a new piece of software called the Master Data Services, which allows DBA to take control over a multi server SQL Server 2008 R2 environment. Other improvements are centered around the analytical and reporting services. No core server enhancements have been released.
Download SQL Server 2008 Express now
SQL Server 2011, code name Denali
After 2 releases of SQL Server 2008 and SQL Server 2008 R2, Microsoft is releasing the new SQL Server 2011, code name Denali. At a first glance this is a developer’s release. Many new features are geared to better support SQL developers and a better integration into Visual Studio is also a key improvement.
Here are some of the new features:
Multi-Subnet Failover Clustering: This feature allows to geographically separate cluster nodes to provide disaster recovery and high availability. This feature depends on Windows Server failover cluster.
Sequences: Oracle style sequences for unique key value generation. Finally!
Query Paging: This is a feature that MySQL offers for years and now SQL Server is offering as well. Paging through result sets has some distinct performance advantages and simplifies coding efforts for developers.
The most significant change is the drop of DTS package support. This is not actually an announced feature, but an observation within SQL Server Management Studio. The Data Transformation Services menu option under the Legacy section has been removed. I think it is time for the hold outs to convert their old DTS packages to SSIS.
A little side note, SQL Server Management Studio now offers support for multi-screen environments.
