APAC CIOOutlook

Advertise

with us

  • Technologies
      • Artificial Intelligence
      • Big Data
      • Blockchain
      • Cloud
      • Digital Transformation
      • Internet of Things
      • Low Code No Code
      • MarTech
      • Mobile Application
      • Security
      • Software Testing
      • Wireless
  • Industries
      • E-Commerce
      • Education
      • Logistics
      • Retail
      • Supply Chain
      • Travel and Hospitality
  • Platforms
      • Microsoft
      • Salesforce
      • SAP
  • Solutions
      • Business Intelligence
      • Cognitive
      • Contact Center
      • CRM
      • Cyber Security
      • Data Center
      • Gamification
      • Procurement
      • Smart City
      • Workflow
  • Home
  • CXO Insights
  • CIO Views
  • Vendors
  • News
  • Conferences
  • Whitepapers
  • Newsletter
  • Awards
Apac
  • Artificial Intelligence

    Big Data

    Blockchain

    Cloud

    Digital Transformation

    Internet of Things

    Low Code No Code

    MarTech

    Mobile Application

    Security

    Software Testing

    Wireless

  • E-Commerce

    Education

    Logistics

    Retail

    Supply Chain

    Travel and Hospitality

  • Microsoft

    Salesforce

    SAP

  • Business Intelligence

    Cognitive

    Contact Center

    CRM

    Cyber Security

    Data Center

    Gamification

    Procurement

    Smart City

    Workflow

Menu
    • Cyber Security
    • Hotel Management
    • Workflow
    • E-Commerce
    • Business Intelligence
    • MORE
    #

    Apac CIOOutlook Weekly Brief

    ×

    Be first to read the latest tech news, Industry Leader's Insights, and CIO interviews of medium and large enterprises exclusively from Apac CIOOutlook

    Subscribe

    loading

    THANK YOU FOR SUBSCRIBING

    Microsoft Releases SQL Server 2016 with Enhanced Real-time Analytics

    Microsoft announces the release of its SQL Server 2016 database globally. The SQL Server 2016 includes enhancements such as in-memory column stores for real-time analytical processing. 

    Microsoft Releases SQL Server 2016 with Enhanced Real-time Analytics

    By

    Apac CIOOutlook | Tuesday, June 07, 2016

    Stay ahead of the industry with exclusive feature stories on the top companies, expert insights and the latest news delivered straight to your inbox. Subscribe today.

    FREMONT, CA: Microsoft announces the release of its SQL Server 2016 database globally. The SQL Server 2016 includes enhancements such as in-memory column stores for real-time analytical processing.

    The SQL Server 2016 includes a new paradigm where all joins, aggregations and machine learning are performed securely within the database itself, without moving the data out. This enables analytics on real-time transactions to be executed with great speed.

    Microsoft also included performance improvements by re-engineering of SQL Server 2016's data processing paradigm. Keeping up with the industry standard Transaction Processing Council (TPC-H) database benchmark, Microsoft claimed to load a complex schema at 1.6 terabytes per hour on a single server with four Intel Xeon E7 processors.

    The SQL Server 2016 database also provides tools for cross-platform analytics such as Polybase, which allows users to run queries on external data kept in Hadoop or Azure binary large object (BLOB) storage. Microsoft R Services, which is integrated with SQL Server also runs on multiple Hadoop distributions and is also integrated with Azure HDInsight + Spark, enabling both choice and standardization in developing analytics code. Also, R Tools for Visual Studio allows the ease of use of the modern Visual Studio IDE for developing analytical code in R.

    According to the statistics compiled by the National Institute of Standards and Technology (NIST), SQL Server has the least vulnerabilities as compared to any of the major database platforms, for 6 years in a row. Microsoft now claims that SQL Server 2016 security capabilities are even more secure with its Always Encrypted, Transparent Data Encryption, Dynamic Data Masking (DDM) and Row Level Security (RLS).

    The Always Encrypted database engine helps protect data at rest and in memory. Transparent Data Encryption- encrypts all user data now with low-performance overhead. The Dynamic Data Masking (DDM) and Row Level Security (RLS) features allow developers to build applications that restrict access and protect data.

    The new database will be available on Microsoft's Windows Server platform, Azure Cloud and also for open source Linux distributions. The SQL Server 2016 can be deployed as a standalone system, in hybrid clouds and public clouds.

    More in News

    AI's Role in Apac's Digital Transformation Journey

    AI's Role in Apac's Digital Transformation Journey

    Salesforce Services in APAC: Empowering Digital Transformation Across the Region

    Salesforce Services in APAC: Empowering Digital Transformation Across the Region

    Enhancing Customer Satisfaction through Omni-Channel Payments

    Enhancing Customer Satisfaction through Omni-Channel Payments

    Impact of Blockchain on Supply Chain Innovation

    Impact of Blockchain on Supply Chain Innovation

    I agree We use cookies on this website to enhance your user experience. By clicking any link on this page you are giving your consent for us to set cookies. More info

    Copyright © 2025 APAC CIOOutlook. All rights reserved. Registration on or use of this site constitutes acceptance of our Terms of Use and Privacy and Anti Spam Policy 

    Home |  CXO Insights |   Whitepapers |   Subscribe |   Conferences |   Sitemaps |   About us |   Advertise with us |   Editorial Policy |   Feedback Policy |  

    follow on linkedinfollow on twitter follow on rss
    This content is copyright protected

    However, if you would like to share the information in this article, you may use the link below:

    https://www.apacciooutlook.com/news/microsoft-releases-sql-server-2016-with-enhanced-realtime-analytics-nwid-2179.html