Installing Microsoft SQL on Server 2012 R2

Resources:

Windows Server 2012 R2

Microsoft SQL 2012

Can be obtained from TCAT’s DreamSpark -

http://e5.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?ws=5dee02e7-a65d-e111-8056-f04da23e67f6&vsro=8&JSEnabled=1

Note: you can use the trial software on Server and SQL if you do not have a Dreamspark account.

Files to use as demos:

http://msftdbprodsamples.codeplex.com/releases/view/55330

Virtualization needed:

http://www.vmware.com/products/player

Hardware needed:

Dual Core computer with 4 GB of RAM (Minimum)

How to:

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

1 SQL

SQL Server 2012 Setup will run a Rule Check to make sure your computer is adequate 2 SQL

You should receive a pass for all items checked (.Net 2.0, .Net 3.5, etc.)3 SQL

Next enter your product key if applicable4 SQL

Click Next and accept the terms5 SQL

SQL Server will begin to install if you have corrected any items that may need correcting.7 SQL

This will check for Setup Support Rules.  Correct any failures if necessary.8 SQL

You will now select SQL Server Feature Installation9 SQL

On the next screen, it is recommended that you select all features if you are learning SQL10 SQL

This will in turn check the installation rules such as .Net Framework and Visual Studeio 2010.11 SQL

Create a default instance of SQL.  You can name the Instance ID or select a hard drive for the installation12 sQL

This will now check your space on the virtual machine (HDD space)13 SQL

It is recommended at the next screen to select the SQL Server agent be placed on automatic in the startup type14

Next select Mixed Mode and provide a complex password.  You will also add the Administrator or your account name as a SQL Server Administrator.15 SQL 16

Below is an example of a simple password.  You must use a complex password.17 SQL 18 SQL 19 20 21 22 23 24

Monitor your task manager and CPU to ensure you have adequate resources.25 26 Host 27

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 -

http://www.w3schools.com/sql/

http://www.sqlcourse.com/

http://www.1keydata.com/sql/sql.html

http://sqlzoo.net/wiki/Main_Page

Opening Studio

Opening Studio

Running a basic query

Sample Query

Server Manager – if you want desktop icons on Server, you must open the server manager and add a feature (Desktop Experience).

Features

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.

Features 2Features 3

Malware Can Bypass Chrome Extension Security Feature Easily

Researchers have uncovered a new social engineering trick that leads users to a malicious extension from Google Chrome impersonating to deliver Adobe’s Flash Player in order to lure victims in a click fraud campaign.

Malware Can Bypass Chrome Extension Security Feature Easily.

Internet application slow? You may need to temporarily disable Nagle’s Algorithm

With the Nagle-Algorithm, Windows takes small packets and packages them in to more manageable and efficient sizes.   If you have poor latency, you might try to disable the Nagle-Algorithm.  Nagle’s algorithm helps to control congestion when small packets are sent continuously by TCP.   When enabled, this helps to prevent a flood of these packets.

More information – http://en.wikipedia.org/wiki/Nagle’s_algorithm

How to disable Nagle’s algorithm-

Open regedit.exe.  Navigate to HKey_Local_Machine\System\CurrentControlSet\Services\Tcpip\Parameters\Interfaces\

Find the interface that has your current IP address (see example below)

Find IP address

Add the following values and make sure they are set to 1.

TcpAckFrequency and TCPNoDelay

Add values

This is only a temporary fix for the reduction of some applications on the internet.  Once your project or need is fulfilled, you should re-enable the algorithm by deleting the keys and rebooting or changing the values.

IT Stress

Excellent article on stress in information technology….

The survey gauged respondents€™ stress levels at work and revealed their opinions on their main stressors, as well as how their stress levels compares with those of friends and family, and how it affects their personal and professional lives. Nearly 70 percent of all IT administrators surveyed consider their jobs stressful, with greater than 67 percent of IT administrators – See more at: EWeek Article

More on stress in IT at National Institutes of Health