Microsoft SQL Server

Key Features

* Real-time operational analytics - Combine in-memory columnstore and rowstore capabilities in SQL Server 2016 for fast analytical processing right on your transactional data. Open up new scenarios like real-time fraud detection, scale your business with up to 30x faster transactions, and improve query performance from minutes to seconds. * High availability and disaster recovery - Gain mission-critical uptime, fast failover, easy setup, and load balancing of readable secondaries with enhanced Always On in SQL Server 2016—a unified solution for high availability and disaster recovery. Plus, put an asynchronous replica in an Azure Virtual Machine for hybrid high availability. * Security and compliance - Protect data at rest and in motion with a database that has the least vulnerabilities of any major platform for six years running (National Institute of Standards and Technology, National Vulnerability Database, May 4, 2015). Security innovations in SQL Server 2016 help secure data for mission-critical workloads with a multilayered approach, adding Always Encrypted technology along with row level security, dynamic data masking, and robust auditing. * Mobile BI - Empower business users across the organization with the right insights on any mobile device * Simplify big data - Get access to data, both big and small, with PolyBase technology that queries Hadoop data using simple Transact-SQL commands. In addition, new JSON support lets you parse and store JSON documents and output relational data into JSON files * In-database advanced analytics - Build intelligent applications with SQL Server R Services. Move beyond reactive and into predictive and prescriptive analytics by performing advanced analytics directly within the database. By using multi-threading and massively parallel processing, you’ll gain insights faster than using open source R alone.