Our Business is Your Education
1.888.925.9929   Chat With Us    
Our Business is Your Education

Congratulations to our 2015 Canadian Business College Graduates!

Posted on September 28th, 2015 - Written by: Vanessa Hamkens

On September 19th, 151 Canadian Business College graduates proudly walked the stage at the 23rd annual Convocation Ceremony at the Toronto Centre for the Arts.

Following a warm welcome from Faculty of Law Director, Jeffery Nicholson, President & Dean of Canadian Business College, John Nelson, took the stage and shared with us kind, thoughtful words, leaving us all extremely proud of all our inspiring graduates. Cheers filled the auditorium as parents, siblings, children, and friends watched loved ones receive their well-earned diplomas our Business, Law, IT & Digital Media, Health, and Community Services & Child Care programs.

Thank you to everyone who attended this event and supported our students in accomplishing this amazing milestone in their lives.

Write a Comment


Canadian Business College Hosting Free IT Seminar

Posted on May 11th, 2015 - Written by: Vanessa Hamkens

Canadian Business College Oracle Database 12C

Canadian Business College is very pleased to be hosting a free upcoming IT seminar for anyone interested in pursuing careers in Database Administration, Network Engineering and Software Engineering.

The seminar, Deploying SQL Server 2014 Always-On and Failover Cluster, will demonstrate how to deploy and manage Microsoft SQL Server high availability architecture. Host and Faculty of IT Director, Bill Xu (pictured lecturing above), will demonstrate SQL server failover and always-on, while comparing Microsoft and Oracle solutions.

SEMINAR DETAILS

Seminar Name: Deploying SQL Server 2014 Always-On and Failover Cluster

When: Friday June 19, 2015 from 10am – 3pm

Where: Canadian Business College – Toronto Campus

Address: 2 Bloor Street West – 22nd Floor located at the corner of Yonge and Bloor, just steps from TTC transit. For directions, please click here.

SEMINAR DESCRIPTION

Database high availability and safety are wildly required job skills. To provide a solution for database high availability and safety needs, the knowledge of networking, system and database administration are required. In typical business environments, networking/system teams along with data management teams work together in these scenarios. The seminar will aim to demonstrate the multi-level facets of database high availability and safety.

SEMINAR TOPICS

  • Windows Server 2012 R2
  • SQL Server 2014
  • Power shell
  • Hyper-V
  • Active directory
  • iSCSI
  • Windows and SQL Server failover cluster
  • SQL Server installation and configuration
  • SQL Server Always-on Feature…and more!

WHY STUDY AT CANADIAN BUSINESS COLLEGE?

Canadian Business College’s Database Administration, Advanced Database Administer, Network Engineering and Software Engineering diploma programs were designed to provide students with the industry required skills and certifications required to excel in the workforce.

Whether you’re looking to start a new career in one of these fields, or you’re an existing IT professional with a keen desire to upgrade your skills, we encourage you to attend!

For more information, give us a call at 416-925-9929 or 1-888-925-9929.

4 Comments


CBC Hosts Successful Windows Server 2012 R2 Seminar

Posted on July 2nd, 2014 - Written by: Vanessa Hamkens

Network-Engineering-Seminar

Are you a passionate about network engineering?

Then you would have loved Canadian Business College’s recent NE seminar addressing the latest on Windows Server 2012 R2 with Storage Spaces, SMB Scale-Out and Shared VHDX, including:

  • New Windows 2012 R2 Storage Features
  • Fail-Over Cluster
  • Windows Hyper-V
  • Systems Centre Virtual Machine Manager

The seminar was held on Friday June 13, 2014 at CBC’s Toronto Campus location and hosted by the Head of its IT Faculty, Bill Xu. Bill lectured to a full house comprised of enrolled Network Engineering students and prospective students looking to further their IT careers.

Not only did the seminar provide those in attendance with expert instruction and leading discussion on Windows Server 2012, it also provided those considering CBC’s Network Engineering Program with a unique opportunity to visit the Toronto Campus, chat with instructors and meet currently enrolled IT students.

All in all, the seminar was a huge success and Bill is champing at the bit to get the next one scheduled. Keep your ears peeled – we’d love to see you there!

If you’d like a full copy of the seminar transcript with images, it’s available for download in MS Word format here. Or, simply copy the transcript below:

Windows Server 2012 R2 Storage: SMB Scale-Out and Shared VHDX

Here are the details about the names, roles and IP addresses for each of the computers involved:

VM Computer Role Net2 (DC/DNS)
Host HOST2 Hyper-V Host 192.168.100.1/24
VM1 CBC-D DNS, DC 192.168.100.100/24
VM2 CBC-A1 Cluster Node 1 192.168.100.101/24
VM3 CBC-A2 Cluster Node 2 192.168.100.102/24
VM4 CBC-A3 Cluster Node 3 192.168.100.103/24
VM5 CBC-V VMM / Client 192.168.100.104/24
CBC-A Cluster 192.168.100.110/24
CBC-F Scale-Out​ File Server N/A

 

1) Configure the physical host

 # Preparation steps: Install WS2012R2, rename computer, enable remote desktop

# Prepare base image: Install WS2012R2

C:\windows\system32\sysprep\sysprep.exe /oobe /generalize /shutdown /quiet

# Install required roles and features, restart at the end
Install-WindowsFeature Failover-Clustering -IncludeManagementTools
Install-WindowsFeature Hyper-V -IncludeManagementTools -Restart

# Create a new Internal Switch
New-VMSwitch -Name Net2 -SwitchType Internal
Get-NetAdapter *Net2* | Rename-NetAdapter -NewName vNet2

# Configure vNet2 (parent port for internal switch) with a static IP address for DNS / DC
Set-NetIPInterface -InterfaceAlias vNet2 -DHCP Disabled
Remove-NetIPAddress -InterfaceAlias vNet2 -Confirm:$false
New-NetIPAddress -InterfaceAlias vNet2 -IPAddress 192.168.100.1 -PrefixLength 24
Set-DnsClientServerAddress -InterfaceAlias vNet2 -ServerAddresses 192.168.100.1

# Create 5 VMs, assumes there is a base VM ready at E:\VMS\BaseOS.VHDX
1..5 | % { New-VHD -Path E:\VMS\VM$_.VHDX –ParentPath E:\VMS\BaseOS.VHDX }
1..5 | % { New-VM -Name VM$_ -Path E:\VMS –VHDPath E:\VMS\VM$_.VHDX -Memory 2GB -SwitchName Net2 }
# Give the VMM VM a little more RAM
Set-VM -VMName VM5 -MemoryStartupBytes 4GB

# Create 3 data VHDX files
1..3 | % { New-VHD -Path E:\VMS\Data$_.VHDX -Fixed -SizeBytes 20GB }

# Manually attach volume E:\
fltMC.exe attach svhdxflt E:\
# NOTE 1: Non-CSV deployments of Shared VHDX are not supported. See the disclaimer section of this document.
# NOTE 2: Manual attached is not saved across reboots. You will have to re-issue the command after each reboot.

# Add the 3 data VHDX files to each of the 3 VMs, with Sharing option
1..3 | % { $p = ”E:\VMS\Data” + $_ + ”.VHDX” ; 2..4 | % { $v = ”VM” + $_; Write-Host $v, $p; Add-VMHardDiskDrive -VMName $v -Path $p -ShareVirtualDisk } }

2) Configure CBC-D (DNS, DC)

Start-VM –name VM1
# Preparation steps: Install WS2012R2, rename computer
Rename-Computer -NewName CBC-D -Restart

# Install required roles and features, restarts at the end
Install-WindowsFeature AD-Domain-Services, RSAT-ADDS, RSAT-ADDS-Tools

# Configure Internal NIC with a static IP address for DNS / DC
Get-NetAdapter | Rename-NetAdapter -NewName Internal
Set-NetIPInterface -InterfaceAlias Internal -DHCP Disabled
Remove-NetIPAddress -InterfaceAlias Internal -Confirm:$false
New-NetIPAddress -InterfaceAlias Internal -IPAddress 192.168.100.100 -PrefixLength 24
Set-DnsClientServerAddress -InterfaceAlias Internal -ServerAddresses 192.168.100.100

# create AD forest, reboots at the end
Install-ADDSForest -CreateDNSDelegation:$false -DatabasePath “C:\Windows\NTDS” -DomainMode “Win2012” -DomainName “CBC.TEST” -DomainNetBIOSName “CBC” -ForestMode “Win2012” -InstallDNS:$true -LogPath “C:\Windows\NTDS” -SYSVOLPath “C:\Windows\SYSVOL” 

3) Configure CBC-A1 (Cluster A)

 Start-VM –name VM2

# Preparation steps: Install WS2012R2, rename computer

Rename-Computer -NewName CBC-A1 -Restart

# Install required roles and features, restarts at the end
Install-WindowsFeature File-Services, FS-FileServer, Failover-Clustering
Install-WindowsFeature RSAT-Clustering -IncludeAllSubFeature

# Configure Internal NIC with a static IP address for DNS / DC
Get-NetAdapter | Rename-NetAdapter -NewName Internal
Set-NetIPInterface -InterfaceAlias Internal -DHCP Disabled
Remove-NetIPAddress -InterfaceAlias Internal -Confirm:$false
New-NetIPAddress -InterfaceAlias Internal -IPAddress 192.168.100.101 -PrefixLength 24
Set-DnsClientServerAddress -InterfaceAlias Internal -ServerAddresses 192.168.100.100

# Create 1 Pool, 7 Spaces and Initialize them
# NOTE 3: Running Storage Spaces in a guest is not supported. See the disclaimer section of this document.
# NOTE 4: This unsupported configuration cannot simulate Tiering or Write-back cache, since there are no SSDs.

$s = Get-StorageSubSystem -FriendlyName *Spaces*
New-StoragePool -FriendlyName Pool1 -StorageSubSystemFriendlyName $s.FriendlyName -PhysicalDisks (Get-PhysicalDisk -CanPool $true)
Set-ResiliencySetting -Name Mirror -NumberofColumnsDefault 1 -StoragePool (Get-StoragePool -FriendlyName Pool1)

New-VirtualDisk -FriendlyName Space1 -StoragePoolFriendlyName Pool1 -ResiliencySettingName Mirror –Size 1GB
2..7 | % { New-VirtualDisk -FriendlyName Space$_ -StoragePoolFriendlyName Pool1 -ResiliencySettingName Mirror –Size 3GB }

1..7 | % {
$Letter =”PQRSTUV”[($_-1)]
$Number = (Get-VirtualDisk -FriendlyName Space$_ | Get-Disk).Number
Set-Disk -Number $Number -IsReadOnly 0
Set-Disk -Number $Number -IsOffline 0
Initialize-Disk -Number $Number -PartitionStyle MBR
New-Partition -DiskNumber $Number -DriveLetter $Letter -UseMaximumSize
Initialize-Volume -DriveLetter $Letter -FileSystem NTFS -Confirm:$false
}

# Join domain, restart the machine
Add-Computer -DomainName CBC.TEST -Credential (Get-Credential) –Restart

4) Configure CBC-A2 (Cluster A)

 Start-VM –name VM3

# Preparation steps: Install WS2012R2, rename computer

Rename-Computer -NewName CBC-A2 -Restart

# Install required roles and features, restarts at the end
Install-WindowsFeature File-Services, FS-FileServer, Failover-Clustering
Install-WindowsFeature RSAT-Clustering -IncludeAllSubFeature

# Configure Internal NIC with a static IP address for DNS / DC
Get-NetAdapter | Rename-NetAdapter -NewName Internal
Set-NetIPInterface -InterfaceAlias Internal -DHCP Disabled
Remove-NetIPAddress -InterfaceAlias Internal -Confirm:$false
New-NetIPAddress -InterfaceAlias Internal -IPAddress 192.168.100.102 -PrefixLength 24
Set-DnsClientServerAddress -InterfaceAlias Internal -ServerAddresses 192.168.100.100

# Join domain, restart the machine
Add-Computer -DomainName CBC.TEST -Credential (Get-Credential) –Restart

5) Configure CBC-A3 (Cluster A)

 Start-VM –name VM4

# Preparation steps: Install WS2012R2, rename computer

Rename-Computer -NewName CBC-A3 -Restart

# Install required roles and features, restarts at the end
Install-WindowsFeature File-Services, FS-FileServer, Failover-Clustering
Install-WindowsFeature RSAT-Clustering -IncludeAllSubFeature

# Configure Internal NIC with a static IP address for DNS / DC
Get-NetAdapter | Rename-NetAdapter -NewName Internal
Set-NetIPInterface -InterfaceAlias Internal -DHCP Disabled
Remove-NetIPAddress -InterfaceAlias Internal -Confirm:$false
New-NetIPAddress -InterfaceAlias Internal -IPAddress 192.168.100.103 -PrefixLength 24
Set-DnsClientServerAddress -InterfaceAlias Internal -ServerAddresses 192.168.100.100

# Join domain, restart the machine
Add-Computer -DomainName CBC.TEST -Credential (Get-Credential) -Restart

6) Configure Cluster CBC-A

# Validate cluster
Test-Cluster -Node CBC-A1, CBC-A2, CBC-A3

# Create cluster
New-Cluster –Name CBC-A -Node CBC-A1, CBC-A2, CBC-A3 -StaticAddress 192.168.100.110

# Rename and configure networks
(Get-ClusterNetwork).Name = “Internal”
(Get-ClusterNetwork).Role = 3
(Get-Cluster).UseClientAccessNetworksForSharedVolumes=1

# Rename Witness Disk
$w = Get-ClusterResource | ? { $_.OwnerGroup -eq “Cluster Group” -and $_.ResourceType -eq “Physical Disk”}
$w.Name = “WitnessDisk”

# Add remaining disks to Cluster Shared Volumes
Get-ClusterResource | ? OwnerGroup -eq “Available Storage” | Add-ClusterSharedVolume

# Create Scale-Out File Server
Add-ClusterScaleOutFileServerRole CBC-F

# Create SMB shares
1..6 | % {
MD C:\ClusterStorage\Volume$_\Share
New-SmbShare -Name Share$_ -Path C:\ClusterStorage\Volume$_\Share -FullAccess CBC.Test\Administrator
Set-SmbPathAcl -ShareName Share$_
}

7) Configure CBC-V

 Start-VM –name VM5

# Preparation steps: Install WS2012R2, rename computer

Rename-Computer -NewName CBC-V -Restart

# Install required roles and features, restarts at the end
Install-WindowsFeature RSAT-Clustering -IncludeAllSubFeature

# Configure Internal NIC with a static IP address for DNS / DC
Get-NetAdapter | Rename-NetAdapter -NewName Internal
Set-NetIPInterface -InterfaceAlias Internal -DHCP Disabled
Remove-NetIPAddress -InterfaceAlias Internal -Confirm:$false
New-NetIPAddress -InterfaceAlias Internal -IPAddress 192.168.100.104 -PrefixLength 24
Set-DnsClientServerAddress -InterfaceAlias Internal -ServerAddresses 192.168.100.100

# Join domain, restart the machine
Add-Computer -DomainName CBC.TEST -Credential (Get-Credential) -Restart

# Map the SMB shares
1..6 | % {
$d =”PQRSTU”[($_-1)] + “:”
New-SmbMapping -LocalPath $d -RemotePath \\CBC-F\Share$_ -Persistent $true
}

# Create the test files
1..6 | % {
$f =”PQRSTU”[($_-1)] + “:\testfile.dat”
fsutil file createnew $f (256MB)
fsutil file setvaliddata $f (256MB)
}

# Configure SMB Bandwidth Limits to avoid overloading the virtual environment

Add-WindowsFeature FS-SMBBW
Set-SmbBandwidthLimit -Category Default -BytesPerSecond 16MB

# Run SQLIO (assumes SQLIO.EXE was copied to C:\SLQIO)

c:\sqlio\sqlio.exe -s9999 -kR -t1 -o16 -b8 -BN -LS -frandom -dPQRSTU testfile.dat

# To remove a node while the workload is running (wait a few minutes for rebalancing)
Remove-ClusterNode -Cluster CBC-A –Name CBC-A3

# To add a node while the workload is running (wait a few minutes for rebalancing)
Add-ClusterNode -Cluster CBC-A –Name CBC-A3

8) Running the tests without VMM (from CBC-V)

Start Performance Monitor

Start a performance monitor session

Switch to “Histogram Bar” view to show the performance side-by-side

Add a counter for SMB Server Shares, Data bytes/sec, _total instance for CBC-A1, CBC-A2 and CBC-A3.

Query the cluster shared volume ownership on Cluster A, with 2 nodes

Get-ClusterSharedVolume -Cluster CBC-A | Sort OwnerNode | FT OwnerNode, Name, State -AutoSize

OwnerNode Name           State
——— —-           —–
CBC-A1   Cluster Disk 6 Online
CBC-A1   Cluster Disk 3 Online
CBC-A1   Cluster Disk 4 Online
CBC-A2   Cluster Disk 7 Online
CBC-A2   Cluster Disk 2 Online
CBC-A2   Cluster Disk 5 Online

Run SQLIO to issue 8KB IOs

C:\sqlio\sqlio.exe -s9999 -kR -t1 -o16 -b8 -BN -LS -frandom -dPQRSTU testfile.dat

Add a 3rd node and wait for it to take 1/3 of the load

Add-ClusterNode -Cluster CBC-A -Name CBC-A3

Wait 2 and a half minutes to transition to the following state.

Re- query the cluster shared volume ownership on Cluster A, now with 3 nodes

Get-ClusterSharedVolume -Cluster CBC-A | Sort OwnerNode | FT OwnerNode, Name, State -AutoSize

OwnerNode Name           State
——— —-           —–
CBC-A1   Cluster Disk 3 Online
CBC-A1   Cluster Disk 6 Online
CBC-A2   Cluster Disk 5 Online
CBC-A2   Cluster Disk 7 Online
CBC-A3   Cluster Disk 2 Online
CBC-A3   Cluster Disk 4 Online

9) Installing VMM on CBC-V

# Install .NET Framework
Install-WindowsFeature NET-Framework-Core

# Install Windows Server 2012 R2 ADK
C:\ADK\adksetup.exe
# Select only the “Deployment Tools” and “Windows PE” options

# Install SQL Server 2012 SP1
# New SQL Server standalone installation, Feature Selection: Database Engine Services

When prompted for feature selection, install ALL of the following:

Database Engine Services

Optionally – consider adding the following to ease administration:

Management Tools – Basic and Complete (for running queries and configuring SQL services)

On the Instance configuration, choose a default instance, or a named instance. Default instances are fine for testing and labs. Production clustered instances of SQL will generally be a named instance. For the purposes of the POC, choose default instance to keep things simple.

On the Server configuration screen, set SQL Server Agent to Automatic. Click “Use the same account for all SQL Server Services, and input the SQL service account and password we created earlier.

On the Collation Tab – make sure SQL_Latin1_General_CP1_CI_AS is selected, as that is the ONLY collation supported.

# Install VMM 2012 R2
# Features selected to be added: VMM management server, VMM console
# Database: VirtualManagerDB database will be created on CBCBDA-V
# Service Account: Local System account

10) Configuring VMM on CBC-V

Bring the File Server Cluster under VMM management

Select Fabric and use the option to add Storage Devices

Add a Windows-based file server

Specify the full path to the file server cluster:

Verify the File Server Cluster was properly discovered by VMM

Check the provider

Check the Storage Spaces discovery

Check the Scale-Out File Server and file share discovery

11) Verifying systems’ configuration

PS C:\> Get-PhysicalDisk -CimSession CBC-A1, CBC-A2, CBC-A3 | Sort PSComputerName, Size

PS C:\> Get-Disk -CimSession CBC-A1, CBC-A2, CBC-A3 | Sort PSComputerName, Size

Number Friendly Name                  OperationalStatus Total Size Partition Style PSComputerName
—— ————-                  —————– ———- ————— ————–
4      Microsoft Storage Space Device Online                  1 GB MBR             CBC-A1
10     Microsoft Storage Space Device Online                  3 GB MBR             CBC-A1
8      Microsoft Storage Space Device Online                  3 GB MBR             CBC-A1
0      Virtual HD ATA Device          Online                 40 GB MBR             CBC-A1
4      Microsoft Storage Space Device Online                  3 GB MBR             CBC-A2
5      Microsoft Storage Space Device Online                  3 GB MBR             CBC-A2
0      Virtual HD ATA Device          Online                 40 GB MBR             CBC-A2
4      Microsoft Storage Space Device Online                  3 GB MBR             CBC-A3
5      Microsoft Storage Space Device Online                  3 GB MBR             CBC-A3
0      Virtual HD ATA Device          Online                 40 GB MBR             CBC-A3

PS C:\> Get-ClusterNode -Cluster CBC-A | FT Cluster, NodeName, State, Id -AutoSize

Cluster NodeName State Id
——- ——– —– —
CBC-A  CBC-A1     Up 2
CBC-A  CBC-A2     Up 1
CBC-A  CBC-A3     Up 3

PS C:\> Get-ClusterResource -Cluster CBC-A | FT –AutoSize

Name                             State  OwnerGroup    ResourceType
—-                             —–  ———-    ————
Cluster IP Address               Online Cluster Group IP Address
Cluster Name                     Online Cluster Group Network Name
Cluster Pool 1                   Online Cluster Group Storage Pool
CBC-F                           Online CBC-F        Distributed Network Name
Scale-Out File Server (\\CBC-F) Online CBC-F        Scale Out File Server
WitnessDisk                      Online Cluster Group Physical Disk

PS C:\> Get-ClusterSharedVolume -Cluster CBC-A | FT -AutoSize

Name           State  Node
—-           —–  —-
Cluster Disk 2 Online CBC-A3
Cluster Disk 3 Online CBC-A2
Cluster Disk 4 Online CBC-A3
Cluster Disk 5 Online CBC-A1
Cluster Disk 6 Online CBC-A2
Cluster Disk 7 Online CBC-A1

PS C:\> Get-SmbShare Share* -CimSession CBC-F | FT -AutoSize

Name   ScopeName Path                            Description PSComputerName
—-   ——— —-                            ———– ————–
Share1 CBC-F    C:\ClusterStorage\Volume1\Share             CBC-F
Share2 CBC-F    C:\ClusterStorage\Volume2\SHARE             CBC-F
Share3 CBC-F    C:\ClusterStorage\Volume3\Share             CBC-F
Share4 CBC-F    C:\ClusterStorage\Volume4\Share             CBC-F
Share5 CBC-F    C:\ClusterStorage\Volume5\SHARE             CBC-F
Share6 CBC-F    C:\ClusterStorage\Volume6\Share             CBC-F

Write a Comment