dbanotes.com | Monthly Archive

Archive | December, 2008

SQL Server 2005 Data Types

By Michael Ritacco on December 27, 2008 in SQL Server

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 full story • Comments { 0 }

Database Management 101

By Michael Ritacco on December 27, 2008 in Database Administration

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 [...]

Read full story • Comments { 1 }

So you want to be a Developer?

By Michael Ritacco on December 26, 2008 in Database Development

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 full story • Comments { 0 }

All about SQL Server

By Michael Ritacco on December 25, 2008 in SQL Server

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 full story • Comments { 1 }

All about the Oracle RDBMS

By Michael Ritacco on December 25, 2008 in Oracle Database

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 [...]

Read full story • Comments { 1 }

So you want to be a Data Modeler?

By Michael Ritacco on December 25, 2008 in Data Modeling

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 full story • Comments { 2 }