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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE
   ► KBRole-Based T...DBA & Data   Print This     

DBA KB: DBA & Data Topic

Topics

33 Articles Found in the DBA & Data Topic  (or the sub-topic above)

  KB Article    

Mike Prestwood
1. ANSI ANSI is an acronym for American National Standards Institute.
16 years ago, and updated 12 years ago

Definition
Nothing New Since Your Last Visit
9982
Hits

DBA, Databases, & Data

Mike Prestwood
2. ASCII ASCII is an acronym for American Standard Code for Information Interchange. The ASCII set consists of 7-bit codes that represent 128 standard characters, including letters, numbers, and symbols. The first 128 characters in the ASCII set, the extended ASCII set, and the ANSI set are the same.
16 years ago, and updated 12 years ago

Definition
Nothing New Since Your Last Visit
9664
Hits

DBA, Databases, & Data

Assignment help
3. Assignment help https://www.ozassignments.com
5 months ago
(1 Comments , last by Pervez.J )

Link
Nothing New Since Your Last Visit
176
Hits

DBA, Databases, & Data

Mike Prestwood
4. BDE BDE is an acronym for Borland Database Engine (previously referred to as IDAPI and before that it was ODAPI).
16 years ago, and updated 11 years ago

Definition
Nothing New Since Your Last Visit
12060
Hits

DBA, Databases, & Data

Mike Prestwood
5. Common Table Structures Reference of common table structures
17 years ago

KB Post
Nothing New Since Your Last Visit
8310
Hits

DBA, Databases, & Data

Scott Wehrly
6. Concatenation of VARCHAR fields yields NULL 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 to KB Topic: ANSI SQL Scripting
17 years ago
(1 Comments )

KB Post
Nothing New Since Your Last Visit
8588
Hits

DBA, Databases, & Data

Jeffrey K. Tyzzer
7. Corporate Database Administration Corporate database admin standard first published by Prestwood Software in 1996.
17 years ago, and updated 12 years ago

Article
Nothing New Since Your Last Visit
19490
Hits

DBA, Databases, & Data

Jeffrey K. Tyzzer
8. Data Element Naming Standard This paper articulates the standard for naming data elements (entity attributes).
17 years ago, and updated 12 years ago
(3 Comments )

Article
Nothing New Since Your Last Visit
33969
Hits

DBA, Databases, & Data

Joshua Delahunty
9. Data Migration, Paradox to SQL Server

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

13 years ago, and updated 9 years ago

KB Post
Nothing New Since Your Last Visit
14508
Hits

DBA, Databases, & Data

Jeffrey K. Tyzzer
10. Data Normalization - The Normal Forms

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

17 years ago, and updated 11 years ago

Article
Nothing New Since Your Last Visit
12570
Hits

DBA, Databases, & Data

Wes Peterson
12. Databases: Which are Best? Which databases Prestwood Software prefers - and why.
13 years ago, and updated 11 years ago
(1 Entries , last by mprestwood )

Blog
Nothing New Since Your Last Visit
13893
Hits

DBA, Databases, & Data

Mike Prestwood
14. DBMonster.com http://www.dbmonster.com/
11 years ago

Link
Nothing New Since Your Last Visit
6018
Hits

DBA, Databases, & Data

Mike Prestwood
15. Drop Index Drop an index with the DROP INDEX statement.
Posted to KB Topic: ANSI SQL Scripting
12 years ago

Flashcard
Nothing New Since Your Last Visit
5314
Hits

DBA, Databases, & Data

Wes Peterson
16. ElevateDb - The New Kid on the DB Block For years, Elevate Software has provided the elegant, fast, and stable DBISAM database. They're recently released ElevateDB, an amazing follow-up.
12 years ago

News
Nothing New Since Your Last Visit
9545
Hits

DBA, Databases, & Data

Mike Prestwood
17. Finding Duplicate Values Using SQL To find duplicate values in the same field, you need to use an alias with the same table twice.
Posted to KB Topic: ANSI SQL Scripting
17 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
7765
Hits

DBA, Databases, & Data

Mike Prestwood
18. Learn the Three Normal Forms in One Sentence The three normal forms can be summed up in the following phrase: All the fields of a table should relate to the key, the whole key, and nothing but the key.
12 years ago
(2 Comments , last by mprestwood )

Tip
Nothing New Since Your Last Visit
14888
Hits

DBA, Databases, & Data

Mike Prestwood
19. Master Table A master table in a multitable relationship is the primary table. For every record in the master table, there can be many records in the detail table. If you are only dealing with one table, then it is the master table. A detail table in a multitable relationship is the table whose records are subordinate to those of the master table. A detail table is also called a slave table, a child table, or a many table.
12 years ago
(2 Comments , last by Timmy.F )

Definition
Nothing New Since Your Last Visit
15145
Hits

DBA, Databases, & Data

Mike Prestwood
20. Naming Fields: Choose a Context Name When naming fields/columns in a table, use ONE name for the data in the field. For example, although states are called provinces and other names in other coutries, use one or the other in the database but not both. Use CompanyState, avoid CompanyStateProvince. Use labels in your website or program to switch context.
11 years ago

Tip
Nothing New Since Your Last Visit
10140
Hits

DBA, Databases, & Data

Mike Prestwood
21. Not In SQL Select Query

The following selects all the records in Table1 where IDField is not in Table2.

Posted to KB Topic: ANSI SQL Scripting
10 years ago

Code
Nothing New Since Your Last Visit
10307
Hits

DBA, Databases, & Data

Wes Peterson
22. ODBMS or RDBS? 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.
12 years ago, and updated 12 years ago

Blog
Nothing New Since Your Last Visit
8417
Hits

DBA, Databases, & Data

Mike Prestwood
23. Optimistic Locking A locking mechanism that allows other users to edit a record that is currently being edited. Essentially, last in wins or edits are discarded usually with an error.
11 years ago

Definition
Nothing New Since Your Last Visit
9177
Hits

DBA, Databases, & Data

pande.dhiraj
24. ORA-00900: invalid SQL statement

The ORA-00900 error displays automatically when erp is running properly but may be caused by a constraint violation.

12 years ago, and updated 9 years ago

Error
Nothing New Since Your Last Visit
14820
Hits

DBA, Databases, & Data

Wes Peterson
25. Oracle Berkely DB XML http://www.oracle.com/database/berkeley-db/xml/index.html
12 years ago, and updated 12 years ago

Download
Nothing New Since Your Last Visit
13403
Hits

DBA, Databases, & Data

swawsji
26. oracle silent mode installation using response file 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.
11 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
10577
Hits

DBA, Databases, & Data

Mike Prestwood
27. Pessimistic Locking A locking mechanism that prevents other users from entering edit mode on a record that is currently locked.
11 years ago

Definition
Nothing New Since Your Last Visit
9425
Hits

DBA, Databases, & Data

Mike Prestwood
28. Reverse sort order in a select Is there a way to reverse order a select statement?
Posted to KB Topic: ANSI SQL Scripting
17 years ago

FAQ
Nothing New Since Your Last Visit
11764
Hits

DBA, Databases, & Data

Joshua Delahunty
29. SQL Server 2005 Database Diagram caveat Tip about renaming tables in SQL Server 2005
13 years ago, and updated 13 years ago

KB Post
Nothing New Since Your Last Visit
7380
Hits

DBA, Databases, & Data

Joshua Delahunty
30. SQL Server 2005 Database Diagram tool Tips on use of SQL Server 2005 Database Diagramming Tool
13 years ago, and updated 13 years ago

KB Post
Nothing New Since Your Last Visit
7404
Hits

DBA, Databases, & Data

Joshua Delahunty
31. SQL Server Express Tips on setup of SQL Server Express
13 years ago, and updated 13 years ago

KB Post
Nothing New Since Your Last Visit
7126
Hits

DBA, Databases, & Data

Mike Prestwood
32. Standard Delimited Format (SDF) SDF is an acronym for standard delimited format. An SDF is a text file formatted in a particular style. Each field is enclosed in quotation marks and separated by a comma. Each line ends with a carriage return and a linefeed.
16 years ago, and updated 12 years ago

Definition
Nothing New Since Your Last Visit
9235
Hits

DBA, Databases, & Data

Wes Peterson
33. Tab-delimited format (TDF) In a Tab-delimited format (TDF) file, each field is delimited by a tab character. Each record is delimited with a carriage return and line feed. TDF has the advantages of being immune to commas and quotation marks within the data itself.
12 years ago, and updated 12 years ago

Definition
Nothing New Since Your Last Visit
11320
Hits

DBA, Databases, & Data

Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

New DBA, Databases, & Data Knowledge Base Post...

Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).

Post New...

Tidbit Post: Short Flashcard FAQ Definition Quick Tip Code Snippet
Longer Post: Full Article General Post File Link Error News
Other: Blog Topic
Or, if YOU have a question...
  DBA, Databases, & Data Message Board
Follow PrestwoodBoards on: 


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