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





Comments For This Article




Saturday, October 05, 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 09, 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 08, 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 03, 2012 - 2:01:26 AM - Mohammed Moinudheen Back To Top (17788)

Thank you for the feedback.


Friday, June 01, 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 01, 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.........



download


Recommended Reading

Populate Large Tables with Random Data for SQL Server Performance Testing

SQL Query Stress Tool

Clearing Cache for SQL Server Performance Testing

Attach Sample Database - Adventureworks in SQL Server 2012

Install Your Own Copy of the SQL Server AdventureWorks2014 Database





get free sql tips
agree to terms


Learn more about SQL Server tools