Linux: Installing Apache Web Server On Ubuntu Server

Apache (HTTPD) is the most popular web server on the web right now.  It is from the Apache Software Foundation.  A web server serves content to the web.  The power of Apache lies in it's modules which allows you to process scripting languages such as Perl, and PHP.

In this blog we will go over how to install the Apache Http Web Server on the Ubuntu Server:

1.  In the terminal type in the following command

apt-cache search apache  | more

XML In SQL Server : Storing XML In SQL Server

There times when you have to store data as XML in a SQL Server database table.  In this blog we will go over how to store XML as data in SQL Server.  There's an xml data type in SQL Server that we can use to store XML data.

Example: Create a database table that contains a column to store XML data using the xml data type

CREATE TABLE Books
(
  Id INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
  Book XML NOT NULL
);

If you look at the "Book" column for the table "Books" you will see that it has a data type of XML

SQL Server : T-SQL : WHILE Loop Syntax

  WHILE SomeConditionTrue
    BEGIN
      -- Execute code here
    END

SQL Server : T-SQL: IF Conditional Syntax

IF SomeCondition
  BEGIN
    -- Execute some code here
  END
ELSE
  BEGIN
   -- Execute some code here
  END

Else is optional

JavaScript: Arrays

Once you've graduated from the basic variables in JavaScript the next variable you want to learn is the JavaScript array.  An array is a group of variables in a list or collection.  However, you want to word it.  As with everything else a JavaScript array is mutable, meaning you can change it dynamically while you are working on it.

Declaring an Array

var alphabet = new Array();

alphabet [0] = 'A';
alphabet [1] = 'B';
alphabet [2] = 'C';

Declaring an Array In Literal Format
 

var alphabet = ['A','B','C']

JavaScript : Creating JavaScript Objects

JavaScript objects acts differently than objects in the object-oriented programming world. A JavaScript object is mutable meaning it can be changed and is dynamic.

Here is how you would create a JavaScript object:

   var Employee = new Object();
    
   Employee.ID = 1;
   Employee.FirstName = "Jeff";
   Employee.LastName = "Jordan";

You create a new object the new Object() constructor
Or you can create a JavaScript object in a literal format

   var Employee = {
      ID: 1,
      FirstName: "Jeff",
      LastName: "Jordan"
};

You can also include a function as a method in your object like the example below

   var Employee = {
      ID: 1,
      FirstName: "Jeff",
      LastName: "Jordan",

      displayEmployee: function() {
          document.writeln("Employee ID: " + this.ID);
          document.writeln("First Name: " + this.FirstName);
          document.writeln("Last Name: " + this.LastName);
};

SQL Server : T-SQL Basics: Variables

T-SQL variables allows you to store and assign values in your T-SQL code.  Variables is a storage unit in programming which allows you to refer back to it at a later time.

T-SQL variables have the following characteristics:

• Local variables must be prefixed @
• Global variables must be prefixed with @@
• Must be declared with the DECLARE statement
• Must specify the data type when declared

Declaring variables

    DECLARE @employeeID INT;
    DECLARE @firstName CHAR(10), @lastName CHAR(20);

As you can see from the above example you can declare a single variable or declare multiple variables with a comma separated list.

Linux: Find Out Which Shell You Are Using

Start up your Linux machine then do the following:

log4net : Install log4net on ASP.NET Part 1

log4net is the most commonly used ASP.NET logging package.  It is robust and flexible in it's features.  You can choose to log your errors on the database or in a log file or multiple log files.  However, it is not as straight forward to set up.  In this blog we will go through the steps to install log4net using NuGet Package Manager.

1.  Create an empty web project, and call it whatever you like, below is the settings that I have, then click "OK"

Oracle VM VirtualBox : Making VirtualBox Fullscreen by Installing Guest Additions In Linux

If you've installed an operating system in VirtualBox before you've probably noticed the screen is really small even when you switch to Fullscreen mode.  It's so small that you can't even see the fonts for the icons if you have a desktop GUI installed.  To fix this problem VirtualBox provides us with the Guest Additions tool.  Which enables the virtual machine to be viewed at fullscreen.

To enable full screen on a Linux operating system.  Perform the following actions, this should work on all Linux distribution that VirtualBox supports.

1.  Start the virtual machine that you want to make full screen