Archive for the ‘ Teaching ’ Category

Step by Step Guide to Creating a SQL Server VM Using VMWare

Download PDF file

I typically use SQL Server VMs for my development and administration classes. I want the students to have full autonomy over the machines they are using, so that they can try out different features and configurations without worrying about wrecking a whole lab machine.

This tutorial steps the students through how to create and configure their own standalone SQL Server VMs. We will be using:

· VMWare Server

· Windows Server 2008

· SQL Server 2008

Terms

A few terms to familiarize yourselves with before we start:

Virtual Machine (VM) This is essentially a standalone computer installed within another platform/OS.

A virtual machine is also sometimes called a guest machine. This typically provides a complete system platform with its own set of operating system, hardware configurations, and installed software packages, but still runs on top of a “host” machine which has the main OS, and the physical hardware.

There are different applications that can create and run virtual machines:

VMware Server
MS Virtual Server

MS Virtual PC

Virtual Box

ISO file This is a disk image, an archive file of an optical disc in a format defined by the International Organization for Standardization (ISO). This contains archived CD/DVD content, and you can point your VM to an ISO file to read or use the content.

You can create ISO files using any CD/DVD image file processing tool, like:

PowerISO

MagicISO

FreeISO Creator
Nero Burning Software

Prep Work

1. Download and install VMWare Server (http://www.vmware.com/products/server/)

You will need to register, and get the serial number for your free VMWare Server. Once it’s installed, you should have a link to VMWare Server Home Page from your Start > Programs menu.

clip_image002

2. Get your media for :

· your operating system (ex Windows Server 2008)

· SQL Server (up to you which version you want to install)

or better yet, or if you have MSDN/MSDNAA/Technet Subscriptions, download it from the Microsoft Site. If there is an option to download an .iso file, download the .iso file. Otherwise you will need to create this yourself later.

Read the rest of this entry »

VN:F [1.9.22_1171]
Rating: 10.0/10 (9 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

This Is Why I Teach

I have been teaching IT courses since 2002; I started as a TA for relational databases and Delphi. Right now I teach part time courses in web development/design, and database development and administration. Wow, it’s already been a while and yet I can still remember my first teaching gig as if it were just yesterday.

Some people ask me why I teach. This is why:

ty   ty2 ty3

 

I take pains when developing and delivering my courses. I treat teaching very seriously. When students take my class, I want them to really learn something from it. I want them to get their money’s worth (or more!). I want them to walk away with a new skill, or new knowledge, or new discovery, after each class. When they ask me questions I don’t know the answer to, I try to look for the answer – sometimes even spend sleepless nights trying out a few test cases – and present the answer in the next class.

 

Why?
Because I love doing this.

And because I want to make a difference. However small or trivial it may be.

 

My teaching style does not work for all of my students. I do not have all the answers to student questions, and no – not all the demos are flawless in front of the students.

But if I can help someone understand a concept, or look for a solution, or just be someone to bounce ideas with, then it’s all worth it. Or just encourage them to keep on going and not get discouraged …

And sometimes, some students take the time to let me know they appreciate this. And I can’t tell them how much gestures like this mean to instructors like me.

VN:F [1.9.22_1171]
Rating: 10.0/10 (2 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)
`