Microsoft SQL Server 2016 Standard Edition

Microsoft SQL Server 2016 Standard Edition

Get faster data management and improved security with Microsoft SQL Server 2016.

SQL Server 2016 provides improved availability and greater scalability.

Transform data and deliver actionable insight with modern reports.

Utilize open-source R integration for advanced analytics.

Some of the new capabilities of SQL Server 2016:

Build intelligent, mission-critical applications

Break free from Oracle

Always Encrypted

Real-time operational analytics

In-database analytics

PolyBase

And much much more. Check on the Internet, it has hours of reading about SQL Server 2016.

Standard Edition:

SQL Server Standard provides core data management and business intelligence capabilities for non-critical workloads with minimal IT resources.

The most affordable way to get SQL, this option is great for small (1 – 30) users or devices.

Mission Critical Performance

• Disk-based OLTP
• 24 cores max and 128 GB max memory
• 2-node single database failover (non-readable secondary)
• Query Store
• Temporal

Security

• Row-level security
• Dynamic data masking
• Basic auditing
• Separation of duties
• Policy-based management

Data Warehousing

• PolyBase (compute node only)
• Support for JSON

Business Intelligence

• Basic tabular (16GB memory per instance)
• Web portal experience
• Modernized reports
• Pin reports to Power BI
• Enhanced multidimensional models

Advanced Analytics

• Single-threaded for RRE
• Connectivity to R Open

Hybrid Cloud

• 
  
• Stretch Database
• Backup to Azure