Microsoft is set and would launch its next version of (Structured Query Language) SQL Server, the company’s main known database product on June 1, the company announced today. Microsoft to Launch The next version of a (Structured Query Language) SQL Server.
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software productwith the primary function of storing and retrieving data as requested by other software applicationswhich may run either on the same computer or on another computer across a network (including the Internet).
Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
According to Tiffany Wissner a Senior Director of Data Platform Marketing.
SQL Server 2016 is the foundation of Microsoft’s data strategy, encompassing innovations that transform data into intelligent action. With this new release, Microsoft is delivering an end-to-end data management and business analytics solution with mission critical intelligence for your most demanding applications as well as insights on your data on any device. Recently, we had the opportunity to showcase the exciting capabilities and what customers are doing with SQL Server 2016 at our Data Driven event. Building on this momentum, today we are excited to announce the following:
*. SQL Server 2016will be generally available on June 1, 2016.This will allow you to build mission-critical, and business critical intelligent applications with the most secure database1, the highest performance data warehouse2, end-to-end mobile BI on any device, in-database advanced analytics, in-memory capabilities optimized for all workloads, and a consistent experience from on-premises to cloud. These capabilities are built-in to SQL Server for industry-leading low cost of ownership.
*.New SQL Server 2016 performance benchmarks. Today, Lenovo published a new #1 TPC-H 30 TB world record 3 using SQL Server 2016 and Windows Server 2016 on Lenovo System x3950 X6.This result, in addition to recent benchmarks by software and hardware partners, as well as key applications across variety of workloads, proves that SQL Server 2016 is the fastest in-memory database on the planet for your applications.
*.The SQL Server 2016 editionsinclude Enterprise, Standard, Express, and Developer. In March, we announcedthat the SQL Server 2016 Developer edition will be a free download to enable broad access to and development on the full capabilities of the latest SQL Server release.
SQL Server general availability
SQL Server 2016will be generally available on June 1, 2016. SQL Server 2016 is a comprehensive high performance high scale data platform for your most demanding applications and insights on your data on any device. SQL Server 2016 seamlessly manages both relational and beyond relational (JSON, XML, Hadoop) data, seamlessly integrates structured data with Hadoop data, and seamlessly integrates on-premises data with cloud data. SQL Server 2016 is ideal for:
*.Mission critical intelligent applicationsdelivering real-time operational intelligence by combining built-in advanced analytics and in-memory technology without having to move the data or impact end user performance.
*.Enterprise scale data warehousingwith enhanced in-memory columnstore that increases query performance by over 100x vs disk based solutions. With SQL Server 2016, you can also access optimized MPP scale out software that can be combined with scale out appliance architecture with our Analytics Platform System (APS).
*.Applications requiring the highest levels of securitywith new Always Encrypted technology that protects your data at rest and in motion without impacting database performance.
*.Comprehensive business intelligence solutions on mobile deviceswith an end-to-end mobile BI solution built-in that can deliver insights on any device. You can also manage all of your KPIs, mobile reports and traditional reports from a modern web portal.
*.New big data solutions that require combining relational datawith non-relational data with PolyBase technology built-in that allows you to query structured and unstructured data with the simplicity of T-SQL.
*.Hybrid cloud solutions that can reduce storage costs, improve high availability and simplify IT operationswith new Stretch Database technology. This keeps more of your historical data at your fingertips by transparently and securely stretching warm and cold OLTP data to Microsoft Azure on-demand without application changes. In addition, faster replicas can be placed in Azure to give you cost effective disaster recovery and backups.
With this new innovation, SQL Server 2016 is the first born-in-the-cloud database, where features such as Always Encrypted and Role Level Security were first validated in Azure SQL Database by hundreds of thousands of customers and billions of queries.
DocuSign is one customer that’s benefitting from the new capabilities in SQL Server 2016. “We picked SQL Server for our platform because of its performance and ability to manage all types of data,” said Eric Fleischman, chief architect and vice president of platform engineering, DocuSign. “With the largest banks, insurers and other financial institutions counting on us we need to deliver secure software for our environment. New features in SQL Server 2016 like Always Encrypted allow us to deliver on this promise.”
SQL Server is also a recognized leader in Gartner Magic Quadrants for Operational Database, Business Intelligence, Data Warehouse, and Advanced Analytics.
Gartner recently named Microsoft as leading the industry in their Magic Quadrant for Operational Database Management Systemsin both execution and vision. We’re also a leader in Gartner’s Magic Quadrant for Data Warehouse and Data Management Solutions for Analytics, and Magic Quadrant for Business Intelligence and Analytics Platforms, as well as leading in vision in the Magic Quadrant for Advanced Analytics Platforms.
SQL Server 2016 delivers ground-breaking performance and scale
Applications and data warehouses need to manage and process greater volumes of data than ever before and we know performance is one of the top reasons customers upgrade to new versions of software. Today, Lenovo published a new #1 TPC-H 30 TB world record using SQL Server 2016 and Windows Server 2016 on Lenovo System x3950 X6.4 This result, in addition to recent benchmarks by software and hardware partners, as well as key applications, show that SQL Server 2016 is the fastest in-memory database on the planet for your applications.
SQL Server 2016 owns the top TPC-E performance benchmarks5 for transaction processing, the top TPC-H performance benchmarks for data warehousing, and the top performance benchmarks with leading business applications like PROS and KPMG.
Customers can also gain tremendous performance improvement by simply upgrading to SQL Server 2016 without application changes (e.g. queries will run up to 34x faster). In addition to leading performance benchmarks, SQL Server 2016 also delivers top price/performance for both workloads.
*.SQL Server 2016 holds two new TPC-E world record price/performance benchmarks.
*.With today’s announcements, SQL Server 2016 holds #1 TPC-H 30TB7 benchmark using 12TB RAM support in Windows Server 2016.8This is in addition to the #1 benchmarks9for TPC-H in 10-TB10, 3-TB11 and 1-TB12.
*.SQL Server 2016 holds top benchmarks for key industry applications (10X faster with PROS, 2.5X faster with KPMG).13
*.SQL Server 2016 provides tremendous performance gain upon upgradefor faster queries, faster availability and faster operations.14
SQL Server 2016 editions
Today we are announcing the features in our editions, including Enterprise, Standard, and Express. With Enterprise, customers benefit from low cost of ownership with the full capabilities of SQL Server built into a single offering including our mission critical database, high performance data warehouse, rich data integration capabilities, end-to-end mobile business intelligence and built-in advanced analytics.
We also are delivering significant value to our customers with SQL Server 2016 Standard including enhanced performance with basic availability, greater scalability up to 24 cores, modern reports, tabular modeling capabilities and robust security that enables multiple layers of protection and allows you to control access to sensitive data. With Express, available as a free download, customers can build and deploy small scale database applications at no cost.
In addition to Enterprise, Standard and Express, Developer edition provides access to the full capabilities of SQL Server to build and test new mission critical, intelligent applications. In March, we announcedthat the SQL Server 2016 Developer edition will also be available as a free download. With Express and Developer edition, we want to make the capabilities of SQL Server 2016 broadly available to developers.
The release follows Microsoft’s usual round of public previews and release candidates since the company first announced this update in 2015. Maybe the biggest difference between this release cycle and others is that the company first tested many of the new features of SQL Server 2016 in its Azure cloud.
As we reported earlier this year, the focus of this update is on speed and security (with the ability to perform some queries on encrypted data without having to decrypt it first), but with this new version, Microsoft is also positioning SQL Server as a solution for data warehousing and big data analytics, thanks to both its built-in R support and its ability to store and query both structured and unstructured data.
Clearly, though, Microsoft is most excited about the speed-ups the update promises — even without making any hardware changes. The company promises that most queries should now run an average of 25 percent faster than before (on the same hardware).
Microsoft also today announced a new Lenovo benchmark that shows SQL Server 2016 running on Windows Server 2016 (which is still in preview) handling a standard database test using 30 terabyte of data faster than any of its competitors.
As DocuSign VP of platform engineering Eric Fleischman disclosed that his company currently uses SQL Server 2016 for storing the metadata of the tens of thousands of transactions per second its users create on the service, among other parts of its system.
DocuSign has been testing SQL Server 2016 and Fleischman called the performance gains it has been able to achieve “off the charts.”
These performance gains, as well as the addition of availability groups, are what DocuSign is most excited about in making the switch to the 2016 edition.
When Asked why DocuSign didn’t opt for one of the many open-source competitor to SQL Server?
Fleischman said that he looks at choosing SQL Server as essentially a hiring decision.
“When you pick SQL [Server] or anything else, you are making a hiring decision,” he said.
“Are they going to help me? We don’t want to go write a database. We want to work with a team that builds databases. That’s why we are staying on this train. The team is receptive and helps us.”
277 total views, 3 views today