SQL

Understand SET Operators

Hi All,

I assume you heard about SET, usually it can be heard in Mathematics and SET operators in SQL has the same meaning as that one as well for UNION and INTERSECT.

SET operators includes

  • UNION
  • INTERSECT
  • EXCEPT
  • APPLY

Union

It returns a result set of distinct rows combined from both sides. This means that it will display all the records from both table but will not show the duplicate rows, it’s like as if every record is unique.

My own concept: ((Purchasing + Sales) – Duplicates).

Capture

Union ALL

It returns a result set with all rows from both sets. Consider that it display all the records from each of the table. Duplicates will occurs here.

My own concept: (Purchasing + Sales).

Intersect

It returns only distinct rows that appear in both result sets. The results shows only exist in both table.

My own concept: (Purchasing & Sales)

Capture

Except

It returns only distinct rows that appear in the left set but not the right.

My own concept: (Sales – (Purchasing & Sales) – Purchasing)

Capture

Apply

**I have no idea how this works, do you? mind explain it to me ^.^


-Farrah K.

SQL

Understand JOIN Statements

Hi all,

Before this, I had a bit confuse on some of the SQL statement especially the JOIN statements. Ok, Let’s see…

JOIN statements

There are 3 types of JOIN:

  • Cross
  • Inner
  • Outer

Cross

It basically combines all the rows in the both tables. Meaning that if you have 20 rows in table 1 and 8 rows in table 2, therefore, the number of rows will be after cross join both of them is 20*8 = 160 rows (Cartesian Product).

Inner

Returns only rows where a match is found in both tables.  So when there is comparison between 2 tables it will only search and display the matching rows.

Outer

Returns all rows from one table and any matching rows from second table. This mean that it will display all the rows in table 1 and display only the matching rows from the table 2. (this example is the left join).

In outer join there are 3 type of outer join which they are:

  • Left

Note: It will return all the rows in the left table even if there are no matches in the right table.

  • Right

Note: It will return all the rows in the right table even if there are no matches in the left table.

  • Full

Note: It will return all the rows in the left table 1 and in the right table, If there are no matches in either of the table, those rows will be listed as well.


That’s it. Hope this helps.

– Farrah K.

Programming

First C# Application

As a programmer we have seen this ‘Hello World’ for so many times especially when we want to create a program with a new programming languages. So today I’ll be showing you the steps on creating a Hello World application using C#.

I believe there are more than one developer tool to write a C# application, as for this blog I’ll be using the Microsoft Visual Studio Ultimate 2012.

OK, here we go…

  • Open up the Microsoft Visual Studio.
  • Click New Project, select Visual C# and select Console Application as shown below.

Untitled

  • Name, HelloWorld and Click OK.
  • And you’ll see something like this:

Untitled


  • Tips: it is recommended to display the line numbers so it is easier for you to refer to.
  • To enable the Line numbers all you have to is:
    • Go to Tools > Options…
    • Expand the Text Editor > All Languages > General.
    • Select Line numbers under Display.

Untitled


Now, let’s write some code

  • Under the main method, write the code like this:

Console.WriteLine("Hello World");
Console.ReadLine();

  • To run the program, Click on the Start on the menu bar.

Untitled

  • And you’ll see:

Untitled


That’s it! You just created your Hello World using C#.

-Farrah K.

Networking

Hyper-V Connections

In the Hyper-V, there are 3 types of virtual switches:

  • External
  • Internal
  • Private

External

External virtual networks are used where you want to allow communications between

  • Virtual machine to virtual machine on the same physical server
  • Virtual machine to parent partition (and visa-versa)
  • Virtual machine to externally located servers (and visa-versa)
  • (Optional) Parent partition to externally located servers (and visa-versa)

Internal

Internal virtual networks are used where you want to allow communications between

  • Virtual machine to virtual machine on the same physical server
  • Virtual machine to parent partition (and visa-versa)

An internal network would commonly be used to build a test environment where you need network connectivity into the virtual machines from the parent partition itself.


Private

Private virtual networks are used where you want to allow communications between

  • Virtual machine to virtual machine on the same physical server

A private network would commonly be used where you need complete isolation of virtual machines from external and parent partition traffic. DMZ workloads running on a leg of a tri-homed firewall, or an isolated test domain are examples where this type of network may be useful.


-Farrah K.

Installation, Solution

SharePoint 2013 installation error

Hi all,

While installing the SharePoint 2013 onto my VM (Windows Server 2012) I’ve encountered this problem during the prerequisite installer.

Capture

“The tool was unable to install Application Server Role, Web Server (IIS) Role”

The steps to fix it are:

  • Go to windows > system32.
  • Look for servermanager.exe, copy the file and paste in the same folder.
  • Rename it to servermanagercmd.exe.
  • Re-run the Prerequisites installer again, it will work.

**Make sure you enabled the Web Server (IIS) role and the Application Server role in Server Manager.

-Farrah K.

Installation

Introduction to Hyper-V

Hi all,

Before talking about Hyper-V let’s talk a bit on Virtualization. Virtualization takes place on the same hardware platform after installing specific software – hypervisor. The hypervisor is an additional layer between physical and virtual spheres; it manages the system’s hardware resources so they are distributed efficiently among virtual machines (VMs).

List below are the Microsoft Virtualization Solutions:

  • Server Virtualization (Hyper-V) -> which we will be focusing on
  • Client Virtualization
  • Profile Virtualization
  • Azure Virtual Machines
  • Desktop Virtualization (VDI)
  • Application Virtualization (App-V)

Personally for me, virtual machine is important especially when comes to testing because if something went wrong it can be restarted or create new one without causing damages to the your computer.


So what exactly is Hyper-V?

It basically enables you to run more than one operating system using virtual machine at the same time on the same PC.

Steps to enable Hyper-V:

  • Go to Control Pane > Programs and Features.

Untitled

  • Click on Turn Windows features on or off.

Untitled

  • Select Hyper-V as shown in the red rectangle below.

Untitled

  • Click OK and restart your computer.
  • After restarted, you’ll see the Hyper-V on your start menu.

Steps to create virtual machine:

  • Run the Hyper-V Manager.
  • Right-click your computer name on the side bar.

Untitled

  • Select New > Virtual Machine.
  • Window as shown below will pop up, click Next.

Untitled

  • On Specify Name and Location page, enter the name of your virtual machine.

Untitled

  • On Specify Generation page, use the default setting and click Next.

Untitled

  • Next is the Assign Memory page, you can enter value (less than your memory size) to the Startup Memory or use the default value, click Next..

Untitled

  • Use default setting on Configure Networking page and click Next.

Untitled

  • For Connect Virtual Hard Disk page. Check your VM name, location and size (less than your hdd size). Click Next.

Untitled

  • Next is the Installation Option page, if you’re using an image file (.iso) then click on the second option button as shown below and specify the location of the image file. Click Finish.

Untitled

  • To run the VM, right-click the virtual machine on the list
  • First, Start the virtual machine then Connect

Untitled

  • And you are ready to install your operating system to be installed on VM.

That’s it! Enjoy using Hyper-V.

-Farrah K.

Networking

Network Tools

Let’s do something to your network with TCP/IP basic tools:

Command Prompt – command line interface. In order to run the command prompt, there’s a trick for it which is by pressing Windows key + R then type cmd and press enter.

ipconfig – display current network configuration of the your computer. If you would like to display a detailed information of the configuration then you can type ipconfig /all. Apart from this there are also others and you can type ipconfig ? and it will display all the parameters that can be used.

ping – for verifying connection. It can ping by ip address, url address or computer name and if there is ipv6 then you can ping it with parameter -6.

tracert – determine the path take to a destination. It can ping by ip address, url address or computer name.


Here comes the advanced TCP/IP tools:

Netstat – displays active TCP connection, ports, Ethernet statistics, IP routing, IPv4 and IPv6 statistics.

Nbtstat – display NetBIOS over TCP/IP protocol statistics, NetBIOS name tables and NetBIOS name cache.

PathPing – it combines feature of the tools Ping and TraceRT that includes additional information. It can show the degree of packet lost at any specified router or link.

Nslookup – display information that can use to diagnose Domain Name System (DNS).

Netsh – it display or modify the network configuration of a computer currently running.

Route (-print) – displays and modifies the entries in the local IP routing table.

Net – can be used to test network connectivity on your network.

Telnet – enables to communicate with a remote computer that is using the Telnet protocol. Note** if you need some help just type it ? after the command.

-Farrah K.