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 Cloud
    • Cloud
    • Database

    Microsoft SQL Server 2014 Already Powering Production Workloads

    By
    Pedro Hernandez
    -
    May 18, 2014
    Share
    Facebook
    Twitter
    Linkedin

      Microsoft SQL Server 2014 may have just left the gate, but there are already indications that the technology could have a big impact on the IT operations of the software giant’s customers.

      SQL Server 2014 has been generally available since April 1. Sporting new features including in-memory online transaction processing (OLTP), solid-state disk (SSD)-based buffer pool extension support and hybrid cloud capabilities, SQL Server 2014 is Microsoft’s database platform for the “ambient intelligence” era, which the company envisions will in large part be fueled by the Internet of things (IoT).

      Naturally, risk-averse enterprises take a wait-and-see approach before embarking on big technology upgrades. In the case of SQL Server 2014, however, some companies have already dived in, according to Mark Souza, general manager of the Microsoft Azure Customer Advisory Team.

      It’s common practice for IT vendors to grant select customers access to their upcoming offerings. Microsoft’s take on the practice is called the Technology Adoption Program (TAP). In the months prior to the release of SQL Server 2014, some TAP participants have already standardized on the platform.

      Souza points to NASDAQ OMX Group, the financial trading services and exchange technology company. “This customer deployed SQL Server 2014 in a production environment for several months prior to general availability of the product,” he informed in a company blog post.

      The draw for NASDAQ OMX was SQL Server’s newfound storage-sparing features. “The cost savings on storage of 500+ terabytes of data, now compressed by ~8x using SQL Server 2014 in-memory columnstore for data warehousing indexes, provides an easy justification to upgrade, especially now that the in-memory columnstore is updatable,” wrote Souza.

      SQL Server 2014 helped bwin.party, an online gambling firm, “scale its applications to 250k requests per second, a 16x increase from the 16k requests per second on a previous version of SQL Server, using the same hardware,” said Souza. In addition, it enabled the company to slash “the number of servers running SQL Server from eighteen to one, simplifying the overall data infrastructure significantly.” The firm “went into production more than a year before we released the product,” he said.

      Edgenet, a data services company that specializes in manufacturing and retail, leverages SQL Server 2014 to power its online selling guide. The software’s new in-memory OLTP capabilities enable “them to eliminate the application-tier cache and to scale reads and writes within the database,” said Souza. “Data load performance improved 7x–11x.”

      Read/write conflicts are a thing of the past, courtesy of in-Memory OLTP, informed Souza. Edgenet enlisted SQL Server 2014 into production four months before it shipped.

      TAP may have fast-tracked some customers’ technology plans, but Microsoft also got something out of the deal, suggested Souza. “The program obviously benefits Microsoft because no matter how well we test the product, it is real customer workloads that determine release quality.”

      Pedro Hernandez
      Pedro Hernandez is a contributor to eWEEK and the IT Business Edge Network, the network for technology professionals. Previously, he served as a managing editor for the Internet.com network of IT-related websites and as the Green IT curator for GigaOM Pro.

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

      ×