Microsoft Announces SQL Server 2014 during Microsoft TechEd 2013
Last week during Microsoft TechEd 2013, Microsoft announced plans to incorporate in-memory OLTP (through a new engine codenamed Hekaton) in SQL Server 2014. They also expanded on some features included in the upcoming release. A mere 14 months after SQL Server 2012 was released, Microsoft has found ways to improve SQL Server and keep moving towards their cloud first model. SQL Server 2014 will deliver improved performance with in-memory capabilities, easier access to any data, big or small, and enable a hybrid cloud platform. It increases performance gains up to 50x, increases the high availability demand using the AlwaysOn functionality, and speeds up analysis using data connected in Excel. The final product is expected to ship in early 2014. However, a first CTP of SQL Server 2014 is said to be opened around late June 2013. (You can sign up for a notification here) According to officials at TechEd, the Hekaton in-memory capabilities are designed to augment the current in-memory data-warehousing and BI capabilities already in SQL Server. Although Microsoft is switching the core engine, traditional SQL Server tables will continue to work with Hekaton, enabling users to see performance improvement on current hardware. With SQL Server 2012, Microsoft introduced new in-memory index column store capabilities
into its database. But that column store was an in-memory index. One major improvement of SQL Server 2014 over 2012 is the updatable column store with larger data compression and quicker query speeds — allowing for more real-time analytics processing. SQL Server 2014 will also back-up more compatibly with Windows Azure, allowing users to back up their data (manually or automatically) to the cloud almost instantly in foresight for quick recovery from loss of data.
Highlights of what’s new in 2014:
- In-Memory Built-In OLTP
- Performance gains between 10x and 50x
- Main memory rather than disk storage
- Faster and improved ColumnStore compression
- No need to buy additional hardware or software for this functionality
- New hybrid cloud scenarios
- Comprehensive, high-availability technologies that extend into Windows Azure to make the highest level of service level agreements possible for every application
- Improved “Always On” functionality
- Simplified cloud backup and disaster recovery
- Easier migration to Windows Azure Virtual Machines
- Real time insights (Code name “Data Explorer” )
- Easier access to internal and external data using Excel
- Real-time data integration
- New and large data sets
- Data signals from outside LOB systems
- Evolving analytics techniques
- More visualization and collaboration experiences
Justin Taylor has been architecting, building and managing business intelligence projects since 1999, including solutions for several Fortune 500 companies. When Justin joined StatSlice, he was looking for an opportunity to make a major contribution to the company and utilize his technology experience to help clients solve their business problems. Justin has broad experience in data warehousing, business analytics, reporting and dashboards, and data architectures. He enjoys opportunities to speak at technology events, conferences and training. He holds several Microsoft certifications include MCT (trainer), MCTS and MCITP certifications in SQL Server BI, and Certified Scrum Master through ScrumAlliance.org.
You can subscribe to our RSS feed.