Close
  • Latest News
  • Artificial Intelligence
  • 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
  • Artificial Intelligence
  • 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 Database
    • Database

    Microsoft SQL Server 2016 Public Preview Boosts Database Security

    By
    Pedro Hernandez
    -
    May 29, 2015
    Share
    Facebook
    Twitter
    Linkedin
      SQL Server

      Microsoft has released the first SQL Server 2016 Community Technology Preview, allowing database administrators to test out the software’s new capabilities. The preview is available for download now at the company’s TechNet Evaluation Center.

      “This public preview gives an early look into many of the capabilities in the release and allows early adopters to get engaged by testing the preview in their environments or via a virtual machine in Microsoft Azure,” said Corporate Vice President T.K. “Ranga” Rengarajan in a May 27 announcement. “SQL Server 2016 provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud.”

      The database, a follow-up to the company’s analytics-friendly SQL Server 2014 release, also keeps a tighter lid on sensitive information courtesy of a Microsoft Research technology called Always Encrypted, which protects data both at rest and in motion.

      “With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the application in the customer’s trusted environment,” said Rengarajan. “Encryption and decryption of data happen transparently inside the application which minimizes the changes that have to be made to existing applications.”

      Also new to SQL Server 2016 is a feature called Stretch Database that enlists the company’s Azure cloud to improve performance.

      “As core transactional tables grow in size, you may need to archive historical data to lower cost and to maintain fast performance,” explained Rengarajan in an earlier preview of the new feature. “This unique technology allows you to dynamically stretch your warm and cold transactional data to Microsoft Azure, so your operational data is always at hand, no matter the size, and you benefit from the low cost of using Microsoft Azure.” Combining Always Encrypted and Stretch Database allows customers to extend their “data in a more secure manner for greater peace of mind,” he added.

      In terms of data processing, SQL Server 2016 will incorporate some of the technologies from this year’s Revolution Analytics acquisition.

      Microsoft snapped up Mountain View, Calif.-based R language and big data analytics specialist in January for an undisclosed amount. “Revolution Analytics is the leading commercial provider of software and services for R, the world’s most widely used programming language for statistical computing and predictive analytics,” said Joseph Sirosh, corporate vice president of Machine Learning at Microsoft, in a Jan. 23 statement.

      Today, testers can preview some of the platform’s in-database analytics with capabilities with R integration.

      Data analytics is now available as an additional workload powered by Revolution Analytics technology. “We want to make advanced analytics more accessible and increase performance for your advanced analytic workloads by bringing R processing closer to the data and building advanced analytic capabilities right into SQL Server,” Rengarajan said.

      Other upgrades include in-memory online transaction processing (OLTP), native JavaScript Object Notation (JSON) support, new row-level security features, and faster Microsoft Azure backup and restore operations, to name a few.

      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.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      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.
      © 2022 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.

      ×