Full Day Hands-On Labs

(Additional Fee Required.  See Pricing Page for Details.)

Visual Studio Live! Austin offers two instructor-led, post-conference Hands-On Labs. Get intensive in-depth training to complete your conference experience.

These labs are Bring Your Own Laptop (BYOL). Attendance for each Hands-On Lab is limited, so be sure to sign up early to guarantee your spot.

HOL01 - Full Day Hands-On Lab: Develop an ASP.NET Core 2 and EF Core 2 App in a Day – Intermediate

Philip Japikse
Friday, May 4, 8:00am – 5:00pm

Interested in ASP.NET Core 2 and Entity Framework Core 2, but not sure where to start? Start here with a full day Hands-On Lab where you will build a complete solution using the latest development technology from Microsoft. Using Visual Studio 2017 (15.3 or greater) and .NET Core 2, you will build a data access library using Entity Framework Core 2, complete with repos and migrations. Next, you will build a ASP.NET Core 2 web application, leveraging all of the latest that ASP.NET Core 2 has to offer, including Tag Helpers, View Components, Dependency Injection, and more!

You will learn:

  • The new project structure for .NET Core 2 Apps
  • Creating a data access layer with Entity Framework Core 2
  • Initializing data for testing with EF Core 2
  • Building a website with ASP.NET Core 2
  • Configuring the HTTP pipeline and routing
  • Using and creating Tag Helpers
  • Creating and using View Components
  • Leveraging Dependency Injection

Attendee Requirements:
You must provide your own laptop computer for this hands-on lab.

You will need to have Visual Studio 2017 version 15.3 installed (any edition). Visual Studio 2017 15.3 can be downloaded from https://www.visualstudio.com/downloads/. When installing, make sure to select the "ASP.NET and web development" and ".NET Core cross-platform development" workloads.

You will need to install the x64 versions of the SDK and Runtimes (2.0.0). They can be downloaded from https://www.microsoft.com/net/download/core.

You also will need to have SQL Server Express 2016 Local DB and SQL Server Management Studio (SSMS) installed. LocalDB is installed with VS2017, but development is easier with full SQL Server Express and SSMS. SSMS can be installed from the SQL Server 2016 Express installer, located here: https://msdn.microsoft.com/en-us/library/hh510202.aspx.

Finally, you need to download the starter files and Lab documents for this HOL, located in https://github.com/skimedic/dotnetcore_hol/tree/master/2.0.

HOL02 - Full Day Hands-On Lab: Developer Dive into SQL Server – Intermediate

Leonard Lobel
Friday, May 4, 8:00am – 5:00pm

Roll up your sleeves, and get ready to spend a full day learning great new features for developers in SQL Server 2016. You'll start with a vanilla database, and then adorn it – step by step – with some of the most compelling new SQL Server 2016 features, including dynamic database masking (DDM), row level security (RLS), and Always Encrypted. Then you'll "stretch" the database, which transparently relocates select tables to the cloud in Azure SQL Database), and utilize temporal tables, which enables "time-travel" queries. You'll also exploit the new JSON capabilities to consume and produce JSON in the database, integrate FILESTREAM and FileTable for native BLOB storage, and add location awareness with the geospatial data types.
Attendance is limited.

You will learn:

  • New SQL Server 2016 security features such as dynamic data masking, row level security, and always encrypted
  • Other new SQL Server 2016 features, such as stretch database, temporal tables, and JSON
  • Beyond relational features, such as FILESTREAM, FileTable, and geospatial data types

Attendee Requirements:
You must provide your own laptop computer for this hands-on lab.

You will need a computer that supports Wi-Fi and that can connect to a Microsoft Azure hosted virtual machine via Remote Desktop Protocol (RDP). If you're running Windows 8.1 or Windows 10, you're ready to go! For the stretch database demos only, you'll also need a Microsoft Azure subscription. No worries if you don't have one though, you'll be able to follow along with the rest of the workshop without it.

If you're running Windows 7, you'll want to make sure you're have installed the latest Remote Desktop client. You can get it at https://support.microsoft.com/en-us/kb/2923545.

You can also use a Mac running OS/X 10.7 (Lion) or later with an Intel 64-bit processor. You'll want to install the latest Microsoft Remote Desktop client from the Mac App Store. You can find it via https://itunes.apple.com/us/app/microsoft-remote-desktop/id715768417?mt=12.