Good Database Design

Software Engineering & the Basics of Good Database Design

What are the basics of good database design? How does one go about effectively administering a database? How does database design relate to the creation, maintenance and scalability of software? This article will answer those questions and more, in an effort to help you understand the software development process.

Read the full, pdf version of this article: http://www.mikestratton.net/assets/database_design_process.pdf

Basics of Database Design

Although this article does briefly touch on the software development process, ...

Read more →
0

SQL Data Type Reference

Microsoft SQL Database – Data Types Reference List

The following data types are associated with Microsoft’s SQL database.
Article Source: http://msdn.microsoft.com/en-us/library/aa258271(SQL.80).aspx


Exact Numerics

Integers

bigint
Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).

int
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 – 1 (2,147,483,647).

smallint
Integer data from -2^15 (-32,768) through 2^15 – 1 (32,767).

tinyint
Integer data from 0 through 255.

bit

bit
Integer data with either a 1 or 0 value.

decimal and numeric

decimal
Fixed precision and scale numeric data ...

Read more →
0