image
Do you want to learn about SQL Server 2014, Azure SQL Databases, Corporate BI, and Power BI without the need of installing and configuring the installation bits?
 
We’ve just released 18 (eighteen) new virtual labs based on the integrated demo Virtual Machines with full step-by-step instructions.
 
All that you need to start using these online labs is the Internet access and browser (IE, Chrome, and FireFox)*

 

List of labs:

Lab Title
Lab Description
Exploring In-Memory OLTP in SQL Server 2014
In this lab you will learn how to configure and use In-Memory OLTP tables and natively compiled stored procedures to improve transaction performance. Includes how to determine the best candidate tables and stored procedures to migrate to In-Memory OLTP objects.
Exploring AlwaysOn Availability Groups in SQL Server 2014
In this lab you will learn how to setup an Availability Group and test a manual failover condition
Exploring AlwaysOn Failover Cluster Instances in SQL Server 2014
In this lab you will learn how to setup a Failover Cluster Instance and test a manual failover condition
Exploring online database operations in SQL Server 2014
In this lab you will learn how to improve database availability with managed lock priorities and single partition online index rebuild
Exploring updatable ColumnStore indexes in SQL Server 2014
In this lab you will learn how to use clustered ColumnStore indexes to improve query performance and reduce storage for data warehousing
Exploring Resource Governor IO enhancements in SQL Server 2014
In this lab you will learn how to configure Resource Governor for limiting IO and test the results
Exploring Buffer Pool Extensions in SQL Server 2014
In this lab you will learn how to configure and test the use of Buffer Pool Extensions using SSD storage to improve query performance for memory pressure situations
Exploring SQL Server Data Tools for databases in Visual Studio 2013
In this lab you will learn how to use the SQL Server Data Tools to manage database schema and deploy the result to a Microsoft Azure SQL Database
Exploring Microsoft Azure SQL Databases
In this lab you will learn how to provision an Azure SQL Database, deploy a database and perform a database backup
Exploring Distributed Replay in SQL Server 2014
In this lab you will learn how to setup and configure Distributed Replay and use SQL Server Profiler to record a trace and then execute the trace using Distributed Replay
Exploring Filestream Storage in SQL Server 2014
In this lab you will learn how to configure and use Filestream Storage to store and retrieve blob objects with SQL Server
Exploring organizational security and auditing in SQL Server 2014
In this lab you will learn how to use SQL Server Audit, Contained Database authentication, user-defined server roles and new permissions
Exploring Corporate BI in SQL Server 2014
In this lab you will learn how to use the BI semantic model for data modeling, setting up partitioning and security, integrating with SharePoint, and creating reports with SSRS.
Exploring Master Data Services and Data Quality Services in SQL Server 2014
In this lab you will learn how to use Master Data Services and Data Quality Services to improve the credibility and consistency of data for your organization
Exploring manual and automatic database backup using Microsoft Azure storage in SQL Server 2014
In this lab you will learn how to use manual and automatic backup capabilities for SQL Server databases using Microsoft Azure storage
Exploring SQL Server 2014 database deployment in Microsoft Azure Virtual Machines
In this lab you will learn how to provision an Azure Virtual Machine running SQL Server 2014 and different ways to deploy a database to the VM
Exploring Office 365 Power BI
In this lab you will learn how to create a Power BI site, schedule data refreshes from a data warehouse, share queries with the Power BI Data Catalog and use Power BI Q&A for natural language interaction and analysis of data
Using Power Query and Power Map in Excel 2013
Learn how to use Power Query within Excel 2013 to combine multiple data sources and then use Power Map for 3D visualizations on the data based on geography

Are you looking for free online trainings or upcoming SQL Server and BI events in Canada? Please check this page.

*System requirements: http://technet.microsoft.com/en-us/virtuallabs/dn336436.aspx