Out of Stock

Essential Guide to SQL Server 2014 - On Demand

Price: $199.00

Presented by Michael Otey

Running Time: 164 minutes

In this new online training class, you will quickly get up to speed on the new features in SQL Server 2014. You will learn about the editions as well  how to start using the In-Memory OLTP engine for improved application performance. You also will see how to take advantage of the enhancements to AlwaysOn Availability Groups for improved availability.

By the end of this course, you will learn:

  • the features and editions of SQL Server 2014
  • how to migrate databases  to In-Memory OLTP
  • how to use AlwaysOn Availability Groups and SQL Backup with Windows Azure


Session 1: SQL Server 2014 New Features, Editions, and Licensing

This introductory session provides an overview of all of the major new features in SQL Server 2014. You’ll learn which features are included in which editions of SQL Server 2014. Finally, you’ll get a look at some of the common licensing scenarios for SQL Server 2014 with virtualization and AlwaysOn.


Session 2: Getting Started with In-Memory OLTP

In this session you'll learn how the new In-Memory OLTP engine works. You’ll see how to use the new AMR (Analyze, Migrate, Report) tool to analyze your tables and stored procedures  and then migrate them to the new memory-optimized format. Finally, you’ll see how to track the performance of your memory-optimized databases.


Session 3: AlwaysOn and Backup Integration with Windows Azure

In this session you’ll learn about the new AlwaysOn Availability Groups and backup features in SQL Server 2014. You’ll see how to use the compression and encryption features in SQL Server 2014’s backup.  Next,  you’ll see how the new AlwaysOn Availability Groups can leverage on-premise replicas for high availability (HA) and Azure replicas for disaster recovery (DR).



Michael Otey is senior technical director for Windows IT Pro and SQL Server Pro and is president of TECA a technical writing, software-development and consulting company in Portland, Oregon. Michael covers the topics of SQL Server, Windows Server, VMware vSphere, virtualization, PowerShell and .NET development. Michael performs hardware and software product reviews for the Windows IT Pro labs. He does frequent webcasts, is a presenter at IT/Dev Connections and other conferences and has written several books on SQL Server and .NET development.


Customer Service

Need to be invoiced or interested in registering 2 or more people? Contact our customer service team directly for assistance.
Email: service@sqlmag.com
Phone: 800-262-1954 or 913-967-1719

Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×