SQL Server 2016

As of April 12, Microsoft no longer supports SQL Server 2005. This means no more security patches or compatibility enhancements to keep your data safe. Now is a great time to modernize your database. Avoid unnecessary security or compliance risks and ensure continued compatibility by upgrading to SQL Server 2016. 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.

Contact an SQL Server Expert – 800.800.4239

Browse through our top-selling licenses at CDW

How CDW Can Help

Microsoft SQL Server Upgrade Assessment

Unsure where to begin? That’s where CDW comes in. We will assess your current environment, find any upgrade issues and provide recommendations on how to start your migration. Our assessment will help you mitigate risks due to incompatibility issues, reduce downtime and improve your overall upgrade process.

View Assessment Details

Microsoft SQL 2005 Migration Service

This migration service allows CDW to help you throughout every step, from planning and design to migration and deployment. We will audit your current environment, prioritize requirements, provide deployment options, install and configure SQL Server 2016, and assist in data migration. Let us do all the leg work to ensure your data's safe.

View Migration Details

New Features and Functionality

Scalability. Performance. Availability.

SQL Server delivers breakthrough mission-critical capabilities. It keeps your most important OLTP and data warehousing workloads available when you need them.

Scale up to 12 TB of memory and 640 logical processors with Windows Server 2016
Reach up to 30x faster transactions and 100x faster queries with enhanced in-memory performance
Run real-time Operational Analytics over transactional data
Balance loads across readable secondaries in Always On availability groups

Multi-layered Security

SQL Server’s multi-layered approach to security has a proven track record of protecting your database and thwarting vulnerability. For 6 years in a row, SQL Server has been the database with the least vulnerabilities of any major platform. Keep your data safe with the following functionality benefits below.

Protect data at rest and in motion with TDE and new Always Encrypted
Mask sensitive data with minimal application impact using Dynamic Data Masking
Grant access based on user characteristics with Row Level Security

Enterprise-ready Business Intelligence

Transform your complex data seamlessly with SQL Server 2016. Its comprehensive, on-premise BI platform provides actionable insights.

Create modern reports and visualize dense data with additional chart types
Access KPIs and mobile and paginated reports using the SQL Server Reporting Services web portal
Get faster SQL Server Analysis Services performance with parallel processing
Use enhanced multidimensional models in SQL Server Analysis Services
Easily set up SQL Server Data Tools Preview in Visual Studio 2015

Built-in Analytics

Build and run your own advanced analytics algorithms directly in the core of SQL Server’s transactional database. Get the scalability and performance you need to understand your data.

Transform complex data from multiple sources into trusted data models using the most popular statistical modelling language
Process analytics in-place, reducing latencies and operational costs
Write models once and deploy anywhere: in-database, to the cloud, or to Linux, Hadoop and Teradata
Access thousands of R Scripts and Models in CRAN (Common R Archival Network)

Consistency

SQL Server 2016 delivers a consistent experience for both on-premises and cloud. You get an exceptional experience whether data is in your data center, in a private cloud or on Azure.

Dynamically stretch warm and cold data to Azure with Stretch Database
Tackle your mission-critical workloads with larger Azure virtual machine sizes
Rely on our cloud-first features, tested by millions of Azure databases
Use the skills you already have with common development and management tools and common T-SQL everywhere