Everything Microsoft Cloud

John Weston

Subscribe to John Weston: eMailAlertsEmail Alerts
Get John Weston: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Article

SQL 2012 New Virtual Labs Released

SQL 2012 Virtual Labs

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.

Launch Virtual Lab

image

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.

image

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.

image

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.

image

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

More Stories By John Weston

John Weston is a Cloud IT Pro Evangelist for Microsoft.http://aka.ms/syscntr During the last ten years he has spoken to thousands of IT Professionals across the country. Before joining Microsoft full time, he spent six years as an MCT, training people at a local college and getting new Microsoft hires up to speed. He holds more certifications than he can remember, but the list definitely includes MCITP, MCSE, MCDBA, MCT, and CCNA. Before becoming and MCT, Weston co-owned a software development and consulting firm that was a Microsoft Partner based in Dallas. His primary blog includes http://blogs.technet.com/b/jweston.