Microsoft Releases Another SQL Server 2008 CTP

By Peter Galli  |  Print this article Print


Desktop-as-a-Service Designed for Any Cloud ? Nutanix Frame

This third update includes compatibility with Windows Vista and the upcoming Windows Server 2008.

BARCELONA, Spain—Microsoft has released the third Community Technology Preview for SQL Server 2008, which includes new functionality and brings compatibility with Windows Vista and the upcoming Windows Server 2008.

"SQL Server 2008 running on Windows Server 2008 provides customers with trusted and secure access, high availability through revamped failover clustering, and simplified scripting through Powershell," Francois Ajenstat, director of product management for SQL Server, told eWEEK here at the TechEd IT Forum conference, which starts Nov. 12.

This latest CTP, which Ajenstat likens to a traditional second beta, has a lot of substance and new features, he said, noting that the SQL team is targeting one more CTP prior to the product's launch in late February 2008.

This latest update to the software also brings with it new features, such as a resource governor, which enables users to define resource limits and priorities for different workloads to ensure predictable performance, and backup compression, which requires less storage to keep backups online and which runs significantly faster since less disk I/O is required, he said.

SQL Server 2008 will be part of Microsoft's biggest product launch ever. Read more here.

Another new feature, transparent data encryption, enables the encryption of an entire database, data files and log files without the need for application changes. "Encryption enables organizations to meet the demands of regulatory compliance and overall concern for data privacy," Ajenstat said.

Also included are new cube design tools to help users streamline the development of the analysis infrastructure, enabling them to build solutions for optimized performance, while block computations help improve processing performance, allowing users to increase the depth of their hierarchies and complexity of the computations, he said.

The enhanced report designer includes new visualizations and integration with the 2007 Microsoft Office system.

This is also the first SQL 2008 CTP to help customers store and consume any type of data, including new Filestream data types for unstructured documents, and to support spatial data for location intelligence.

Some commentators have found Office 2007 off-putting. Click here to read more.

"Filestream lets large binary data, traditionally managed by the database, get stored outside the database as individual files that can be accessed using an NTFS streaming API," Ajenstat said.

The new SQL Server 2008 Filestream data type allows large binary data such as documents and images to get stored directly in an NTFS file system, where the document or image remains an integral part of the database and maintains transactional consistency, he said.

With this latest CTP, customers and partners can also consume, use and extend location-based data through spatial-enabled applications, and build location-aware applications using the new spatial data capabilities in SQL Server 2008, Ajenstat said.

"We created these new spatial features with partners in mind: building core capabilities into SQL Server to enable a broad range of solutions. Our approach is to broaden the use and applicability of spatial technology to a wide range of solutions, so anyone can benefit," he said.

Read here about the preview of MySQL's upcoming releases.

There are more than 15 industry partners who have already announced their intention to ship applications to take advantage of the spatial data support in SQL Server 2008, including AWhere, Barrodale, ESRI, IntraGIS, I.S. Consulting, Manifold, Safe Software and SpatialPoint, Ajenstat said.

Check out eWEEK.com's for the latest database news, reviews and analysis.

Peter Galli has been a financial/technology reporter for 12 years at leading publications in South Africa, the UK and the US. He has been Investment Editor of South Africa's Business Day Newspaper, the sister publication of the Financial Times of London.

He was also Group Financial Communications Manager for First National Bank, the second largest banking group in South Africa before moving on to become Executive News Editor of Business Report, the largest daily financial newspaper in South Africa, owned by the global Independent Newspapers group.

He was responsible for a national reporting team of 20 based in four bureaus. He also edited and contributed to its weekly technology page, and launched a financial and technology radio service supplying daily news bulletins to the national broadcaster, the South African Broadcasting Corporation, which were then distributed to some 50 radio stations across the country.

He was then transferred to San Francisco as Business Report's U.S. Correspondent to cover Silicon Valley, trade and finance between the US, Europe and emerging markets like South Africa. After serving that role for more than two years, he joined eWeek as a Senior Editor, covering software platforms in August 2000.

He has comprehensively covered Microsoft and its Windows and .Net platforms, as well as the many legal challenges it has faced. He has also focused on Sun Microsystems and its Solaris operating environment, Java and Unix offerings. He covers developments in the open source community, particularly around the Linux kernel and the effects it will have on the enterprise.

He has written extensively about new products for the Linux and Unix platforms, the development of open standards and critically looked at the potential Linux has to offer an alternative operating system and platform to Windows, .Net and Unix-based solutions like Solaris.

His interviews with senior industry executives include Microsoft CEO Steve Ballmer, Linus Torvalds, the original developer of the Linux operating system, Sun CEO Scot McNealy, and Bill Zeitler, a senior vice president at IBM.

For numerous examples of his writing you can search under his name at the eWEEK Website at www.eweek.com.


Submit a Comment

Loading Comments...