Introducing
Faster
Microsoft Data
Warehouse Fast
deployment
Track for SQL
Reduced
risk
Server 2016
November 11, 2016
Value
Flexibility
and choice
,Contents
1. SQL Server 2016: The Microsoft Data Warehouse Platform Is
Built in
2. SQL Server 2016: Everything Built in
4. The Microsoft Big Data and Data Warehousing Portfolio
5. Options for On-premises Solutions
6. Data Warehouse Fast Track Program
7. Data Warehouse Fast Track Advantages
9. Improved Hardware and Storage Options for
SQL Server 2016
10. In-memory Performance Improvements
11. Fast Track Evaluation Process
12. Appendix A: SQL Server 2016, Most Secure Server Ever
14. Appendix B: Make Smarter Decisions Faster: In-memory
Built in
15. Appendix C: Resource Changes for Data Warehouse Fast
Track, SQL Server 2014 to 2016
15. Appendix D: Accelerating Large-scale Business Analytics
Using a 100TB Dataset Powered by the Intel® Xeon®
Processor E7 Family and Microsoft SQL Server 2016
16. Appendix E: What’s New About SQL Server 2016
Columnstore Technology?
© 2016 Microsoft Corporation. All rights
reserved. This document is for informational
purposes only. Microsoft makes no warranties
express or implied, with respect to the information
presented here.
Microsoft Data Warehouse Fast Track for SQL Server 2016
, SQL Server Organizations positioned to use data to support strategic business
decisions will be more successful than those that lag in their use of
2016: The data1. Microsoft Data Warehouse Fast Track for SQL Server 2016 is
an advanced data platform reference architecture that works with
Microsoft Data breakthrough hardware improvements to deliver superior
Warehouse
performance — both on premises and in the cloud — and help
position your organization to use data more effectively. With speed,
platform that scalability, and agility, SQL Server 2016 enables customers to break
free from vendor lock-in and drive business transformation.
has everything Benchmark testing results tell the performance story: SQL Server 2016
built-in offers up to 40 percent improvement in query performance over SQL
Server 2014. TPC benchmarks that were run on data sets up to 145 TB
demonstrate that you can achieve superlative performance on
increasingly less-expensive industry-standard hardware. Current
benchmarks are testing in the 150-200 TB range; improved results are
expected soon2.
SQL Server 2016 data warehouse capabilities build on this high-
performance foundation to power solutions that span the range of
requirements from small to massive. For organizations that want to get
started with a data warehouse, the SQL Server 2016 Data Warehouse
Fast Track program enables customers to work with Microsoft partners
to deploy a customized, prebuilt data warehouse solution on the trusted
Microsoft data platform. For larger data warehouse needs, Microsoft
offers a Massively Parallel Processing (MPP) appliance that can scale
from tens of terabytes up to multiple petabytes when incremental nodes
are added to existing infrastructure.
As a company focused on enabling business intelligence (BI), Microsoft
provides a trusted SQL Server 2016 infrastructure that gives you
confidence and consistency and enables you to incorporate a wider
variety of data sources, including mobile, social, scanners, photos,
videos, sensors, devices, RFID, web logs, advanced analytics, click
streams, machine learning, and third-party data sources.
Building on such advanced capabilities, the SQL Server 2016 Data
Warehouse Fast Track platform lets you query both traditional relational
data and new data types with common T-SQL commands by using
1
The Digital Business Divide, Keystone Research https://www.microsoft.com/en-us/cloud-
platform/data-maturity-model-assessment
2
TCP™ performance results:
http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster&version=2%&am
p;currencyID=0
Microsoft SQL Server 2016 Data Warehouse Fast Track 1
Faster
Microsoft Data
Warehouse Fast
deployment
Track for SQL
Reduced
risk
Server 2016
November 11, 2016
Value
Flexibility
and choice
,Contents
1. SQL Server 2016: The Microsoft Data Warehouse Platform Is
Built in
2. SQL Server 2016: Everything Built in
4. The Microsoft Big Data and Data Warehousing Portfolio
5. Options for On-premises Solutions
6. Data Warehouse Fast Track Program
7. Data Warehouse Fast Track Advantages
9. Improved Hardware and Storage Options for
SQL Server 2016
10. In-memory Performance Improvements
11. Fast Track Evaluation Process
12. Appendix A: SQL Server 2016, Most Secure Server Ever
14. Appendix B: Make Smarter Decisions Faster: In-memory
Built in
15. Appendix C: Resource Changes for Data Warehouse Fast
Track, SQL Server 2014 to 2016
15. Appendix D: Accelerating Large-scale Business Analytics
Using a 100TB Dataset Powered by the Intel® Xeon®
Processor E7 Family and Microsoft SQL Server 2016
16. Appendix E: What’s New About SQL Server 2016
Columnstore Technology?
© 2016 Microsoft Corporation. All rights
reserved. This document is for informational
purposes only. Microsoft makes no warranties
express or implied, with respect to the information
presented here.
Microsoft Data Warehouse Fast Track for SQL Server 2016
, SQL Server Organizations positioned to use data to support strategic business
decisions will be more successful than those that lag in their use of
2016: The data1. Microsoft Data Warehouse Fast Track for SQL Server 2016 is
an advanced data platform reference architecture that works with
Microsoft Data breakthrough hardware improvements to deliver superior
Warehouse
performance — both on premises and in the cloud — and help
position your organization to use data more effectively. With speed,
platform that scalability, and agility, SQL Server 2016 enables customers to break
free from vendor lock-in and drive business transformation.
has everything Benchmark testing results tell the performance story: SQL Server 2016
built-in offers up to 40 percent improvement in query performance over SQL
Server 2014. TPC benchmarks that were run on data sets up to 145 TB
demonstrate that you can achieve superlative performance on
increasingly less-expensive industry-standard hardware. Current
benchmarks are testing in the 150-200 TB range; improved results are
expected soon2.
SQL Server 2016 data warehouse capabilities build on this high-
performance foundation to power solutions that span the range of
requirements from small to massive. For organizations that want to get
started with a data warehouse, the SQL Server 2016 Data Warehouse
Fast Track program enables customers to work with Microsoft partners
to deploy a customized, prebuilt data warehouse solution on the trusted
Microsoft data platform. For larger data warehouse needs, Microsoft
offers a Massively Parallel Processing (MPP) appliance that can scale
from tens of terabytes up to multiple petabytes when incremental nodes
are added to existing infrastructure.
As a company focused on enabling business intelligence (BI), Microsoft
provides a trusted SQL Server 2016 infrastructure that gives you
confidence and consistency and enables you to incorporate a wider
variety of data sources, including mobile, social, scanners, photos,
videos, sensors, devices, RFID, web logs, advanced analytics, click
streams, machine learning, and third-party data sources.
Building on such advanced capabilities, the SQL Server 2016 Data
Warehouse Fast Track platform lets you query both traditional relational
data and new data types with common T-SQL commands by using
1
The Digital Business Divide, Keystone Research https://www.microsoft.com/en-us/cloud-
platform/data-maturity-model-assessment
2
TCP™ performance results:
http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster&version=2%&am
p;currencyID=0
Microsoft SQL Server 2016 Data Warehouse Fast Track 1
