FND1551: The SQL Server Evolution

Everything you want to know about next-generation SQL Server, mission critical performance and scale for transactional, data warehouse and mixed workloads, structured and unstructured data, security innovations, availability and reliability improvements, advanced analytics, business intelligence, world class scale on-prem and to the cloud.

1.0x

FND1551: The SQL Server Evolution

Created 2 years ago

Duration 1:16:00
lesson view count 13750
Everything you want to know about next-generation SQL Server, mission critical performance and scale for transactional, data warehouse and mixed workloads, structured and unstructured data, security innovations, availability and reliability improvements, advanced analytics, business intelligence, world class scale on-prem and to the cloud.
Select the file type you wish to download
Slide Content
  1. Slide 1

    • SQL Server Evolution
    • New innovations
    • Shawn Bice
    • Engineering Partner Director
  2. Slide 2

    • VISUALIZE + DECIDE
    • Mobile
    • Reports
    • Natural language
    • query
    • Dashboards
    • Applications
    • Streaming
    • CAPTURE + MANAGE
    • Relational
    • Internal & external
    • Non-relational
    • NoSQL
    • { }
    • TRANSFORM + ANALYZE
    • Orchestration
    • Machine learning
    • Modeling
    • Information management
    • Complex event processing
    • Data
    • TRANSFORM + ANALYZE
    • VISUALIZE + DECIDE
    • CAPTURE + MANAGE
    • The Microsoft data platform
  3. Cloud first

    Slide 3 - Cloud first

    • Speed
    • Agility
    • Proven
    • Feedback
  4. All of this results in a better on-premises SQL Server

    Slide 4 - All of this results in a better on-premises SQL Server

    • Announcing
    • SQL Server 2016
    • Mission critical performance
    • Deeper insights across data
    • Hyperscale cloud
  5. Mission critical performance

    Slide 5 - Mission critical performance

    • Do more. Achieve more.
    • Hyperscale cloud
    • Deeper insights across data
  6. Slide 6

    • 0100101010110
    • SQL Server OLTP
    • SQL Serverdata warehouse
    • ETL
    • In-memory ColumnStore
    • In-memory OLTP
    • Real-time frauddetection
    • In-memory enhancementsOperational analytics & enhanced performance
    • Capability
    • In-memory Columnar index over in-memory/disk based OLTP tablesEnhanced OLTP T-SQL surface areaScale to higher compute and memory
    • Benefits
    • Unlike competition, you gain operational analytics & 30x faster transactions & 100x queries
    • In-memory for more of your applications
    • Mission critical performance
    • Fraud detected
    • 2-24
    • hrs
  7. Slide 7

    • Demo
    • Rohan Kumar
  8. Slide 8

    • dbo.Patients
    • Jane Doe
    • Name
    • 243-24-9812
    • SSN
    • USA
    • Country
    • Jim Gray
    • 198-33-0987
    • USA
    • John Smith
    • 123-82-1095
    • USA
    • dbo.Patients
    • Jane Doe
    • Name
    • 1x7fg655se2e
    • SSN
    • USA
    • Jim Gray
    • 0x7ff654ae6d
    • USA
    • John Smith
    • 0y8fj754ea2c
    • USA
    • Country
    • Result Set
    • Jim Gray
    • Name
    • Jane Doe
    • Name
    • 1x7fg655se2e
    • SSN
    • USA
    • Country
    • Jim Gray
    • 0x7ff654ae6d
    • USA
    • John Smith
    • 0y8fj754ea2c
    • USA
    • dbo.Patients
    • Mission critical performance
    • SQL Server
    • ciphertext
    • Query
    • Always EncryptedHelp protect data at rest and in motion, on-premises & cloud
    • Trusted
    • Apps
    • SELECT Name FROM Patients WHERE SSN=@SSN
    • @SSN='198-33-0987'
    • Result Set
    • Jim Gray
    • Name
    • SELECT Name FROM Patients WHERE SSN=@SSN
    • @SSN=0x7ff654ae6d
    • Column EncryptionKey
    • EnhancedADO.NET
    • Library
    • Column
    • MasterKey
    • Client side
  9. Slide 9

    • Demo
    • Rohan Kumar
  10. Slide 10

    • Mission critical performance
    • Performance
    • Operational analytics
    • In-memory OLTP for more applications
    • Query data store
    • Native JSON
    • Temporal database support
    • Security
    • Always Encrypted
    • Row Level Security
    • Dynamic Data Masking
    • Availability
    • Enhanced AlwaysOn
    • 3 synchronous replicas for auto failover across domains
    • Round robin load balancing of replicas
    • DTC for transactional integrity across database instances with AlwaysOn
    • Enhanced online operations
    • Scalability
    • Enhanced database caching
    • Support for Windows Server 2016
    • 12 TB memory support
  11. Do more. Achieve more.

    Slide 11 - Do more. Achieve more.

    • Deeper insights across data
    • Mission critical performance
    • Hyperscale cloud
  12. Slide 12

    • PolyBaseQuery relational and non-relational data with T-SQL
    • Deeper insights across data
    • T-SQL query
    • Capability
    • T-SQL for querying relational and non-relational data across SQL Server and Hadoop
    • Benefits
    • New business insights across your data lake
    • Leverage existing skillsets and BI tools
    • Faster time to insights and simplified ETL process
    • SQL Server
    • Hadoop
    • Quote:
    • ************************
    • **********************
    • *********************
    • **********************
    • ***********************
    • $658.39
    • Jim Gray
    • Name
    • 11/13/58
    • DOB
    • WA
    • State
    • Ann Smith
    • 04/29/76
    • ME
  13. Slide 13

    • Deeper insights across data
    • Data Scientist
    • Interact directly with data
    • Built-in to SQL Server
    • Data Developer/DBA
    • Manage data and
    • analytics together
    • Built-in advanced analyticsIn-database analytics at massive scale
    • Example Solutions
    • Sales forecasting
    • Warehouse efficiency
    • Predictive maintenance
    • Relational Data
    • Analytic Library
    • T-SQL Interface
    • Extensibility
    • ?
    • R
    • R Integration
    • 010010
    • 100100
    • 010101
    • Microsoft Azure
    • Marketplace
    • New R scripts
    • 010010
    • 100100
    • 010101
    • 010010
    • 100100
    • 010101
    • 010010
    • 100100
    • 010101
    • 010010
    • 100100
    • 010101
    • 010010
    • 100100
    • 010101
    • Credit risk protection
  14. Rich visualizations on mobile devices

    Slide 14 - Rich visualizations on mobile devices

    • Capabilities
    • Business insights through rich visualizations on any device. Native apps for Windows, iOS and Android
    • Benefits
    • Access your data from anywhere
    • Touch optimized data exploration and perfect scaling to any screen form-factor
    • Collaborate with colleagues on the go
    • Security and mobility
  15. Slide 15

    • Demo
    • Yvonne Haarloev
  16. Slide 16

    • Deeper insights across data
    • Access any data
    • PolyBase
    • Power Query for analytics and reporting
    • Enhanced SSIS
    • Designer support for previous SSIS versions
    • Support for Power Query
    • Scale and manage
    • Enterprise-grade Analysis Services
    • New single SSDT in Visual Studio 2015
    • Enhanced MDS
    • Excel add-in 15x faster
    • More granular security roles
    • Archival options for transaction logs
    • Reuse entities across models
    • Powerful insights
    • Built-in advanced analytics
    • Business insights through rich visualizations on mobile devices
    • Enhanced Reporting Services
  17. Do more. Achieve more.

    Slide 17 - Do more. Achieve more.

    • Mission critical performance
    • Deeper insights across data
    • Hyperscale cloud
  18. Order history

    Slide 18 - Order history

    • Name
    • SSN
    • Date
    • Jane Doe
    • cm61ba906fd
    • 2/28/2005
    • Jim Gray
    • ox7ff654ae6d
    • 3/18/2005
    • John Smith
    • i2y36cg776rg
    • 4/10/2005
    • Bill Brown
    • nx290pldo90l
    • 4/27/2005
    • Sue Daniels
    • ypo85ba616rj
    • 5/12/2005
    • Sarah Jones
    • bns51ra806fd
    • 5/22/2005
    • Jake Marks
    • mci12hh906fj
    • 6/07/2005
    • Eric Mears
    • utb76b916gi
    • 6/18/2014
    • Rachel Hogan
    • px61hi9306fj
    • 7/1/2014
    • Sam Johnson
    • ol43bi506gd
    • 7/12/2014
    • David Simon
    • tx83hal916fi
    • 7/29/2014
    • Michelle Burns
    • nb95re926gi
    • 8/10/2014
    • Reed Dean
    • vc61ira536fe
    • 8/23/2014
    • Order history
    • Name
    • SSN
    • Date
    • Jane Doe
    • cm61ba906fd
    • 2/28/2005
    • Jim Gray
    • ox7ff654ae6d
    • 3/18/2005
    • John Smith
    • i2y36cg776rg
    • 4/10/2005
    • Bill Brown
    • nx290pldo90l
    • 4/27/2005
    • Customer data
    • Product data
    • Order History
    • Stretch to cloud
    • Stretch SQL Server into AzureStretch warm and cold tables to Azure with remote query processing
    • Capability
    • Stretch cold database tables from on-premises SQL Server Databases to Azure with remote query processing
    • Benefits
    • Cost effective historical data
    • Entire table is online and remains queryable from on-premises apps
    • Transparent to applications
    • Supports Always Encrypted & Row Level Security
    • SQL Server
    • App
    • Query
    • Microsoft Azure
    • Hyperscale cloud
    • Jim Gray
    • ox7ff654ae6d
    • 3/18/2005
  19. Slide 19

    • Demo
    • Rohan Kumar
  20. Slide 20

    • Hyperscale cloud
    • Hybrid solutions
    • Stretch tables into Azure
    • Power BI with on-premises data
    • Hybrid scenarios with SSIS
    • Enhanced backup to Azure
    • Simplicity
    • Easy migration of on-premises SQL Server
    • Simplified Add Azure Replica Wizard
    • Consistency
    • Common development, management and identity tools
    • Consistent experience from on-premises to Azure
  21. Mission critical performance

    Slide 21 - Mission critical performance

    • SQL Server 2016
    • Hyperscale cloud
    • Deeper insights across data
  22. Introducing Azure SQL Data Warehouse

    Slide 22 - Introducing Azure SQL Data Warehouse

    • Integration with Power BI, ADF, and Machine Learning services
    • Separate storage & compute
    • Elastic scale
    • Scale-out relational data warehouse
    • MPP massive scale-out
  23. Slide 24

    • Demo
    • Rohan Kumar
  24. Slide 25

    • VISUALIZE + DECIDE
    • Mobile
    • Reports
    • Natural language
    • query
    • Dashboards
    • Applications
    • Streaming
    • CAPTURE + MANAGE
    • Relational
    • Internal & external
    • Non-relational
    • NoSQL
    • { }
    • TRANSFORM + ANALYZE
    • Orchestration
    • Machine learning
    • Modeling
    • Information management
    • Complex event processing
    • The Microsoftdata platform
  25. Slide 26

    • Check out all the data sessions
    • Pre-register for the SQL Server 2016 CTP & Azure SQL DW previews
    • http://www.Microsoft.com/mcpnews