Getting real time SQL Server lab exposure to test new features


By:   |   Updated: 2012-05-31   |   Comments (8)   |   Related: More > 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


Last Updated: 2012-05-31


get scripts

next tip button



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.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.





Saturday, October 05, 2013 - 2:44:26 AM - shilpa Back To Top

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

 


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

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


Sunday, September 09, 2012 - 2:04:31 PM - Jeremy Kadlec Back To Top

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 08, 2012 - 1:22:02 PM - ajay Back To Top

hi sir,

 

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


Sunday, June 03, 2012 - 2:01:26 AM - Mohammed Moinudheen Back To Top

Thank you for the feedback.


Friday, June 01, 2012 - 9:37:49 AM - Gopalakrishnan Arthanarisamy Back To Top

Hi Mohammed,

Thanks a lot for sharing this info.

 

Gopalakrishnan Arthanarisamy,

Unisys, Bangalore.


Friday, June 01, 2012 - 12:22:02 AM - Muhammad Azim Back To Top

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

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



download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools