Presentation
Introducing Microsoft Data Warehouse Fast Track for SQL Server 2016 November
- Course
- Institution
Introducing Microsoft Data Warehouse Fast Track for SQL Server 2016 November
[Show more]
Seller
Follow
madelanent
Content preview
IntroducingFaster
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller madelanent. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $0.00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53340 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now