Mission Critical Apps with SQL Server 2017 - Cross-Platform SQL Server Management

Overview

Learn to build mission-critical apps using SQL Server 2017's advanced features like In-Memory performance, Automatic Tuning, and Always Encrypted for enhanced security and efficiency.

Syllabus

• Course Introduction
Overview of SQL Server 2017
Course objectives and outcomes
• SQL Server 2017 Architecture and Core Concepts
Cross-platform capabilities
High availability and disaster recovery
• In-Memory Performance Enhancements
Memory-optimized tables
Native stored procedures
• Automatic Tuning
Query performance optimization
Automatic plan correction
• Enhanced Security with SQL Server 2017
Always Encrypted
Dynamic data masking
Row-level security
• Building Mission-Critical Applications
Scalability and reliability strategies
Utilizing SQL Server features for robust applications
• SQL Server on Linux and Docker
Installation and configuration
Cross-platform management tools
• Monitoring and Performance Tuning
Query Store
Performance monitoring tools
• Real-world Application Design
Designing for performance and security
Best practices for mission-critical apps
• Project: Develop a Cross-Platform Mission-Critical Application
Project overview and guidelines
Implementation and presentation
• Course Review and Q&A
Recap of key concepts
Open floor for questions and feedback

---

Subjects

Conference Talks