Databases Sitemap - Page 4 2014-09-19

MySQL
What is MySQL? Find out here! Databases.

Data
What is data? Find out here! Databases.

Index
What is an index? Find out here!

The Rational Guide to Microsoft Office Access 2007 Templates
Zac Woodall's book provides an excellent introduction to creating and sharing Microsoft Access database templates. It's a wonderful reference for anyone who needs to occasionally or regularly design or develop Access templates.

Resource Governor Definition
Looking for a definition of Resource Governor? Check the About.com Databases Glossary!

SQL Server 2012: Top Five New Features in SQL Server Denali
Microsoft recently released the first Community Technical Preview (CTP) of the newest version of SQL Server, code-named Denali. Three years after the release of SQL Server 2008, this new version of the popular database platform promises several exciting new features.

Access Hacks: Tips and Tools for Wrangling Your Data
If you're an experienced Access user, there's no doubt you'll find something useful in this book. It's packed full of so many useful tips and techniques that there's guaranteed to be something you don't already know!

Snapshot Replication Definition - About Databases Glossary
What is snapshot replication? Find out in the About Databases Glossary

10 Time-Saving Tips for Microsoft Access 2007
Looking to shave some time off your daily Microsoft Access administration and design tasks? There are many great, little-known features of this program that you can use to improve the efficiency of your database experience. I've put together a collection of ten tips that will improve your Microsoft Access experience.

Time-Saving Tips for Microsoft Access 2010
Looking to shave some time off your daily Microsoft Access administration and design tasks? There are many great, little-known features of this program that you can use to improve the efficiency of your database experience. I've put together a collection of ten tips that will improve your Microsoft Access experience.

Application Programmer Interface (API)
Looking for a definition of Application Programmer Interface (API)? Find it here!

How to Change the Default Database Format in Access 2010
Access 2010 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.

How to Convert a Database to Access 2010 Format
The ACCDB database format introduced in Access 2007 provides a number of enhanced features over the older MDB format. In this article, we'll walk you through the process of converting an MDB format database to the new ACCDB format in Access 2010.

How to Change the Default Database Format in Access 2007
Access 2007 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.

Subscribing to a SQL Server Publication
Once you've configured a distributor and created a publication, the last step in configuring SQL Server replication is to create a subscriber who will receive publication updates from the publisher. In this tutorial, we walk through the process of subscribing to a publication, step-by-step.

Database Engine Tuning Advisor (DETA): Tuning Your SQL Server Database
Database Engine Tuning Advisor (DETA) allows you to optimize your SQL Server database configuration based upon the unique business requirements of your organization. It analyzes your database workload and uses that information to make recommendations about hte physical structure of your database and then allows you to actually implement the recommendations within DETA.

Snapshot Replication: Creating a Distributor in SQL Server 2008 for use with Snapshot Replication
SQL Server's snapshot replication technology allows you to automatically transfer information between databases to keep them synchronized. In this article, we look at the first step of the snapshot replication process: creating the replication distributor.

Using SQL Server 2008 Upgrade Advisor
Microsoft provides the SQL Server 2008 Upgrade Advisor to help you detect upgrade issues before they occur. This tool examines your SQL Server 2000 and SQL Server 2005 databases and checks for any potential conflicts.

Creating Traces with SQL Server Profiler
Traces allow you to track the specific actions performed against a SQL Server databases. They provide valuable information for troubleshooting database issues and tuning database engine performance. In this tutorial, we walk through the process of creating a SQL Server Trace with SQL Server Profiler, step-by-step.

How to Create a DMF Policy
Policy objects specify the conditions you wish to enforce against database targets using the Distributed Management Framework (DMF). In this tutorial, we create a DMF policy that enforces the stored procedure naming convention condition we created together in the previous step.

Verifying DMF Policy Compliance
The On Demand Execution Mode of SQL Server's Declarative Management Framework allows you to manually test whether a DMF target complies with a policy. This is a great way to test a policy-based management strategy prior to deploying an automated policy.

Manually Enforcing Policies in SQL Server 2008
The Declarative Management Framework allows you to manually reconfigure policy targets so that they comply with some policies. It is important to note, however, that this manual reconfiguration cannot resolve all policy compliance issues. SQL Server will be able to modify database settings, reconfigure permissions and perform similar tasks but it cannot, for example, change the name of a stored procedure without administrator intervention.

Encrypting SQL Server Database Connections
Encryption helps you prevent unauthorized access to information when individuals try to bypass your database security controls. For example, someone with a computer on your network might try to use a packet sniffer to monitor connections made by users to a database. Fortunately, database encryption allows you to protect the data sent over those connections from prying eyes.

Configuring Log Shipping in SQL Server 2008
Log shipping allows you to keep two SQL Server databases synchronized for high availability. In a log shipping relationship, the primary server transfers copies of its transaction logs to the secondary server on a periodic basis. The secondary server receives those logs and uses them to update its copy of the database so that it is then in the same state as the database on the primary server.

Microsoft SQL Server Database Maintenance Plans
Database Maintenance Plans allow you to automate many database administration tasks in Microsoft SQL Server. You can create maintenance plans using an easy wizard-based process without any knowledge of Transact-SQL.

Access 2007 Tour: The New User Interface
If you’re switching to Microsoft Access 2007 from an earlier version, you’re bound to immediately notice some major changes in the user interface. Microsoft modeled the Access 2007 look-and-feel after the Windows Vista model, providing the application with a clean, high-tech look that could dramatically alter your workflow. In this article, we walk through the new interface. We’ll explore the Ribbon, the Microsoft Office button, the Navigation Pane and other features of Access 2007.

Learning SQL E-Course
The Structured Query Language (SQL) forms the backbone of all relational databases. This language offers a flexible interface for databases of all shapes and sizes and is used as the basis for all user and administrator interactions with the database. In this course, you'll learn the basics of using SQL to store, retrieve and manipulate information in a database.

Database Design From the Ground Up
Database Design From the Ground Up

Building an Access Database From the Ground Up
Building an Access Database From the Ground Up

What Do You Want To See in Access 2010?
Microsoft Access 2010: What's Coming with Office 2010?

What Do You Want To See in SQL Server 2011?
Microsoft SQL Server 2011: New Features

What I Wish I Knew About Databases
Something you wish you knew about databases before you jumped in head-first? Share your insights with our readers!

Microsoft Access Fundamentals
Want to learn how to use Microsoft Access? Find out on the About.com Databases site!

Databases Glossary
Glossary of database related terms from your About.com Guide to Databases

Sybase
The Net’s best collection of Sybase database product links from your About.com Guide to Databases.

Insert
What is the INSERT SQL command? Find out here!

SQL Server
What is SQL Server? Find out here!

Transaction
What is a database transaction? Find out here!

Trigger
What is a database trigger? Find out here!

eXtensible Markup Language
What is XML? Find out more about the eXtensible Markup Language here!

FileMaker Pro
What is FileMaker Pro? Find out here!

Expert Oracle
Review of Thomas Kyte's Expert One-on-One Oracle from Wrox Press

Paradox Definition
What is Paradox? Find out here!

Postgres Definition
What is Postgres? Find out here!

MySQL: The Complete Reference
Vikram Vaswani's book MySQL: The Complete Reference is a wonderful technical reference for this popular open-source database platform. It's comprehensive enough for seasoned MySQL users yet clear enough for the newcomer.

Fourth Normal Form (4NF)
What is Fourth Normal Form? Find out here!

Column
What is a database column? Find out here!

Database Consistency
What is Consistency? Find out here!

Determinant
What is a determinant? Find out here!

Durability
What is Durability? Find out here!

Entity
What is an entity? Find out here!

Field
What is a Field? Find out here!

Form
What is a database form? Find out here!

Database Normalization
What is database normalization? Find out here!

Record Definition
What is a database record? Find out here!

Row Definition
What is a database row? Find out here!

Table
What is a database table? Find out here!

Tuple
What is a tuple? Find out here!

Absolute Beginner's Guide to Access 2002
Review of the Absolute Beginner's Guide to Microsoft Access 2002 by Susan Sales Harkins and Mike Gunderloy.

Enterprise
What is an enterprise? Find out here!

Cursor
What is a Cursor? Find out here!

Database
What is a database? Find out here!

Isolation
What is isolation? Find out here!

Join
What is a database join operation? Find out here!

Key
What is a database key? Find out here!

Lock
What is a database lock? Find out here!

NULL
What is a NULL database value? Find out here!

Replication Definition
What is database replication? Find out here!

Report Definition
What is a database report? Find out here!

Repository Definition
What is a repository? Find out here!

Rollback Definition
What is rollback? Find out here!

Structured Query Language
What is the Structured Query Language? Find out here!

Two Phase Commit
What is two phase commit? Find out here!

View
What is a database view? Find out here!

Data Mining
What is data mining? Find out here!

Data Warehouse
What is a data warehouse? Find out here!

Knowledge
What is knowledge? Find out here!

DB2
What is IBM DB2? Find out here!

Open Database Connectivity (ODBC) Definition
What is Open Database Connectivity (ODBC)? Find out here!

Online Transaction Processing (OLTP) Definition
What is Online Transaction Processing (OLTP)? Find out here!

Active Server Pages
What are Active Server Pages (ASP)? Find out here!

Cold Fusion
What is Cold Fusion? Find out here!

Commit
What does it mean to commit a database transaction? Find out here!

Online Analytical Processing (OLAP)
What is Online Analytical Processing (OLAP)? Find out here!

Data Manipulation Language
Looking for a definition of data manipulation language (DML)? Find it here in the About Databases glossary.

Log Shipping Defined
What is Log Shipping? Find out in the About Databases glossary.

Merge Replication Defined
What is merge replication? Find out in the About Databases glossary!

NOT NULL Constraints - About Databases Glossary Definition
Looking for a definition of NOT NULL constraints? Find it in the About Databases glossary!

Object
Wondering what an object is in database terms? Find out here!

Transactional Replication Definition
What is transactional replication? Find out in the About Databases glossary

Unique Constraints - About Databases Definition
Looking for a definition of unique constraints in databases? Find one in the About Databases glossary!

Classification (Data Mining) Definition
What is classification? Learn about this data mining term here.

Regression (Data Mining) Definition
What is regression? Learn more about this data mining term here.

PL/SQL
What is PL/SQL? Find out in the About Databases glossary!

Book Review: Access Database Design and Programming
A great introductory text for Access users looking to become developers. If you're already programming with Access, you might want to find a more comprehensive volume.

Microsoft Access 2007
Microsoft might be competing against Oracle for market share in the server database category, but they maintain a clear lock on desktop databases with Microsoft Access 2007. The price tag may be a bit steep, but you won't find a more functional product anywhere. New bells and whistles in this version include a set of ready-to-go database templates to help you get a quick start and a vastly improved user interface that does away with the traditional toolbars and menus.

Access 2003 Visual QuickStart Review
Steve Schwartz's Microsoft Access 2003 Visual QuickStart offers a great introduction to Microsoft Access for beginners who prefer to learn by example rather than reading user manuals. It provides over 110 illustrated examples of tasks ranging from the basics of navigating Microsoft Access to more advanced topics like working with Pivot Tables.

Book Review: Hands-On Microsoft Access
Bob Schneider's Hands-On Microsoft Access takes an entirely different approach to learning Access. Rather than treating it as a product to be conquered through a series of mouse clicks and

ACCDB File Format
The ACCDB database file format was introduced with the release of Microsoft Access 2007 to replace the older MDB file format. The use of ACCDB format allows users to leverage enhanced functionality in Access, including the use of multivalued fields and strong cryptography.

MDB Definition
MDB is the file format used by Microsoft Access XP and earlier versions. It was replaced by the ACCDB format with the release of Microsoft Access 2007.

Multivalued Fields
Multivalued fields in Microsoft Access offer you the opportunity to allow users to select one or more options for a field value by using checkboxes.

User Level Security
User level security in Microsoft Access allows you to control the types of data that a user might access and the actions they can perform.

Database Concurrency
Looking for a definition of database concurrency? Find it here!

Designing Data Access Pages
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process.

Database Engine Tuning Advisor (DETA)
What is Database Engine Tuning Advisor? Find out in the About Databases glossary.

SQL Profiler
What is SQL Profiler? Find out in the About Databases glossary.

Transact-SQL Definition
What is Transact-SQL? Find out in the About Databases glossary!

SQL Server Security Book Review
SQL Server Security by Chip Andrews, David Litchfield and Bill Grindlay offers practical security advice with a hands-on perspective. It's ideal for SQL Server 7.0 and SQL Server 2000 administrators of all experience levels.

Creating a Publication in SQL Server
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of database objects that will be replicated to all subscriber servers.

Choose Your DMF Condition
Conditions are the clauses that you may use to create DMF policies on a management facet. Examples of conditions are usernames, account creation dates and password complexity policies. In this example, we will create a DMF condition that enforces a stored procedure naming policy that requires all stored procedures begin with the

SQL Visual Quickstart
This software-independent book takes a hands-on approach to learning SQL. After some brief introductory material, it dives right into developing SQL queries designed to meet specific goals. It's a great reference for those who occasionally use SQL and forget the details.

Self Joins: About Databases Glossary Definition
Looking for a definition of self-join? Find it in the About Databases Glossary!

Book Review: SQL Cookbook
O'Reilly's SQL Cookbook is the best reference I've seen for skilled SQL developers. Modeled after a true cookbook, it offers many short snippets of SQL code designed to solve specific problems. You can pick and choose the ingredients you need to help complete your SQL project.

Object Oriented Databases
Looking for a definition of Object Oriented Databases? Find it here!

Compound Key: About Databases Glossary Definition
What is a compound key? Find out in the About Databases glossary!

Default Values in Databases
Looking for a description of default values and constraints in databases? The About Databases Glossary provides an easy to understand description.

Many-to-Many Relationships in Databases
Looking for a definition of many-to-many database relationships? Read our definition in the About Databases glossary!

Inference
What is inference in databases? Find out in the About Databases glossary.

SQL Injection Defined
What is a SQL injection attack? Find out more in the About Databases glossary.

Book Review: High Performance MySQL
High Performance MySQL is a wonderful reference for database administrators migrating to the MySQL platform, particularly in enterprise deployments.

Decryption
Decryption is the process of converting encrypted ciphertext into the original plaintext using a password or other key.

Encryption
Encryption is the process of converting plaintext into ciphertext with an encryption algorithm using a password or other key. Encryption prevents unauthorized individuals from viewing the contents of a file.

Learning SQL
The Structured Query Language (SQL) forms the backbone of all relational databases. This language offers a flexible interface for databases of all shapes and sizes and is used as the basis for all user and administrator interactions with the database.

Using Databases
Databases offer a powerful, flexible way to manage your organization's data. In this section, we explore several popular database platforms: Microsoft Access, Microsoft SQL Server and MySQL, providing you with the information you need to get started and develop your database skills.

Concatenation: About Databases Glossary Definition
Interested in the definition of concatenation? Find out in the About Databases glossary!

Get Lost Lessons for Building an Access Database From the Ground Up
Building an Access Database From the Ground Up

Integrating Databases with the Web
The Net’s best collection of database web integration links from your About.com guide to Databases.

FoxPro Programming Language
The Net’s best collection of FoxPro links from your About.com Guide to Databases.

Past issues of weekly features
Previous issues of weekly features and columns.

Creating Dynamic Web Pages with Microsoft Access
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Database Design Book Review - Databases
Review of Database Design by Ryan K. Stephens and Ronald R. Plew, from your About.com Guide

Database Design Book Review - Databases
Review of Database Design by Ryan K. Stephens and Ronald R. Plew, from your About.com Guide

Blank1


Perfect Strangers
Stephen Poliakoff's latest TV play Perfect Strangers

Cold Fusion Database Programming
The Net's best collection of Cold Fusion links from your About.com Guide to Databases.

Get Lost Lessons for Database Design From the Ground Up
Database Design From the Ground Up

Get Lost Lessons for Learning SQL E-Course
The Structured Query Language (SQL) forms the backbone of all relational databases. This language offers a flexible interface for databases of all shapes and sizes and is used as the basis for all user and administrator interactions with the database. In this course, you'll learn the basics of using SQL to store, retrieve and manipulate information in a database.

How To Performance Tune SQL Server 7.0
Quick tips for performance tuning SQL Server 7.0.

How To Install the Northwind Sample Database in Microsoft Access
Learn how to install the Northwind sample database in Microsoft Access.

How To Convert an Access 2.0 Database to Access 97/2000
Wondering how to convert an Access 2.0 database to Access 97 or Access 2000? Follow these easy steps!

How To Create an Adobe PDF File From an Access Database
Step-by-step instructions on creating an Adobe Acrobat .PDF file from your Microsoft Access database

Databases - TopPicks
An index of TopPicks for the Databases guide site.

Database Certifications
The Net's best collection of database certification links including Oracle's OCP program, Microsoft's MCDBA and more!