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
Menu
Search
  • 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
    • IT Management
    • Networking

    Microsoft Looks to Push SQL Server Deeper into the Data Warehousing Space

    By
    Brian Prince
    -
    February 23, 2009
    Share
    Facebook
    Twitter
    Linkedin

      Microsoft has partnered with a number of hardware vendors to create a new set of reference architectures aimed at cutting the complexity associated with creating data warehouses.

      Microsoft officials say the Microsoft SQL Server Fast Track Data Warehouse is intended to give customers access to preconfigured industry-standard hardware from Hewlett-Packard, Dell and Bull. In addition, Microsoft officials said Microsoft is partnering with Avanade, Cognizant Technology Solutions, HP and Hitachi Consulting to provide solution templates and technical guidance to help customers create customized architectures for their data warehouse needs.

      “This is basically a step towards appliance-sizing SQL Server for data warehousing … basically Microsoft taking on the responsibility for pretuning the database-to-hardware interface, which we’ve just found over the years to be a point of real complexity and difficulty for the typical DBA [database administrator],” said Stuart Frost, general manager of Microsoft’s SQL Server Data Warehousing Product Unit.

      “A DBA will take whatever hardware his company uses, and from the vendor point of view … we have no idea what the customer is trying to deploy on,” Frost continued. “What we have to do is work with a very disparate set of hardware platforms over the years, so we really couldn’t optimize the database to work in a specific way with the hardware platform. This creates a lot of work for the DBA. They have to be able to understand operating systems settings, storage infrastructure … and they have to understand how to get SQL Server to work on that platform.”

      The reference architectures will solve those problems, he said, and build on the foundation that Microsoft laid down with the purchase of DATAllegro in 2008. According to officials at Microsoft, the company is pushing ahead with plans to integrate DATAllegro’s massively parallel processing technology with SQL Server 2008 in a project code-named Madison.

      The offering is meant to increase Microsoft SQL Server 2008’s scalability up to 32TB and to slash the time and effort required to deploy mission-critical projects. Through balanced configurations, the new reference architectures are designed to optimize all hardware components, delivering up to 200MB per second per central processing unit core, according to Microsoft. The hardware and reference architectures are available from Bull, Dell and HP starting at $13,000 per terabyte.

      “With Microsoft SQL Server 2008 running on Dell PowerEdge servers, these new data warehousing solutions are able to scale from several terabytes to multi-tens of terabytes,” Judy Chavis, director of Software Marketing and Business Development at Dell, said in a statement. “Soon, they’ll be able to scale even higher. This industry-standard solution gives customers a cost-effective alternative to other proprietary business intelligence solutions available today.”

      Brian Prince

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more

      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.
      © 2021 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.

      ×