Microsoft first announced the next version of SQL Server during last June 2013's TechEd conference and made it available as a public preview soon after. Currently, SQL Server 2014 is in the Community Technology Preview 2 (CTP2) stage. Released last fall, CTP2 is due to expire at the end of March. Microsoft is expected to release SQL Server 2014 in the early part of 2014.
Related: TechEd 2013: Eron Kelly talks about SQL Server 2014
Among the improvements Microsoft is bringing to SQL Server 2014 is integration with Windows Azure for backup and recovery, as well as scalability. SQL Server 2014 also includes Microsoft's in-memory online transactional processing (OLTP) technology, previously code-named "Hekaton."
Case studies outlining the detailed experiences of several SQL Server 2014 beta testers are available from Microsoft. Following is a brief overview of the experiences of four SQL Server 2014 early adopters.
bwin.party is the world’s largest regulated online gaming company. Hundreds of thousands of people visit the company’s website every day, placing more than 1 million bets on a range of casino games, poker, and sports.
SQL Server 2014 Gains Experienced by bwin.party
Using in-memory OLTP in SQL Server 2014, bwin.party:
- can support close to 20 times the number of current site users
- can ensure that players have a faster, better experience
- is saving money and growing revenue
Check out a case study outlining bwin.party's experience with SQL Server 2014, "Gaming Site Can Scale to 250,000 Requests Per Second and Improve Player Experience."
Edgenet provides optimized product data for suppliers, retailers, and search engines including Bing and Google. Used online and in stores, Edgenet solutions ensure that businesses and consumers can make decisions based on timely, accurate product information.
Edgenet realized it could take advantage of an in-memory OLTP solution to improve throughput and eliminate read-write locks. The company decided to become an early adopter of the technology, which would be built into SQL Server 2014.
Benefits of SQL Server 2014 for Edgenet
With SQL Server in-memory technologies, Edgenet has:
- gained real-time access to product data
- faster throughput
- better customer satisfaction
- improved BI capabilities
Learn more by reading the case study, "Data Services Firm Gains Real-Time Access to Product Data with In-Memory Technology."
SBI Liquidity Market
SBI Liquidity Market Company provides online services for commodity traders such as banks and securities firms. Based in Tokyo, SBI Liquidity Market is a global leader in the foreign exchange (FX) market.
To improve transaction processing and customer service, SBI Liquidity Market decided to become an early adopter of the in-memory OLTP solution available with SQL Server 2014.
Positives SBI Liquidity Market Experienced Using SQL Server 2014
With a trading system based on SQL Server 2014 in-memory OLTP, SBI Liquidity is gaining:
- faster performance
- better scalability
- improved support for global expansion
Want to learn more about SBI's experience? Visit "Leading Japanese Financial Firm Accelerates Trading Platform with In-Memory OLTP."
TPP, headquartered in Leeds, England, is a software company that aims to connect different healthcare organizations through comprehensive IT solutions. The company’s SystmOne clinical software application, used by physicians and other health professionals across England, accurately and securely documents every appointment, medication, allergy, and physician contact a patient has ever had.
To increase scalability and performance, TPP began searching for new database technologies in November 2012.
Benefits TPP Saw Using SQL Server 2014
Using in-memory OLTP in SQL Server 2014 in testing, TPP:
- saw seven times faster processing performance for SystmOne
- the ability to scale to handle hundreds of thousands of additional users
- expects to save time and money by not having to create its own database system
Read more about TPP's experience using SQL Server 2014, "Clinical Software Easily Supports Thousands of New Users and Helps Doctors Save Lives."
Is SQL Server 2014 right for your organization?