Microsoft Partner Network

18 NEUE TechNet Virtual Labs für SQL Server, Power BI und Azure

Die TechNet Virtual Labs sind ein perfekter Ort um neue Features auszuprobieren und zu erlernen. Keine Installation, nur ein Browser und schon kann es los gehen. Jetzt wurden die Virtual Labs um neue Lösungen rund um Datenbanken und Business Intelligence erweitert. Zusätzlich zu den 34 Labs zu SQL Server und Power BI gibt es jetzt weitere 18, neue 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

 

Check it out: http://technet.microsoft.com/de-de/virtuallabs?id=F2Ft/ah2g8Q

Kommentar schreiben

biuquote
  • Kommentar
  • Live Vorschau
Loading

Datenschutzhinweis: Sie stimmen durch "Kommentar speichern" der Speicherung Ihrer Angaben durch Microsoft Österreich für die Beantwortung der Anfrage zu. Sie erhalten dadurch keine unerwünschten Werbezusendungen. Ihre Emailadresse wird auf Ihren Wunsch dazu verwendet Sie über neue Kommentare zu informieren.

Microsoft respektiert den Datenschutz. Datenschutz & Cookies