I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► KBDBA Knowledge Base  Print This    All Groups  

DBA, Databases, & Data Tech Articles

These Articles are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the DBA sub-topics.

Contribute an Article

32 DBA, Databases, & Data Articles

Group: DBA, Databases, & Data


Topic: ANSI SQL Scripting

When you have a concatenation of two or more CHAR or VARCHAR fields in a SELECT statement, and one of the fields is NULL, the resulting value will be NULL.
Posted By Scott Wehrly, Post #100030, KB Topic: ANSI SQL Scripting
  +Add Comment  (1 Comments)

To find duplicate values in the same field, you need to use an alias with the same table twice.
Posted By Mike Prestwood, Post #100061, KB Topic: ANSI SQL Scripting
  +Add Comment




Topic: DBA & Data

Reference of common table structures
Posted By Mike Prestwood, Post #100054, KB Topic: DBA & Data
  +Add Comment

Corporate database admin standard first published by Prestwood Software in 1996.
Posted By Jeffrey K. Tyzzer, Post #100055, KB Topic: DBA & Data
  +Add Comment

This paper articulates the standard for naming data elements (entity attributes).
Posted By Jeffrey K. Tyzzer, Post #100058, KB Topic: DBA & Data
  +Add Comment  (3 Comments)

some tips for data migration, especially with bitfield, or "logical" field types.

Posted By Joshua Delahunty, Post #100362, KB Topic: DBA & Data
  +Add Comment

by Jeffrey K. Tyzzer. In 1970, Dr. E.F. Codd's seminal paper "A Relational Model for Large Shared Databanks" was published in Communications of the ACM. This paper introduced the topic of data normalization, so-named because, at the time, President Nixon was normalizing relations with China.

Data normalization is a technique used during logical data modeling to ensure that there is only one way to know a fact, by removing all structures that provide more than one way to know the same fact as represented in a database relation (table). The goal of normalization is to control and eliminate redundancy, and mitigate the effects of modification anomalies -- which are generally insertion and deletion anomalies. (Insertion anomalies occur when the storage of information about one attribute requires additional information about a second attribute. Deletion anomalies occur when the deletion of one fact results in the loss of a second fact).

Normalization
There are six generally recognized normal forms of a relation: first normal form, second normal form, third normal form, Boyce/Codd normal form, fourth normal form, and fifth normal form, also called projection/join normal form. Other normal forms (e.g., Domain/Key) exist but will not be discussed here. The normal forms are hierarchical, i.e., each normal form builds upon its predecessor. Although many people consider a relation to be normalized only when it is in third normal form, technically speaking, a relation in only first normal form can be considered...

Posted By Jeffrey K. Tyzzer, Post #100059, KB Topic: DBA & Data
  +Add Comment

List of common field names, along with suggested field type and length. These are only suggestions and shouldn't be taken as gospel. Use as a starting point.
Posted By Mike Prestwood, Post #100002, KB Topic: DBA & Data
  +Add Comment

Which databases Prestwood Software prefers - and why.
Posted By Wes Peterson, Post #100406, KB Topic: DBA & Data
  +Add Comment  (1 Comments)

Description of dBASE IV field types
Posted By Mike Prestwood, Post #100056, KB Topic: DBA & Data
  +Add Comment  (1 Comments)

For several years now, Object Relational databases have intrigued many developers, myself included. Most of us also rely on more traditional RDBMS systems. Well, a debate is raging, and you're invited to join.
Posted By Wes Peterson, Post #100583, KB Topic: DBA & Data
  +Add Comment

You can automate the installation and configuration of Oracle software, either fully or partially, by specifying a response file when you start the Oracle Universal Installer.
Posted By swawsji, Post #101294, KB Topic: DBA & Data
  +Add Comment

Tip about renaming tables in SQL Server 2005
Posted By Joshua Delahunty, Post #100363, KB Topic: DBA & Data
  +Add Comment

Tips on use of SQL Server 2005 Database Diagramming Tool
Posted By Joshua Delahunty, Post #100364, KB Topic: DBA & Data
  +Add Comment

Tips on setup of SQL Server Express
Posted By Joshua Delahunty, Post #100361, KB Topic: DBA & Data
  +Add Comment




Topic: Desktop Databases

Since the introducton of XP, Windows programs have benefitted from an application "Manifest." This was covered in an earlier article. This is an update to that information, pertaining to Windows Vista
Posted By Wes Peterson, Post #100816, KB Topic: Desktop Databases
  +Add Comment

Virtualization is a concept greatly expanded in Vista. This article discusses the impact of Application Virtualization on you development. It can have a huge impact on how the programs you write will behave when installed on Vista.

Posted By Wes Peterson, Post #100818, KB Topic: Desktop Databases
  +Add Comment  (1 Comments)

Overview of DDE.

Posted By Mike Prestwood, Post #100146, KB Topic: Desktop Databases
  +Add Comment

Most development tools give us easy access to MAPI. Some offer MAPI as the ONLY easy way to send email. Still, is MAPI the best way to go?
Posted By Wes Peterson, Post #100544, KB Topic: Desktop Databases
  +Add Comment  (2 Comments)

For a while, now, Windows has supported a new mechanism for installing applications: MSI. This is quite a bit different than the familiar setup.exe, and here we begin exploring the differences - and the significance of MIS installations.
Posted By Wes Peterson, Post #100817, KB Topic: Desktop Databases
  +Add Comment  (2 Comments)

Is there a right way to handle version information in our projects? Could we do a better job of it?
Posted By Wes Peterson, Post #100404, KB Topic: Desktop Databases
  +Add Comment  (2 Comments)




Topic: Interbase

Interbase database and field specifications
Posted By Mike Prestwood, Post #100057, KB Topic: Interbase
  +Add Comment




Topic: Microsoft SQL Server

Learn how to make an easy SQL Server Script that will automatically back up all your databases in a simple way.

Posted By Bryan Valencia, Post #102439, KB Topic: Microsoft SQL Server
  +Add Comment  (1 Comments)

Need to grant EXECUTE permission to a low-permission user for all the Stored Procedures in your database?

The code in this article will do the trick for you.

Posted By Wes Peterson, Post #102563, KB Topic: Microsoft SQL Server
  +Add Comment  (2 Comments)




Topic: MS SQL 2005

SQL Server 2005 as an Embedded Database Choice in your Application
Posted By Adam Lum, Post #100892, KB Topic: MS SQL 2005
  +Add Comment

SQL Server 2005's available management tools make moving databases from one machine to another a snap. This article describes the steps
Posted By Joshua Delahunty, Post #100372, KB Topic: MS SQL 2005
  +Add Comment

Whether you're a total newbie to databases, and need of a good foundation, a seasoned pro that wants a little review, or a developer that wants to help educate his clients, a series of well executed training videos is a great way to go.
Posted By Wes Peterson, Post #100633, KB Topic: MS SQL 2005
  +Add Comment




Topic: MS SQL 97 / 2000

The preferred technique for transferring an MS SQL database is to do a complete backup and restore.
Posted By Mike Prestwood, Post #100264, KB Topic: MS SQL 97 / 2000
  +Add Comment

Have you installed SQL Server 2005, set all the right SQL Server settings, and still can't browse the server? If you're running XP Pro service pack 2 or later, you may have forgotten to fix this issue at the FIREWALL! (doh!)

Posted By Joshua Delahunty, Post #100374, KB Topic: MS SQL 97 / 2000
  +Add Comment




Topic: SQL Servers

In this article, you will be shown a few generic methods to optimize your SQL queries.  This information is not database-specific (other than in a few places) and should apply to any SQL based database.

Posted By Bryan Valencia, Post #102126, KB Topic: SQL Servers
  +Add Comment

Think globally, act locally.  How many times have you needed to determine the geographic distance between two places?  This tutorial will show you how to accomplish just that.

All data and functions exist in a SQL Server Database, and can be used in VB.NET, C#.NET, Paradox, Delphi, or any other language that can call a database function.

Posted By Bryan Valencia, Post #102088, KB Topic: SQL Servers
  +Add Comment  (3 Comments)

The installation of the SourceGear Vault client control appears to trash SQL Server Management Studio and Visual Studio.

Here's the fix that worked for me.

Posted By Wes Peterson, Post #102298, KB Topic: SQL Servers
  +Add Comment  (1 Comments)


Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech