Archive for 'Database'
Building a SQL Server 2008 R2 Database Server
Posted on 16. Mar, 2011 by joshhrob.
This build doc demonstrates the installation of SQL Server 2008 R2 on a 64-bit Windows 2008 R2 server. It also discusses some best practices to consider when planning your database implementation. This Document is divided into the following sections: Things to Consider Pre-Installation Tasks Formatting Drives Setting Page File Create Service Accounts Run SQL Server [...]
Continue Reading
Installing Ubuntu 10.10 Server 64-bit (General Purpose LAMP/Web Server)
Posted on 11. Mar, 2011 by joshhrob.
This build doc demonstrates the installation of a general purpose Linux web server using Ubuntu 10.10. This is an update to our LAMP document from last year: Building LAMP on Ubuntu Part 1. In this build I used the ubuntu-10.10-server-amd64.iso image downloaded from: http://releases.ubuntu.com/10.10/. After downloading the iso file, you must either burn it to [...]
Continue Reading
Oracle SQL Functions Overview
Posted on 30. Dec, 2010 by joshhrob.
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
Building a SQL 2005 Database on Windows 2003
Posted on 22. Sep, 2009 by joshhrob.
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
Building LAMP on Ubuntu Part 1
Posted on 17. Aug, 2009 by joshhrob.
This build document outlines the installation and setup of a basic LAMP (Linux Apache MySQL PHP) web server using Ubuntu 9.04. Please note we have updated this doc for Ubuntu 10.10 here: Installing Ubuntu 10.10 Server 64-bit (General Purpose LAMP/Web Server) This build will be broken up into 3 parts: Part 1: Installing Ubuntu Operating [...]
Continue Reading
