Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database
    • Networking

    Microsoft Releases Another SQL Server 2008 CTP

    By
    Peter Galli
    -
    November 12, 2007
    Share
    Facebook
    Twitter
    Linkedin

      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 products 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 Microsofts 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 MySQLs 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.coms for the latest database news, reviews and analysis.

      Peter Galli
      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.

      MOST POPULAR ARTICLES

      Big Data and Analytics

      Alteryx’s Suresh Vittal on the Democratization of...

      James Maguire - May 31, 2022 0
      I spoke with Suresh Vittal, Chief Product Officer at Alteryx, about the industry mega-shift toward making data analytics tools accessible to a company’s complete...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Applications

      Cisco’s Thimaya Subaiya on Customer Experience in...

      James Maguire - May 10, 2022 0
      I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×