Getting real time SQL Server lab exposure to test new features

By:   |   Comments (8)   |   Related: > Testing


Problem

SQL Server 2012 offers many new features such as Always On Availability Groups, clustering, contained databases, etc... The downside is setting this up in a lab environment takes a lot of time and resources.  In this tip we cover how to get access to Microsoft Virtual Labs that are already setup, so you can test and work with these new features.

Solution

To get access to these environments, we can use the Microsoft Virtual Labs which are freely available online. We will share the Microsoft links from where you could start your lab session and run through the instruction manual and perform the steps as described in the manual.

The lab sessions are timed to a duration ranging between 1 hour to 2.5 hours. However, there is a mechanism by which we could perform a one time extension to extend the duration by an hour for a lab session. For the sake of clarity and ease of use, screenshots shown in this tip will guide you through the process and enable you to carry out these lab sessions.

This link, hhttp://technet.microsoft.com/en-us/virtuallabs/default, lists the various Microsoft products and versions for which virtual labs are available.

Here are specific labs for SQL Server:

If for example, you chose to work with Always On Availability Groups from the link for virtual labs related to SQL Server 2012, you click on the entry shown below.

Virtual Labs 2012

Once you click this link, the next step would be to launch the virtual lab. The recommended screen resolution is 1024x768. While doing the lab exercise, if you face any difficulties in viewing the entire screen, you might have to change the screen resolution to the recommended setting. /p>

Launch Virtual Lab

After clicking the 'Launch Virtual Lab' button, the virtual lab gets booted as shown in the screenshot below.

Virtual Lab getting launched

After this, you will encounter the below screen, click on 'Connect' to connect to the virtual lab.

Click on Connect

You will then encounter a pop up window which displays some information on how to connect to the virtual name. Go through the contents of this window and then close it. Once done, you will be in the Virtual Lab environment and will need to follow the instructions as displayed on the right side of the screen. The complete instructions can be downloaded by clicking on the PDF icon as shown on the right hand side.

Virtual Lab display

Also, note the time remaining in the right top corner as shown above. As mentioned in the beginning of the tip, the labs are 1 to 2.5.hours, but we can extend the lab one time for an extra hour. To get the extension, click on the 'MENU' icon on the top right and click on Support > Troubleshooting/FAQ as shown below. 

Extend Virtual lab timing

Click on the option to extend the duration of your lab session by an hour as shown below.

Extend Virtual lab timing

Summary

The virtual labs will allow you to try out some useful scenarios that you might have thought of performing on your own cluster configuration.  I have found that in most cases the time allotted is quite sufficient for completing all the exercises provided in the instructions manual.

Next Steps


sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Mohammed Moinudheen Mohammed Moinudheen is a SQL Server DBA with over 6 years experience managing production databases for a few Fortune 500 companies.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips



Comments For This Article




Saturday, October 5, 2013 - 2:44:26 AM - shilpa Back To Top (27050)

heloo sir thank you very much sir keep updating...

 


Friday, January 11, 2013 - 7:28:03 AM - Shreesha Kumar Back To Top (21399)

Nice Article Moinu..Very helpful for SQL DBAs..


Sunday, September 9, 2012 - 2:04:31 PM - Jeremy Kadlec Back To Top (19442)

ajay,

I would check out the Professional Development tips (http://www.mssqltips.com/sql_server_professional_development_tips.asp).  If you still have questions, please post them on the tips or in the Q&A (http://sqlserverquestions.mssqltips.com/questionlist.asp) section of MSSQLTips.com.

HTH.

Thank you,
Jeremy Kadlec


Saturday, September 8, 2012 - 1:22:02 PM - ajay Back To Top (19438)

hi sir,

 

please send me details of what a sql dba's work when he newely joins in the company.


Sunday, June 3, 2012 - 2:01:26 AM - Mohammed Moinudheen Back To Top (17788)

Thank you for the feedback.


Friday, June 1, 2012 - 9:37:49 AM - Gopalakrishnan Arthanarisamy Back To Top (17775)

Hi Mohammed,

Thanks a lot for sharing this info.

 

Gopalakrishnan Arthanarisamy,

Unisys, Bangalore.


Friday, June 1, 2012 - 12:22:02 AM - Muhammad Azim Back To Top (17767)

Very helpful. I was struggling hard to get required resources for testing SQL server 2012 new features. It helped me a lot.


Thursday, May 31, 2012 - 9:32:50 AM - rajendra Back To Top (17747)

Hi Mohammed...Thanks for such a good article.........















get free sql tips
agree to terms