The Buzz Beyond Security How to Plan Life after SQL Server 2005
SQL Server 2016:
WRITTEN BY JONATHAN CLARK T
HE highlights of the newest version of Microsoft’s SQL Server 2016 take security and visibility upgrades of
earlier versions and move toward availability, simplicity, and consistency. While security is an important factor to consider, other improved features bring a lot to the table for SQL Server 2016 in Microsoft’s quest to meet the needs of today’s modern business.
Whether building or managing solutions on premises or in the cloud, the always- encrypted technology protects data at rest and in transit. With even higher availability and improved scalability, and hybrid solutions that allow for stretched database and easy migration, the latest version of SQL Server 2016 has some new features that created a buzz for those enterprises looking for tools with revolutionary mission critical performance that offer deeper insight across data and devices.
Some of the highlights of the new product offering advances for mission-critical performance include:
• In-memory enhancements that allow for real-time operational analytics
• In-memory OLTP enhancements with greater T-SQL surface area
• Up to 30x faster transactions
• Higher availability than SQL Server 2014 with improved always-on secondaries
• Ability to have up to 3 synchronous replicas
• Enhanced data caching across multiple cores
• Native JSON support • Temporal database to track historical changes
Access to data and deeper insights across data are additional advancements that provide enhanced performance, scalability, and usability across SQL Server Enterprise
information management tools and analysis services. SQL Server 2016 also allows for advanced analytics on a massive scale across data and devices with Mobile BI, enhanced reporting services, and built-in advanced analytics.
ABOUT THE AUTHOR:
Jonathan Clark is a Product Line Manager for Microsoft at PC Connection, Inc. with more than 12 years of experience in software, product management, and marketing. He holds multiple sales specialist certifications across the Microsoft stack of products, including small business, cloud, digital marketing, and devices. Read more of his insights
atwww.pcconnection.com/ClarkBlog
62
we solve IT™
IMAGE © CHEREZOFF / FOTOLIA
Connection®
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42 |
Page 43 |
Page 44 |
Page 45 |
Page 46 |
Page 47 |
Page 48 |
Page 49 |
Page 50 |
Page 51 |
Page 52 |
Page 53 |
Page 54 |
Page 55 |
Page 56 |
Page 57 |
Page 58 |
Page 59 |
Page 60 |
Page 61 |
Page 62 |
Page 63 |
Page 64 |
Page 65 |
Page 66 |
Page 67 |
Page 68 |
Page 69 |
Page 70 |
Page 71 |
Page 72 |
Page 73 |
Page 74 |
Page 75 |
Page 76 |
Page 77 |
Page 78 |
Page 79 |
Page 80 |
Page 81 |
Page 82 |
Page 83 |
Page 84 |
Page 85 |
Page 86 |
Page 87 |
Page 88