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

FREE – Security engineering training by SAFECode

FREE – How can you beat it?  Once again, another excellent site has training that is Free.   While we have found Rackspace’s Cloud University,  Free Microsoft Training and virtualization this site adds an additional form of training that can help you supplement your training programs.

“Security engineering training by SAFECode is an online community resource offering free software security training courses delivered via on-demand webcasts.

Covering issues from preventing SQL injection to avoiding cross site request forgery, the courses are designed to be used as building blocks for those looking to create an in-house training program for their product development teams, as well as individuals interested in enhancing their skills. All courses are free and published under a Creative Commons license and open, non-commercial usage of the content is encouraged.

SAFECode will be adding new courses to the site on an ongoing basis. Our goal is to create a diverse catalog of security engineering training courses for all expertise levels as a community resource.”
https://training.safecode.org/

SAFECODE

“While registration is not required to view the courses, registered users of the site will benefit from the ability to:
–Download courses for offline viewing
–Post comments to provide feedback on the courses and ideas for updates.
Your feedback will be used to help keep the material up-to-date and ensure it best meet the needs of the community it aims to serve.
–Receive email updates when new courses and resources are available”

 

Learn cloud computing with Rackspace’s CloudU

Ever wonder what cloud computing is?  Rackspace has an excellent program that you can take for free.   Cloud University offers ten detailed modules along with a exams for each module.    A final exam reviews each of the modules and with a score of 80% you can earn a certificate in cloud computing from Rackspace’s CloudU.   This detailed program is the work of Ben Kepes.   Ben is the curator of CloudU.    Through his arduous work, you can download a detailed curriculum, listen to webinars and take exams as many times as you need to in order to understand cloud computing.    In today’s  world of virtualization and cloud computing, Rackspace leads the pack by educating anyone who wants to learn about these exciting technologies.

After contacting Rackspace so that my students could benefit from the cloud university curriculum as a supplement.   I was met with open arms and personally talked with Greg Alfaro, Michael Ferranti and Ben Kepes either by phone or email.     Ben sent us this video as a statement.    (Thank you Ben!)

Confused about the cloud? Have no fear, CloudU is here. Whether you are simply searching for more information about cloud computing, or are looking to boost your resume with a formal certificate, Rackspace Cloud University, known as CloudU, is for you. CloudU is a vendor-neutral cloud computing curriculum designed by industry analyst Ben Kepes. It’s also completely free.

The extensive CloudU library and certificate program contain all that you need to learn how to take advantage of the biggest technology innovation since the Internet.     Boost Your Resume. Gain New Skills. Enroll in CloudU Today.

“CloudU is an excellent resource for anyone wanting to learn about Cloud Computing. As an instructor of information technology, the certificate provides a great learning tool for the planning, deployment and logistics behind cloud computing.”    ~ Ben Kepes

Sometimes you travel the world to get to where you are going…

Jay, one of our students,  was using a visual trace route on his iPad to see how many hops it took to go from Shelbyville, Tn.  to a business in Ohio.

Amazingly he went from – 

Shelbyville, TN
Murfreesboro, TN
Nashville, TN        x3
Los Angeles, Ca    x2
New Orleans, LA
Atlanta, GA
ST. Louis, MO
Atlanta, GA
Los Angeles, CA
Broomfield, IL
Newark, NJ
Munchen, Germany – That’s right Germany…
Detroit, MI
Arrived in Ohio at the Business

21 Hops – How long does it take to go this distance?  About a second.

The internet finds the fastest route.  This doesn’t always mean the shortest.   Which as you can see doesn’t mean the shortest.

tracert

 

What makes TCAT Shelbyville’s IT program different?

Path

 

Exams include Windows 70-680/70-687, Windows Server 2012 70-411/70-640.  The MTA (Microsoft Technical Associate is associated with other certifications in the same curriculum.

The Information Technology program at TCAT Shelbyville offers one of the best programs in the nation for IT professionals.  The amount of resources and curriculum that cover all major operating systems (Linux, Apple and Windows) is delivered by certified and industry leading experts.  With this curriculum, and the round robin method of teaching,  junior students work with senior students and instructors.  A major advantage students have are resources that are available 24/7/365.

Students spend 30 hours each week in lecture, labs and real world hands on for approximately 15 months.  Winning national awards and recognition, the program offers one of the best learning environments in the industry and continues  with a placement rate of over 90% and a retention rate of 96%.

Resources

Students can earn up to 10 certifications along with multiple diplomas and certificates.

For more information -
Visit the CIT program at http://www.tcatshelbyville.edu/full-time-programs/computer-information-technology

Note:  The Tennessee College of Applied Technology – Shelbyville is an accredited institution.  

A Geography game using Google Street View – Geogessr

Think you really know Geography?  Geoguessr is an online game that uses Google’s Street View.   With a small map in the corner of Google’s Street View, you pin where you think the Street View scene is.   You then submit your guess and the distance from the real location is measured.     It’s an excellent way to travel and view the world.

G1 G2 First Guess

Give it a shot.  I just couldn’t bring myself to show one of the answers.  Visit GeoGuessr.

Hints

  • License plates
  • Signs?
  • Traffic on Left or Right lane?
  • Look at vehicles
  • Flags?
  • Mountain ranges?
  • Trees?  Bushes
  • Coastal?  Think of waterways, look at ships
  • Winds? Look at the trees.
  • Buildings (look at roofs)
  • How are people dressed?

Highest score so far 9800 points….

Cannot find data record in database table course_modules.

The error that you may see if you are currently using Moodle may be seen after cron runs or when heavy access occurs.  The error,

!!! Can not find data record in database table course_modules. !!!

The error is related to heavy transactions and what we believe is caching corrupting the database.

To fix the error, you can run this query:

select modinfo from mdl_course where id = PutYourCourseIDHere;

Below, we use MySQL Workbench to run the query on a course id of 2

mysql workbench

Query

 

 

There is also a Moodle plugin that rebuilds all of the site’s cache.

https://moodle.org/plugins/pluginversion.php?id=2400