From the monthly archives:

December 2008

SQL Server 2005 Data Types

December 27, 2008

SQL Server 2005 has the following data types available:

Exact Numerics

BIGINT
INT
SMALLINT
TINYINT
BIT bit
DECIMAL
NUMERIC
MONEY
SMALLMONEY

Approximate Numerics

FLOAT
REAL

Date and Time

DATETIME
SMALLDATETIME

Character

CHAR
VARCHAR
TEXT

Unicode Character

NCHAR
NVARCHAR
NTEXT

Binary

BINARY
VARBINARY
IMAGE

Other

CURSOR
SQL_VARIANT
TABLE
TIMESTAMP
UNIQUEIDENTIFIER
XML

Read the full article →

Database Management 101

December 27, 2008

Author: Khaled Kahlouni
Companies have a wealth of information systems as they continue to collect mountains of data on a daily basis. The need to house their information and have them readily available will always be there. Therefore, creating, monitoring, and maintaining the databases that house the data, pose higher challenges on the Information Technology department; [...]

Read the full article →

So you want to be a Developer?

December 26, 2008

Being a developer is one of the coolest jobs in IT. We will be talking about the creative side of development, and the demands to deliver innovative solutions under pressure and on schedule.

Read the full article →

All about SQL Server

December 25, 2008

SQL Server is not yet Oracle but it does provide a key piece of the Microsoft developer platform. It must be judged for what it is, and that is a great database if designed within its limitations.

Read the full article →

All about the Oracle RDBMS

December 25, 2008

Oracle is the most sophisticated database platform on the market. It is getting easier to do the lower level task, but they keep on adding features that you must keep up with so your developers can stay ahead of the competition.
Oracle provides a great platform for both developers and the DBA. Here we will talk [...]

Read the full article →

So you want to be a Data Modeler?

December 25, 2008

Enity relationship diagrams are your calling. Making sure the data fits the physical structures and all is optimize to leverage the database technology to its fullests. Welcome to the craft, you are a data modeler.

Read the full article →

Welcome to the new DBANotes.com

December 11, 2008

We are currently collecting our things from our last home and will be up and running by the end of 2008.

Read the full article →