Breakthrough Data Platform Performance with SQL 2014

Overview

Explore SQL Server 2014's in-memory technologies for enhanced OLTP, Data Warehousing, and BI performance. Learn about mission-critical features and hybrid cloud capabilities for improved database management.

Syllabus

• Introduction to SQL Server 2014
Overview of new features
Understanding the SQL Server ecosystem
• In-Memory OLTP
Features and benefits of In-Memory OLTP
Creating In-Memory tables and natively compiled stored procedures
Best practices for implementing In-Memory OLTP
• Enhanced Data Warehousing
Columnstore Indexes enhancements
Techniques for optimizing data storage and retrieval
Strategies for implementing high-performance data warehouses
• Business Intelligence (BI) Improvements
Improved integration with BI tools
Data analysis and reporting enhancements
Case studies on BI implementation with SQL 2014
• Mission-Critical Features
AlwaysOn availability groups
Security enhancements and compliance
Performance tuning and monitoring
• Hybrid Cloud Capabilities
Overview of hybrid cloud architecture
Using SQL Server with Microsoft Azure
Setting up and managing cloud backup and disaster recovery
• Database Management and Maintenance
Automated backup and recovery
Indexing strategies and maintenance
Diagnosing and troubleshooting common performance issues
• Real-world Case Studies
Evaluating SQL Server 2014 implementation in various industries
Lessons learned and practical applications
• Course Review and Q&A
Recap of key concepts and technologies
Open forum for questions and discussion

---

Subjects

Conference Talks