Call us on: +44 (0)1364 654100

Home

 » 

Catalogue

 » 

IT

 » 

Database

 » 

Servers

 » 

SQL Server 2016

 SQL Server 2016 [Please Call for Pricing] boxshot

Request a call back about this product

SQL Server 2016 [Please Call for Pricing]

Published By: Microsoft


Pricing for this product is available on request. Please click the "Call me" button to request a call back.

Our Part #: 989464 | Availability:  delivered via Email | Media: Electronic

Description
New Features
Licensing
Editions

SQL Server 2016 is the foundation of Microsoft’s data strategy, encompassing innovations that transform data into intelligent action. With this new release, Microsoft is delivering an end-to-end data management and business analytics solution with mission critical intelligence for your most demanding applications as well as insights on your data on any device.

SQL Server 2016 has been enhanced to deliver mission-critical capabilities in Scalability, Performance, and availability for important Online Transaction

Processing (OLTP) and Data Warehousing workloads, with;

- Scalability of up to 12TB of Memory and 640 Logical Processors with Windows Server 2016
- Up to 30x faster transactions and 100x faster queries with enhanced In-Memory Performance
- Real-time Operational Analytics over Transactional Data
- Balance Load capabilities across Readable Secondaries in ‘Always-On’ Availability Groups
- Data Protection at rest and in motion with Transparent Data Encryption (TDE) and new ‘Always-Encrypted’
- Sensitive data marking, with minimal application impact, using Dynamic Data Masking
- Grant user access based characteristics, using Row Level Security
- Faster SQL Server Analysis Services performance with Parallel Processing
- Enhanced Multi-Dimensional Models in SQL Server Analysis Services
- Integration with Visual Studio 2015 using SQL Server Data Tools
- Complex data transformation, from multiple sources, into Trusted Data Models, using the Statistic Modelling Language
- In-Place Analytics
- Write-Once-Deploy-Everywhere approach, ‘In-Database’, to the cloud, or to Linux, Hadoop and Teradata
- Thousands of R-Scripts and Models in the Common R Archival Network (CRAN), made readily available
- Dynamically stretch Warm and Cold state Data, to Azure, using Stretch Database
- High VM Capacity capability for Mission-Critical workloads
- Utilize existing coding techniques with T-SQL Everywhere, Common Development and Management Tools.

SQL Server 2016 brings greater performance, greater management, greater coexistence and greater flexibility than ever before. In the new offering of SQL, enhancements and added functionality have been brought forward to enhance business productivity and scalability. Below are some of the new and/or enhanced features;

Express

- 4 cores maximum
- Programmability and Developer Tools (T-SQL, CLR, Data Types, FileTable, JSON)
- Basic 'R' integration (connectivity to R Open, limited parallelism for RRE)

-- Applies to Standard, Enterprise and Developer.

Standard - additive over previous edition

- 24 core maximum
- Basic high availability (2-node single database failover, non-readable secondary)
- Basic security (row-level security, data masking, basic auditing and separation of duties)
- Basic Corporate Business Intelligence (multi-dimensional models, basic tabular model)
- Stretch database

-- Applies to Standard, Enterprise and Developer

Enterprise/Developer - additive over previous edition

- Unlimited cores
- Advanced OLTP (in-memory OLTP, operational analytics)
- Advanced security (Transparent Data Encryption, Always Encrypted)
- Data warehousing (In-Memory ColumnStore, partitioning)
- Mobile Business Intelligence (Datazen)
- Advanced 'R' integration (full parallelism for RRE)

Licensing SQL Server 2016 can be complex. We can help you determine which edition and licensing model is appropriate for you, for advice please contact us.

SQL Server 2016 adds and improves upon existing functionality found in existing SQL Server offering. SQL Server 2016 is now offered in four main editions. Below are some of the features that can be found in the new editions;

Note: Business Intelligence has now been retired. Existing Business Intelligence customers, with Active Software Assurance, are entitled to migrate to the Enterprise Edition on a Server/CAL model. The Web edition still remains available only on SPLA. Call us for more details.

Express Edition

SQL Server Express is a free edition of SQL Server which is ideal for development and production for desktop, web and small server applications. The following features can be found in this edition;

- 1GB memory (10GB memory maximum)
- Basic OLTP
- Query Store
- Temporal
- Policy-based management
- Support for JSON
- Basic reporting and analytics
- Web portal experience
- Modernised reports
- Stretch database
- Backup to Azure

Standard Edition

SQL Server Standard provides Core Data Management and Business Intelligence capabilities for non-critical workloads with minimal IT resources. The following capabilities can be found in this edition;

Mission Critical

- Disk-based Online Transaction Processing (OLTP)
- 24 cores (maximum) and 128GB memory (maximum)
- 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
- Modernised reports
- Pin reports to Power BI
- Enhanced multi-dimensional models

Advanced Analytics

- Single-threaded for Revolution R Enterprise
- Connectivity to R Open

Hybrid Cloud

- Stretch Database
- Backup to Azure

Enterprise Edition

SQL Server Enterprise delivers comprehensive Datacenter capabilities for mission-critical database, Business Intelligence and Advanced Analytics workloads. The following enhanced, and additive, capabilities (over Standard) can be found in this edition;

Mission Critical

- Unlimited cores and operating systems maximum memory
- Enhanced in-memory OLTP performance
- Operational analytics
- Enhanced Always On with no-domain join (Windows Server 2016)
- Query Store
- Temporal

Security

- Always Encrypted
- Row-level security
- Dynamic data masking
- Enhanced seperation of duties
- Enhanced SQL Server auditing
- Transparent data encryption
- Policy-based management

Data Warehousing

- Enhanced in-memory ColumnStore
- PolyBase in scale-out configuration (head and compute nodes)
- Licence rights to (the Analytics Platform System) Massively Parallel Processing appliance
- Distributed query processing
- Support for JSON

Business Intelligence

- End-to-end Mobile BI on all major platforms
- Enhanced direct query
- In-memory analytics
- Advanced data mining
- Advanced tabular
- Web portal experience (all reports in one place)
- Modernised reports
- Pin reports to Power BI
- Enhanced multi-dimensional models

Advanced Analytics

- In-database advanced analytics
- R integration with Massive Parallel Processing for performance and scale
- Works with in-memory technology
- Run in database or standalone
- Connectivity to R Open

Hybrid Cloud

- Stretch database
- Enhanced backup to Azure
- Enhanced High Availability and Disaster Recovery with Azure - ease of use, no domain join (Windows Server 2016)
- SQL Server Integration Services (SSIS) with Azure Data Factory and Azure SQL Data Warehouse

Developer Edition

SQL Server Developer is a free edition providing the full feature set of SQL Server Enterprise, but for development and testing only. This is not permitted to be used in a production environment, or to be used with production data. The following features can be found in this edition;

- Unlimited cores and operating systems maximum memory
- Operating system maximum memory, utilised per instance

Shopping Basket
    0 Item(s)
    Total:
    0.00


    View and amend your basket
         
    Parallels
    Microsoft Cloud Pricing