Subscribe: About.com Databases: What's Hot Now
http://z.about.com/6/o/m/databases_t2.xml
Preview: About.com Databases: What's Hot Now

About.com Databases: What's Hot Now



These articles that had the largest increase in popularity over the last week



 



What 'Relation' Means (Databases)

2016-09-28T11:03:33Z

What is a relation? Find out here!



One-to-Many Relationships

2016-09-28T11:03:33Z

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



Introduction to SQL Server 2014

2016-09-28T11:03:33Z

Microsoft SQL Server 2014 is a relational database management system (RDBMS) that offers tools for easy database development, upkeep, and administration.



Attribute

2016-09-28T11:03:33Z

An attribute, when in regards to databases, deals with single data in an object. It is one of the basic terms used in SQL.



SQL Server Administration (70-228) Practice Exam

2016-09-28T11:03:33Z

Looking to prove your SQL Server Administration mettle? This quiz will help you prepare for Microsoft's 70-228 exam: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition. This is a critical step toward earning your Microsoft Certified Database Administrator credential.



Creating an Access Database from Scratch

2016-09-28T11:03:33Z

In an earlier article, we reviewed the process for creating an Access database from a template. While this is certainly an agreeable, easy approach to building a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.



SQL Server Backup Types and Scopes

2016-09-28T11:03:33Z

One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set. Microsoft SQL Server provides database administrators with the ability to customize a database backup and recovery plan to the business and technical requirements of an organization.



Printing Forms in Microsoft Access

2016-09-28T11:03:33Z

While forms are most useful when accessed directly in the database, there will be times when you will want to print them, for example when you want details about a single record or if you want to create instructions and include screenshots for entering data into a form.



Here's What 'First Normal Form' Is (1NF)

2016-09-28T11:03:33Z

What is First Normal Form? Find out here!



A Quick Guide to Understanding Database...

2016-09-28T11:03:33Z

Database dependencies are a topic that often confuses both students and database professionals alike. Fortunately, they are not that complicated.



The Fundamental Guide to SQL (Structured Query...

2016-09-28T11:03:33Z

Would you like to learn SQL? This tutorial will introduce you to the basics. Page 2.



Understanding Microsoft Access 2013 Encryption

2016-09-28T11:03:33Z

This article provides additional technical details for individuals seeking to understand the encryption options offered within Microsoft Access 2013.



Introduction to Pivot Tables

2016-09-28T11:03:33Z

If you’re looking for some of the flexible query power of a database but don’t want to mess with relational database design, pivot tables may be just the technology you need. Chances are you’re already using one of the popular spreadsheet packages that include this technology, such as Microsoft Excel or the free Google Spreadsheets package.



A Quick Guide to Using Recovery Models in SQL...

2016-09-28T11:03:33Z

SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options.



MySQL in Amazon Web Services

2016-09-28T11:03:33Z

If you're seeking an inexpensive way to run a MySQL database in the cloud, you might want to consider using the free tier of Amazon Web Services. AWS offers free limited use of a MySQL database server for one year and is extremely easy to get up and running.



How To Print Mailing Labels in Microsoft Access...

2016-09-28T11:03:33Z

One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access 2013 using the built-in Label Wizard.



How To Create a Trace with SQL Server Profiler

2016-09-28T11:03:33Z

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.



Top 5 Desktop Databases

2016-09-28T11:03:33Z

Desktop databases offer simple, flexible solutions for data storage and retrieval. They're often quite sufficient to meet uncomplicated database requirements for both small and large organizations. If you're not sure if a desktop database is right for you, try reading the Choosing a Database series of articles which cover both desktop and server databases in depth



Wondering What "Functional Dependency" Is in...

2016-09-28T11:03:33Z

What is a functional dependency? Find out here!



Building an Access Database in Office 365

2016-09-28T11:03:33Z

Looking for an easy way to move your Microsoft Access database to the cloud? Microsoft's Office 365 service provides a central location.



HIPAA in a Nutshell

2016-09-28T11:03:33Z

The Health Insurance Portability and Accountability Act of 1996 (HIPAA) places a large regulatory burden on organizations that deal with certain types of health-related information. We're now only a couple of weeks away from the compliance deadline for the Security Rule. Are you ready for April 21st?



Data Classification: A Simple Approach

2016-09-28T11:03:33Z

Many organizations avoid the challenge of data classification because they consider it a burdensome, difficult effort. In fact, it’s likely that organizations without actively used data classification policies have tried implementing such a policy in the past and failed, never to try again. In this article, I offer you some practical advice for getting a data classification effort off the ground and applying it to your sensitive information.



How to Convert an Access Database to SQL Server...

2016-09-28T11:03:33Z

Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL Server might be the solution you’re trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database. In this tutorial, we walk through the process of converting your database.



How to Build a New Access Database in SQL

2016-09-28T11:03:33Z

In this series of Microsoft Access tutorials, we follow the database admins for Patrick's Widgets as they build a Microsoft Access database.