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://mikestratton.net/assets/database_design_process.pdf
Basics of Database Design
Although this article does briefly touch on the software development process, ...
Read more →
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
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).
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 – 1 (2,147,483,647).
Integer data from -2^15 (-32,768) through 2^15 – 1 (32,767).
Integer data from 0 through 255.
Integer data with either a 1 or 0 value.
decimal and numeric
Read more →
Fixed precision and scale numeric data ...