About Database Tips

Owner: yuzz

Listed in: Computers

Language: English

Tags: database, mysql, mssql, oracle

Report it

Site Statistics

Unique Visitors Today:
Page Views Today:
Unique Visitors this Week:
Page Views this Week:
Unique Visitors this Month:
Page Views this Month:
Total Unique Visitors:
Total Page Views:
Total Hits Out:
Traffic Chart

Latest Blog Posts for Database Tips

  • Database Corruption & Repair
    on Nov 15, 2009 in mysql access mssql database oracle
    A Microsoft Access database may consist of data and indexes as well as the database objects: tables, queries, reports, forms, macros and modules. The best way to protect against loss of data and databases due to corruption is to backup your databases...
  • Microsoft Access vs Microsoft SQL Server
    on Nov 11, 2009 in mysql access mssql database oracle
    Microsoft Access is a relational database management system (RDBMS) that is packaged with the Microsoft suite of office products to run under the Microsoft Windows operating system. Microsoft Access is a Visual Basic (VB) based application that allow...
  • Generate HTML Help Files for MS Access
    on Nov 10, 2009 in mysql access mssql database oracle
    Certainly, documenting any process is part of the job, not only in Information Technology but in many other fields as well. In creating software, one must of course provide some sort of user guide or help file, not to mention technical documentation...
  • Introduction to Data Modeling
    on Nov 10, 2009 in mysql access mssql database oracle
    Data modeling is the practice of representing data structures and their relationships through conceptual modeling. The benefits of implementing this process during the design phase of your database project include improved data integrity, a more effi...
  • Splitting a Microsoft Access Database
    on Nov 8, 2009 in mysql access mssql database oracle
    One of the important decisions that must be made before a Microsoft Access Database can be distributed is the form that the database will assume after the deployment. In this article, it addresses the pros and cons of splitting the database, and impl...
  • Normalize the Data
    on Nov 4, 2009 in mysql access mssql database oracle
    Once you’ve decided upon and drafted the tables and fields you believe that you will require in your database, the next stage is to enter some sample data in the tables and look for any potential problems with maintaining the data. Identifying pos...
  • Access Database Repair and Recovery Software
    on Nov 3, 2009 in mysql access mssql database oracle
    AccessFIX is a Microsoft Access database repair and recovery software that restores damaged MS Access files, rebuilding the table data. This utility works with MS Access 95, 97, 2000, XP, and 2003: When a Microsoft Access database shows an error w...
  • Microsoft Access Database Security
    on Nov 1, 2009 in mysql mssql database oracle
    To control what an individual user or group of users can do with database objects, you can secure a Microsoft Access database. As you create database objects, you might consider who will use them and what types of activities the users should be allow...
  • Defining an Attribute Makeup
    on Oct 27, 2009 in mysql mssql database oracle
    Once you have decided on your initial attributes (database fields), you may need to look into how to break this attribute down, a process more commonly known as decomposing attributes. Decomposing an attribute takes the attribute from its original fo...
  • What Makes a Good Primary Key?
    on Oct 27, 2009 in mysql mssql database oracle
    Good primary keys are essential to good database design. They let you query and modify each table row individually without changing other rows in the same table. When you evaluate candidates for a table's primary key, follow these rules: * The pri...
Loading Comments...


{ds_PageTotalItemCount} commentcomments

Post a Comment