Downloaded 219 times
Uploaded byDavid J Rosenthal
Introducing Microsoft SQL Server 2017
This document summarizes the key features and capabilities of SQL Server 2017. It highlights that SQL Server 2017 runs on Linux and Docker in addition to Windows, supports graph queries and advanced machine learning with R and Python, and features adaptive query processing for improved performance. The document also discusses SQL Server 2017's abilities around data management, analytics, security, and its role in enabling hybrid cloud solutions with Microsoft Azure.
Introducing Microsoft SQL Server 2017
- 1. SQL Server 2017 Poweryour entire data estate from on-premises to cloud
- 2. Widely available unstructured data Deliverpowerful insights over big data Massive data growth Build data into all your apps 50ZB 1010 0101 0010 { } Analytics driving digital transformation Modernize your apps with built-in analytics New opportunities in a changing data landscape
- 3. 67 Years 25 Years 15 Years 1920 1930 19401950 1960 1970 1980 1990 2000 2010's 2020's The time to adapt to disruption is shrinking Source: BBC A hundred years ago, the average lifespan of a company listed on the S&P 500 index was 67 years In the 2020s, 75% of the S&P 500 will be new companies
- 5. Business leaders are focused on disruption Enablebusiness agility Re-imagine business processes Disrupt with new business models Differentiate with customer experience
- 6. Securing and integrating manydatabase systems Investing to modernize legacy applications Delivering on increasing performance/price demands Providing predictive analytics But harnessing technology to disrupt isn’t easy
- 7. SQL Server POWERING YOURDATA ESTATE
- 8. SQL Server 2016 Anindustry leader four years in a row Most secure database over the last 7 years Highest performing data warehouse End-to-end mobile BI at a fraction of the cost In-database Advanced Analytics This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request. Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. Everything Built-in
- 9. Most secure databaseover the last 7 years Highest performing data warehouse End-to-end mobile BI at a fraction of the cost In-database Advanced Analytics 0 20 40 60 80 100 120 140 160 180 200 Vulnerabilities(2010-2016) An industry leader four years in a row SQL Server 2016Everything Built-in
- 10. Most secure databaseover the last 7 years Highest performing data warehouse End-to-end mobile BI at a fraction of the cost In-database Advanced Analytics non-clustered results An industry leader four years in a row #1 SQL Server 2016Everything Built-in
- 11. Most secure databaseover the last 7 years Highest performing data warehouse End-to-end mobile BI at a fraction of the cost In-database Advanced Analytics An industry leader four years in a row SQL Server 2016Everything Built-in
- 12. Highest performing datawarehouse End-to-end mobile BI at a fraction of the cost In-database Advanced Analytics 1 Million PREDICTIONS/SEC An industry leader four years in a row Most secure database over the last 7 years SQL Server 2016Everything Built-in
- 13. Real-time operational analytics without impactingperformance Only data solution to encrypt your data at rest and in motion Connect your relational data to big data with PolyBase Faster transactions, faster queries with In-memory* Unparalleled choice for developer tools and languages 1 Innovations for all your applications Single programming model across editions Available now SQL Server 2016 SP1 T-SQL Java C/C++ C#/VB.NET PHP Node.js Python Ruby *Compute and memory available to in-memory technologies scales across editions
- 14. Standard Enterprise Maximum numberof cores 24 cores Unlimited Maximum memory utilized per instance 128 GB OS Max Maximum size 524 PB 524 PB Basic high availability (2-node single database failover, non-readable secondary) Enterprise data management (Master Data Services, Data Quality Services) Advanced OLTP (In-memory OLTP, Operational analytics)* New Advanced HA (Always On - multi-node, multi-db failover, readable secondaries) Security (Always Encrypted, row-level security, data masking, fine-grained auditing, separation of duties) New Transparent Data Encryption Fuzzy grouping and look ups Data warehousing (In-Memory ColumnStore*, partitioning, data compression, change data capture, database snapshot) New Basic data integration (SSIS, built-in connectors) Basic Corporate Business Intelligence (Multi-dimensional models, Basic tabular model) Mobile BI (Datazen) Advanced Corporate Business Intelligence (Advanced tabular model, Direct query, in-memory analytics, advanced data mining) Basic “R” integration (Connectivity to R Open, Limited parallelism for RRE) Advanced “R” integration (Full parallelism for RRE) Stretch Database Programmability (T-SQL, CLR, Service Broker, JSON, XML) SQL Server 2016 SP1 features by edition * Memory core and limitations for SE
- 15. Mission critical availability Maximum virtualization with SA Performance atscale Scales for your business needs SQL Server Enterprise continues to deliver performance and availability for Enterprise workloads
- 16. SQL Server 2017 Runon Linux & Docker Support for Graph queries to analyze complex relationships Advanced Machine Learning with R & Python Adaptive query processing learns & optimizes for unparalleled performance SQL Server 2017 Announcing
- 17. OLTP DW BIAnalytics
- 18.
- 19. • Linux distributionsincluding RedHat Enterprise Linux (RHEL), Ubuntu, and SUSE Enterprise Linux (SLES) • Docker: Windows & Linux containers • Windows Server / Windows 10 • Package-based installation, Yum Install, Apt-Get, and Zypper Power of SQL Server on the platform of your choice Linux Linux/Windows container Windows FLEXIBILITY
- 20. • Bring graphdata NEW* support to your relational data to store and analyze new types of relationships • Query data stored in Hadoop with PolyBase • Hadoop combined with SQL Server provides value and insight from data lakes The power to query over any type of data DATA SOURCES Graph data support Quarterly business review Andy Smith Mary Jones Denny Usher Bill Brown Rachel Hogan Product dev project IT assessment Eric Mears Michelle Burns HR team can determine which staff are working on which projectsProjects Managers Associates
- 21. Industry-leading performance withSQL Server 2017 DATA MANAGEMENT // OPERATIONAL DATA • Improve transactional performance with row-based in-memory OLTP • Speed analytics and reduce storage needs with ColumnStore compression • Combine for real-time operational analytics (HTAP) • Speed query performance without tuning using new Adaptive Query Processing NEW* • Maintain performance when making app changes with Automatic Plan Correction NEW* 0100101010110 In-memory ColumnStore In-memory OLTP ETL Real-time operational analytics with hybrid transactional-analytical processing (HTAP) Challenge to manage massive credit card data Pair active data with In-Memory OLTP table for quick access Speed performance by compressing data in In- memory Columnstore Faster queries and processing enables real- time detection of errors
- 22. • In-database analyticswith R and now Python NEW* enables users to push intelligence to where data lives • Parallelized and at scale • Industry-leading innovation in artificial intelligence to discover insights faster • Advanced machine learning algorithms with GPUs Real-time intelligence with machine learning built-in DATA INSIGHTS // ADVANCED ANALYTICS In-database analytics with R and Python Store Predictions In-memory OLTP ColumnStore Power BI dashboard R Business user Prepare for analytics Visualize Data from 8M vehicle loans Predicts loan defaults Age, original balance, interest rate, loan remaining months, credit score 1M predictions per sec Python
- 23. • Most secureplatform, with the least vulnerabilities in the NIST vulnerability database • Encrypt data at rest and in motion with Always Encrypted on new driver libraries • Conceal sensitive information with Dynamic Data Masking • Control access to database rows based on user characteristics with Row-Level Security • File-level protection with Transparent Data Encryption Protect your data at all times on Windows and Linux SECURITY Always Encrypted Query Client side Server side Data set Enhanced SQL Server Library CIPHERTEXT Search for single customer record Sensitive data remains encrypted inside SQL Server Result set with unencrypted data Column master key Column encryption key Customer Credit card # Exp. Denny Usher 0x7ff654ae6d 5/174949-8003-8473-1930 Customer Credit card # Exp. Tim Irish 4839-2939-1919-3987 7/19 Denny Usher 4949-8003-8473-1930 5/17 Alicia Hodge 9000-4899-1600-1324 4/18 Credit card # 1x7fg655se2e 0x7ff654ae6d 0y8fj754ea2c
- 24. Always On newhybrid HA scenario • Always On Groups for Linux NEW* and Windows for HA and DR • Flexibility for HA architectures NEW* • Ultimate HA with OS-level redundancy and failover • Load balancing of readable secondaries Mission critical HA on any platform DATA MANAGEMENT // OPERATIONAL DATA • High Availability • Offload Backups • Scale BI Reporting • Enables Testing • Enables Migrations
- 25. The SQL Serverand Azure data estate combined Business intelligence Advanced Analytics & AI Any language, any platform, anywhere Least vulnerable data platform, with more certifications than any other cloud provider Structured Unstructured OLTP MOBILE ERP LOB Graph Social IoT Media DATA SOURCES DATA INSIGHTS DatavirtualizationPolyBase DATA MANAGEMENT DataintegrationSSIS Big data processing Data warehousing Operational data SECURITY FLEXIBILITY .NET Azure 3rd JAVA Power BI Embedded Azure Machine Learning Azure Stream Analytics Azure Cognitive Services SQL Server Reporting Services and Mobile BI SQL Server Analysis Services and R built- in Azure HDInsight Azure SQL Data Warehouse Azure Data Lake Azure Document DB Azure SQL Database SQL Server SQL Server Data Warehouse Apache Hadoop ON-PREM CLOUD
- 26.
- 27. Empower intelligent appswith Microsoft — no matter how you plug in Secure your data and apps with built-in tools Scale apps globally on hybrid platforms or in the cloud Scale costs with performance and optimize your apps Intelligent Trusted Flexible Migrating the app Managing the infrastructure Building the app Modernizing the app
- 28. Contact us foradditional information & deployment offers David.Rosenthal@razor-tech.com