What does end of support mean for you? After April 12, 2016 Microsoft will no longer issue security updates for SQL Server 2005.
If you are still running SQL Server 2005 in your datacenter, you need to take steps now to plan and execute a migration strategy to protect your infrastructure.
By migrating to SQL Server 2014 you can achieve concrete benefits, including improved performance and availability, better security, and increased agility and speed of response to the business.
This 1-day hands-on technical training workshop focuses on scenario or lab based learning.
This course enables database administrators (DBAs) to explore SQL Server 2005 upgrade strategies and get familiar with new SQL Server 2014 capabilities: In-Memory for OLTP and DW, Hybrid Cloud with Microsoft Azure for backup and DR, and others.
This course is intended for technology managers and database professionals who want to prepare to understand the key capabilities of SQL Server 2014 and prepare to upgrade from SQL Server 2005. Before attending this course, students must have an understanding of how data systems are used in a business enterprise.
At Course Completion
After completing this course, students will be able to:
- Describe key new and enhanced features in SQL Server 2014
- Describe the mission-critical database platform capabilities of SQL Server
- Describe the enterprise integration management and data warehousing capabilities of SQL Server
- Describe the business intelligence capabilities of SQL Server
- Describe how SQL Server can be used in a cloud-based data solution
New and Enhanced Features of SQL Server 2014
In-Memory OLTP Engine
Buffer Pool Extension
Storage I/O Control
PowerView for Multidimentional Models
Power BI for Office 365 Integration
SQL Server Data Tools for Business Intelligence
Mission-critical Database Platform Capabilities of SQL Server
SQL Server 2014 In-Memory for OLTP
Enterprise Integration Management and Data Warehousing
Integrated In-memory technology
AlwaysOn HA / DR for mission-critical workload
Cloud and on-premises scenarios support
Resource governance improvements
Advanced security enhancements
Hybrid Databases and Data Archiving
SQL Server 2014 Solutions in the Cloud
SQL Server Solutions in the Cloud
Registration Policy These free events are by invitation from your ctc Account Manager, Microsoft Account Manager or other Microsoft Partner. All registrations are pending approval.