18 Free SQL Server 2014, Azure and BI virtual labs
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: https://technet.microsoft.com/en-us/virtuallabs/dn336436.aspx
Comments
- Anonymous
August 18, 2014
Want to get familiar with the new SQL Server 2014, Power BI, Azure Predictive Analytics or Microsoft - Anonymous
August 29, 2014
I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee. This - Anonymous
August 29, 2014
I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee. This - Anonymous
October 06, 2014
Hi everyone!
This is my first blog post, so let me introduce myself. I’m Charles Verdon ( @chverdon - Anonymous
August 12, 2015
Hi all.
We have an opening for SQL BIDB and Azure Developer @ Dallas
Interested candidates Pls mail me vimala.shrikon@gmai.com
Pls excuse if irrelevant - Anonymous
September 27, 2015
Want to get familiar with the new SQL Server 2014, Power BI, Azure Predictive Analytics or Microsoft