Downloaded 125 times
Uploaded byJuan Fabian
Overview SQL Server 2019
The document outlines the roadmap for SQL Server, including enhancements to performance, security, availability, development tools, and big data capabilities. Key updates include improved intelligent query processing, confidential computing with secure enclaves, high availability options on Kubernetes, machine learning services, and tools in Azure Data Studio. The roadmap aims to make SQL Server the most secure, high performing, and intelligent data platform across on-premises, private cloud and public cloud environments.
In this document
Powered by AI
Introduction to SQL Server by MVP Juan Rafael and acknowledgment of sponsors.
Showcases SQL Server 2019's performance, security, big data handling, and unified data services.
Explains SQL Server Big Data Clusters architecture with compute and storage pools for data handling.
Focus on SQL Server's performance, security, and availability for critical workloads and features.
Discusses development enhancements, language support, and closing gaps for SQL Server on Linux.
Tuning features for SQL Server engine, including stats and troubleshooting capabilities.
Introduction to Azure Data Studio for managing SQL databases with modern DevOps experiences.
Outlines future improvements for SQL Server in areas like security, performance, and container usage.
Provides URLs for event and session evaluations for feedback on the presentation.
Overview SQL Server 2019
- 1. The roadmap forSQL Server MVP Juan Rafael
- 2. BIG Thanks toSQLSatLima sponsors
- 3.
- 4. Insights in minutes andrich reports Choice of platform and language Most secure over the last 8 years5 0 20 40 60 80 100 120 140 160 180 200 Vulnerabilities(2010-2017) The best of Power BI and SQL Server Reporting Services with Power BI Report Server Industry-leading performance #1 OLTP performance1 #1 DW performance on 1TB2, 10TB3, and 30TB4 Intelligent Query Processing SQL Server 2019Industry-leading performance and security, with intelligence over all your data Private cloud Public cloud Most consistent data platformIn-memory across all workloads 1/10th the cost of Oracle T-SQL Java C/C++ PHP Node.js C#/VB.NET Python Ruby All TPC Claims as of 1/19/2018. 1 http://www.tpc.org/4081; 2 http://www.tpc.org/3331; 3 http://www.tpc.org/3326; 4 http://www.tpc.org/3321; 5 National Institute of Standards and Technology Comprehensive Vulnerability Database Intelligence over any data AI and Machine Learning over all data with the power of SQL and Apache Spark
- 5. SQL Server 2019enables intelligence over all your data Build intelligent apps and AI with all your data Analyzing all data Easily and securely manage data big and small Managing all data Simplified management and analysis through a unified deployment, governance, and tooling Unified access to all your data with unparalleled performance Integrating all data
- 6. All on aunified data services platform Including Relational, noSQL, Hadoop Using Apache Spark and SQL With Azure Data Studio
- 7. SQL Server 2019big data, analytics, and AI Managed SQL Server, Spark, and data lake Store high volume data in a data lake and access it easily using either SQL or Spark Management services, admin portal, and integrated security make it all easy to manage SQL Server Data virtualization Combine data from many sources without moving or replicating it Scale out compute and caching to boost performance T-SQL Analytics Apps Open database connectivity NoSQL Relational databases HDFS Complete AI platform Easily feed integrated data from many sources to your model training Ingest and prep data and then train, store, and operationalize your models all in one system SQL Server External Tables Compute pools and data pools Spark Scalable, shared storage (HDFS) External data sources Admin portal and management services Integrated AD-based security SQL Server ML Services Spark & Spark ML HDFS REST API containers for models
- 8. SQL Server bigdata clusters Compute pool SQL Compute Node SQL Compute Node SQL Compute Node … Compute pool SQL Compute Node IoT data Directly read from HDFS Persistent storage … Storage pool SQL Serve r Spark HDFS Data Node SQL Serve r Spark HDFS Data Node SQL Serve r Spark HDFS Data Node Kubernetes pod Analytics Custom apps BI SQL Server master instance Node Node Node Node Node Node Node SQL Data mart SQL Data Node SQL Data Node Compute pool SQL Compute Node Storage Storage
- 10. The heart ofSQL Server is mission critical performance, security, and availability Security AvailabilityPerformance High availability for business critical workloads Data protected at rest and in motion Breakthrough performance and scalability
- 11. Mission critical performance The intelligentdatabase Intelligent Query Processing Gain performance insights anytime and anywhere with Lightweight Query Profiling Accelerating I/O performance with Persistent Memory The Intelligent Query Processing feature family Intelligent QP Adaptive QP Adaptive Joins Batch Mode Interleaved Execution Memory Grant Feedback Row ModeBatch Mode Table Variable Deferred Compilation Approximate QP Approximate Count Distinct Batch Mode for Row Store
- 13. Mission critical security Confidential computing AlwaysEncrypted with secure enclaves Data Classification and auditing built-in Manage certificates easier with SQL Configuration Manager plaintext ciphertext Enhanced client driver Enclave plaintext Always Encrypted with secure enclaves
- 14. Mission critical availability Keep SQLServer running Always On availability group enhancements Resumable online index creation Online Clustered Columnstore index creation and rebuild Availability groups on Kubernetes Availability groups on Kubernetes AG Pod Operator Pod Load balancer Pod SQL Server primary AG agent Pod Load balancer Pod SQL Server secondary AG agent Pod SQL Server secondary AG agent SQL Server primary SQL Server secondary
- 15. The modern developmentplatform Speed app development and admin with new enhancements Develop on your choice of language and tooling
- 16. Enhancing the developer experience SQL Graphenhancements UTF-8 support Machine Learning Services enhancements SQL Server Java extension SQL Server R
- 18. Enhancing the platform ofchoice Closing features gaps for SQL Server on Linux Replication Distributed transactions Machine Learning Open LDAP Provider support The Microsoft Container Registry SQL Server RedHat Container Images Always On Availability Groups on Kubernetes
- 20. Tuning the SQL Serverengine Columnstore stats in DBCC CLONEDATABASE Estimate compression for Columnstore indexes Troubleshoot page resource waits with new built-in T-SQL 0100101010110 In-Memory ColumnStore In-Memory OLTP !
- 21. The Azure DataStudio tools experience Azure Data Studio is a lightweight, open source, cross-platform graphical management tool and code editor Enable a modern DevOps experience for database developers and DBAs on their platform of choice Simplify development, configuration, management, monitoring and troubleshooting for SQL databases on-premises and in the cloud NEW Use SQL Server Management Studio 18.0 Preview to access, configure, manage, and administer all SQL Server components
- 22. Investments in thefuture of SQL Server SQL Server on Edge Finish features for big data clusters and data virtualization Making SQL Server more available, faster Further enhance SQL Server security Enhance the engine to align with hardware innovation Continue to make the container experience great Engine improvements based on customer feedback
- 23.