Windows Server 2012 R2
Microsoft SQL 2012
Can be obtained from TCAT’s DreamSpark -
Note: you can use the trial software on Server and SQL if you do not have a Dreamspark account.
Files to use as demos:
Dual Core computer with 4 GB of RAM (Minimum)
Install VMWare Player and commit at least 30GB of HDD space, 1 CPU and 2 GB of ram (minimum).
Install Windows Server 2012 R2
Open Windows Server 2012 R2
Extract the SQL ISO into a folder on the Server
Click on Setup
Click on new SQL Server stand-alone installation
SQL Server 2012 Setup will run a Rule Check to make sure your computer is adequate
You should receive a pass for all items checked (.Net 2.0, .Net 3.5, etc.)
Next enter your product key if applicable
Click Next and accept the terms
SQL Server will begin to install if you have corrected any items that may need correcting.
This will check for Setup Support Rules. Correct any failures if necessary.
You will now select SQL Server Feature Installation
On the next screen, it is recommended that you select all features if you are learning SQL
This will in turn check the installation rules such as .Net Framework and Visual Studeio 2010.
Create a default instance of SQL. You can name the Instance ID or select a hard drive for the installation
This will now check your space on the virtual machine (HDD space)
It is recommended at the next screen to select the SQL Server agent be placed on automatic in the startup type
Next select Mixed Mode and provide a complex password. You will also add the Administrator or your account name as a SQL Server Administrator.
Below is an example of a simple password. You must use a complex password.
Monitor your task manager and CPU to ensure you have adequate resources.
SQL Server manager will now be available for you to use. While I installed this on my work laptop, you must remember to monitor laptops for heat and resource utilization.
Using one of the resources below, you can substitute what you learn on these pages and try writing queries from data you import from the codeplex database (http://msftdbprodsamples.codeplex.com/releases/view/55330).
A few links to SQL tutorials -
Running a basic query
Server Manager – if you want desktop icons on Server, you must open the server manager and add a feature (Desktop Experience).
If you right click on the desktop to use Personalize to add desktop icons, it will not be available. You must use the above wizard to add features (Desktop Experience to add icons such as Computer, Network, files and control panel). Personalize will become available after a reboot.