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

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