Oracle Database provides various built-in functions to perform special operations such as conversions, calculations, transformations, and comparisons. Single Row Functions Single row functions refer to functions that act on a single row of data, as opposed to multi-row functions which act of a set of data rows. This section covers many of the most common [...]
Continue Reading
This documents demonstrates the configuration of a Windows Server 2008 R2 AD Domain Controller. It assumes a plain vanilla Windows Server 2008 build which can be found here: Building Windows Server 2008 (Enterprise R2 64 bit). To begin, click on Start and Run and enter the command: dcpromo The AD installer begins installing files. This [...]
Continue Reading
This document demonstrates the installation of a generic Windows Server 2008 Enterprise R2 (64 bit) build. To begin, insert the installation DVD and power on the system. Select language and country preferences and press Next. Press Install Now Select OS version. In this case: Windows Server 2008 R2 Enterprise (Full Installation). Accept license terms. Select [...]
Continue Reading
This document outlines 10 easy-to-implement steps to lockdown a RedHat Linux server. This document assumes a fresh vanilla RedHat 5.4 install as described in the post Installing RedHat 5.4 64 bit. Not all of the below steps are appropriate for all systems. You will need to use your judgment to pick and choose which security [...]
Continue Reading
Interested in getting VMware Certified? Check out this VCP 410 Exam Prep This document outlines the steps to install VMware tools on Redhat 5.4. This document assumes a fresh vanilla install as described in the post Installing RedHat 5.4 64 bit. To begin log into your RedHat server as a user and right click on [...]
Continue Reading
This document demonstrates a general purpose RedHat 5.4 64-bit linux server build. In this build we will be using the rhel-server-5.4-x86_64-dvd.iso image downloaded from redhat.com. Insert CD/DVD and power on system. At the splash screen press Enter key to begin install. Select OK and press Enter to run a media test (optional). Review License Agreement [...]
Continue Reading
This document outlines the steps to building a general purpose Microsoft SQL Server 2005 database on Windows Server 2003 Enterprise. Formatting Disks In this example we will be working with a single 80 GB volume. Most likely in a production environment you will be storing your database on mirrored storage and/or a SAN. Ideally, it [...]
Continue Reading
Windows SharePoint Services (WSS) can be installed in two ways; Single Server or Basic installation and Server Farm installation. In the Basic setup, SQL 2005 embedded edition gets installed automatically as part of the WSS setup and a default SharePoint web application is also created when the Post setup configuration is complete. The major limitation [...]
Continue Reading
