2016-09-28T11:03:33ZWhat is a relation? Find out here!
2016-09-28T11:03:33ZLooking for a definition of one-to-many database relationships? Read our definition in the About Databases glossary!
2016-09-28T11:03:33ZMicrosoft SQL Server 2014 is a relational database management system (RDBMS) that offers tools for easy database development, upkeep, and administration.
2016-09-28T11:03:33ZAn attribute, when in regards to databases, deals with single data in an object. It is one of the basic terms used in SQL.
2016-09-28T11:03:33ZLooking 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.
2016-09-28T11:03:33ZIn 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.
2016-09-28T11:03:33ZOne 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.
2016-09-28T11:03:33ZWhile 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.
2016-09-28T11:03:33ZWhat is First Normal Form? Find out here!
2016-09-28T11:03:33ZDatabase dependencies are a topic that often confuses both students and database professionals alike. Fortunately, they are not that complicated.
2016-09-28T11:03:33ZWould you like to learn SQL? This tutorial will introduce you to the basics. Page 2.
2016-09-28T11:03:33ZThis article provides additional technical details for individuals seeking to understand the encryption options offered within Microsoft Access 2013.
2016-09-28T11:03:33ZIf 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.
2016-09-28T11:03:33ZSQL 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.
2016-09-28T11:03:33ZIf 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.
2016-09-28T11:03:33ZOne 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.
2016-09-28T11:03:33ZTraces 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.
2016-09-28T11:03:33ZDesktop 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
2016-09-28T11:03:33ZWhat is a functional dependency? Find out here!
2016-09-28T11:03:33ZLooking for an easy way to move your Microsoft Access database to the cloud? Microsoft's Office 365 service provides a central location.
2016-09-28T11:03:33ZThe 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?
2016-09-28T11:03:33ZMany 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.
2016-09-28T11:03:33ZIs 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.
2016-09-28T11:03:33ZIn this series of Microsoft Access tutorials, we follow the database admins for Patrick's Widgets as they build a Microsoft Access database.