SQL Server 2019 - Your Next Modern Data Platform

Overview

Comprehensive overview of SQL Server 2019's features, including improved performance, data integration capabilities, and advanced security, highlighting its evolution as a modern data platform.

Syllabus

• Introduction to SQL Server 2019
Overview of SQL Server and its evolution
Key new features in SQL Server 2019
• Installation and Configuration
System requirements and installation process
Configuration and management tools
• Performance Enhancements
Query performance improvements
Intelligent Query Processing (IQP)
In-Memory Database capabilities
• Data Integration Capabilities
PolyBase enhancements for data integration
Working with Big Data clusters
Integration with Apache Spark
• Advanced Security Features
Always Encrypted with secure enclaves
Data Classification and Auditing
Advanced threat protection tools
• Modern Data Platform Architecture
Kubernetes integration and containerization
Deployment strategies for hybrid environments
Scalability and high availability
• Data Management and Storage
Enhancements in storage performance
Management of diverse data types
• Development and Programming Enhancements
T-SQL enhancements
Developer tools and environments
• Backup, Recovery, and Monitoring
Enhanced backup and recovery options
Performance monitoring and management
• Case Studies and Practical Applications
Real-world use cases of SQL Server 2019
Industry-specific data platform implementations
• Future Trends and Developments
The roadmap for SQL Server
Ongoing developments in data platform technologies
• Course Review and Conclusion
Summary of key takeaways
Discussion of future learning paths in data platforms and SQL Server technology

Subjects

Conference Talks