SQL_Server_2016_Deeper_Insights_Across_Data_White_Paper.pdf

(1777 KB) Pobierz
Deeper insights across data
with SQL Server 2016
Technical white paper
Published June 2016
Copyright
The information contained in this document represents the current view of Microsoft Corporation on the issues
discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should
not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of
any information presented after the date of publication.
This white paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED, OR
STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under
copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval system, or
transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for
any purpose, without the express written permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights
covering subject matter in this document. Except as expressly provided in any written license agreement from
Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights,
or other intellectual property.
© 2016 Microsoft Corporation. All rights reserved.
Microsoft, Microsoft Azure, SQL Server, Visual Studio, Windows, and Windows PowerShell are trademarks of the
Microsoft group of companies.
All other trademarks are property of their respective owners.
Deeper insights across data with SQL Server 2016 |
2
Contents
Introduction .................................................................................................................................................................. 4
Microsoft SQL Server evolution ............................................................................................................................. 4
SQL Server 2016 new data management enhancements ............................................................................ 5
Deeper insights across data with SQL Server ................................................................................................... 6
Store your data and make it accessible ........................................................................................................................... 6
PolyBase ........................................................................................................................................................................................................ 7
Azure HDInsight ......................................................................................................................................................................................... 8
Data warehousing ...................................................................................................................................................................................... 8
Azure Data Factory ..................................................................................................................................................................................10
Integration services .................................................................................................................................................................................11
Hybrid data storage ................................................................................................................................................................................11
Data connectors .......................................................................................................................................................................................11
Unstructured data....................................................................................................................................................................................11
Built-in JSON support ............................................................................................................................................................................12
Master Data Services ..............................................................................................................................................................................12
Analyze your data ................................................................................................................................................................... 13
Real-time operational analytics ..........................................................................................................................................................13
Analysis Services.......................................................................................................................................................................................14
SQL Server Analysis Services tabular models ...............................................................................................................................15
SQL Server R Services .............................................................................................................................................................................17
Deliver insights to more people with Reporting Services ....................................................................................... 19
Modern paginated reports...................................................................................................................................................................20
Responsive mobile reports ..................................................................................................................................................................21
A modern web portal to view all your reports .............................................................................................................................21
Hybrid BI .................................................................................................................................................................................... 22
Pin SSRS report items to Power BI dashboards ...........................................................................................................................22
Power BI gateways ..................................................................................................................................................................................23
Conclusion ................................................................................................................................................................... 24
Deeper insights across data with SQL Server 2016 |
3
Introduction
Today, data comes from relational and non-relational sources, from on-premises environments and the cloud, and
from big data and other sources. Microsoft SQL Server 2016 offers solutions designed to:
Store data in more formats using scalable technologies
Make data more accessible to developers and users
Provide the services to analyze your data in highly performing, prescriptive, and predictive ways
Share your insights across organizations to users—on-premises, via the web, or through mobile devices
Microsoft SQL Server evolution
The growing volume, velocity, diversity, and locations of enterprise data make it increasingly challenging to
discover, connect to, move, transform, integrate, and analyze it all. In fact, with the compound annual growth rate
of data from 2013 to 2020 estimated at 41 percent
1
, this can be termed a data explosion. This is the result of more
and more devices combined with a new hunger from businesses for more data to better understand and predict
customer needs to make smarter decisions with data.
Yet, without the ability to analyze it, data loses its value. Microsoft SQL Server and the related Microsoft data
platform can deliver the tools you need to gain deeper insights from all of your data. Microsoft customers and
industry analysts agree that SQL Server is a top leader in these efforts (Figures 1 and 2).
Figure 1: Microsoft positioned as leader in Gartner Magic Quadrant for operational database management systems
1
IDC, “Digital Universe,” December 2012.
Deeper insights across data with SQL Server 2016 |
4
Figure 2: Gartner Magic Quadrant for business intelligence and analytics platforms
SQL Server 2016 new data management
enhancements
SQL Server has evolved along with the explosion in data sources and continues to innovate to facilitate data
management (Figure 3).
Figure 3: Major SQL Server functionalities added across releases
Deeper insights across data with SQL Server 2016 |
5

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin