SQL 2012 new MSDN Virtual Labs

 

MSDN Virtual Lab: SQL Server 2012: Managing Rich Unstructured Data in SQL Server 2012

After completing this lab, you will be better able to create FileTables, create Fulltext Indexes with semantic extraction capabilities, retrieve information about document properties, and retrieve semantic information.

 

MSDN Virtual Lab Express: SQL Server 2012: Exploring Transact-SQL Improvements in SQL Server 2012

After completing this lab, you will be better able to create and use sequence objects, query rows through paged results, and raise and catch exceptions using Throw/Catch.

 

MSDN Virtual Lab Express: SQL Server 2012: Exploring SQL Server 2012 Integration Services

After completing this lab, you will be better able to introduce project connection managers, introduce parameters, create a SSIS Catalog, deploy an Integration Services project to the SSIS Catalog, execute packages from the SSIS Catalog, script package execution commands, and monitoring the Integration Services environment and package executions.

 

MSDN Virtual Lab: SQL Server 2012: How to Build Your First Web App with SQL Server 2012 and ASP.Net

After completing this lab, you will be better able to create your first web application using ASP.NET and SQL Server, design a class in C# that makes it easy to work with SQL Server data using a business object, bind data from SQL Server to ASP.NET web server controls using a business object, display images on web pages that are stored in SQL Server, build a SQL Server connection string and use it to connect to SQL Server using the ADO.NET SqlConnection class, and construct parameterized Transact-SQL statements in an application and execute them using the ADO.NET SqlCommand class.