SQL IT CAMP: Time to upgrade to SQL Server 2014! HPE Event

Can’t find the right date? Consider a self study option. Get immediate access to online training videos, course materials and exam prep guides. Check out our Microsoft Self Study Courses >>>.

All Prices Are in Candian Dollars

Price :

  • Notify me

    Please leave your email and date you wish to take a course.
    • Date Format: DD slash MM slash YYYY


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.

Audience Profile

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
AlwaysOn Enhancements
Buffer Pool Extension
Columnstore Indexes
Storage I/O Control
PowerView for Multidimentional Models
Power BI for Office 365 Integration
SQL Server Data Tools for Business Intelligence
Backup Encryption 

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 HP Account Manager. All registrations are pending approval. 


All search results