Databases: Most Popular Articles
These articles are the most popular over the last month.
Database Normalization Basics
Database normalization can save storage space and ensure the consistency of your data. Learn the basics in this introductory article.
Database normalization can save storage space and ensure the consistency of your data. Learn the basics in this introductory article.
Primary Key
What is a primary key? Find out here!
What is a primary key? Find out here!
SQL Server Stored Procedures
Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.
Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.
Entity-Relationship Diagram
What is a database? Find out here!
What is a database? Find out here!
First Normal Form
In this article, we begin our look at the first of three major normal forms -- first normal form (otherwise known as 1NF).
In this article, we begin our look at the first of three major normal forms -- first normal form (otherwise known as 1NF).
Joining Multiple Tables in SQL
You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using inner joins and outer joins to combine data from two different tables. In many cases, you’ll want to take this a step further and combine data from three or more tables. Let's take a look at the SQL statements that allow you to accomplish this goal for an inner join.
You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using inner joins and outer joins to combine data from two different tables. In many cases, you’ll want to take this a step further and combine data from three or more tables. Let's take a look at the SQL statements that allow you to accomplish this goal for an inner join.
Third Normal Form (3NF)
In our first article, we looked at the basic requirements of 3NF. Here they are again to refresh your memory: meet the requirements of 1NF and 2NF and remove columns that are not fully dependent upon the primary key.
In our first article, we looked at the basic requirements of 3NF. Here they are again to refresh your memory: meet the requirements of 1NF and 2NF and remove columns that are not fully dependent upon the primary key.
What is a Database?
Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, you’re probably already accustomed to storing data in tabular form. It’s not much of a stretch to make the leap from spreadsheets to databases.
Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, you’re probably already accustomed to storing data in tabular form. It’s not much of a stretch to make the leap from spreadsheets to databases.
Creating Forms in Access
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!
Second Normal Form
Second Normal Form allows you to enhance the normalization of your database. In this article, we explore the requirements of 2NF and the process of normalizing your database.
Second Normal Form allows you to enhance the normalization of your database. In this article, we explore the requirements of 2NF and the process of normalizing your database.
Deleting Data from an SQL Table
The SQL DELETE command allows the removal of some or all of the data stored in a relational database table.
The SQL DELETE command allows the removal of some or all of the data stored in a relational database table.
Self-Joins in SQL
You can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table. These joins allow you to retrieve related records from the same table.
You can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table. These joins allow you to retrieve related records from the same table.
Retrieving Data from Multiple Tables with SQL Joins
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.
Microsoft Access Fundamentals
Want to learn how to use Microsoft Access? Find out on the About.com Databases site!
Want to learn how to use Microsoft Access? Find out on the About.com Databases site!
Foreign Key
What is a foreign key? Find out here!
What is a foreign key? Find out here!
Creating Databases and Tables
Learn to create databases and tables using the Structured Query Language (SQL) in this step-by-step tutorial from your About.com Guide to Databases.
Learn to create databases and tables using the Structured Query Language (SQL) in this step-by-step tutorial from your About.com Guide to Databases.
Database Keys
As you may already know, databases use tables to organize information. Each table consists of a number of rows, each of which corresponds to a single database record. So, how do databases keep all of these records straight? It’s through the use of keys.
As you may already know, databases use tables to organize information. Each table consists of a number of rows, each of which corresponds to a single database record. So, how do databases keep all of these records straight? It’s through the use of keys.
Referential Integrity
What is Referential Integrity? Find out in our database glossary!
What is Referential Integrity? Find out in our database glossary!
Converting Excel to Access 2007
Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!
Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!
Building an Access Database...
In this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.
In this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.
Creating a Simple Query in Microsoft Access
Want to learn how to create a query in Microsoft Access? Find out on the About.com Databases site!
Want to learn how to create a query in Microsoft Access? Find out on the About.com Databases site!
Candidate Key
What is a Candidate Key? Find out here!
What is a Candidate Key? Find out here!
Databases for Beginners
Are you new to the world of databases? Wondering where to get started? In this series of articles, we introduce you to the basics of database technology and help you get started in this exciting field.
Are you new to the world of databases? Wondering where to get started? In this series of articles, we introduce you to the basics of database technology and help you get started in this exciting field.
Summarizing Data with CUBE and ROLLUP
SQL's CUBE and ROLLUP commands allow for the efficient summarization of data. Learn how to use them here!
SQL's CUBE and ROLLUP commands allow for the efficient summarization of data. Learn how to use them here!
Introduction to SQL
Would you like to learn SQL? This tutorial will introduce you to the basics.
Would you like to learn SQL? This tutorial will introduce you to the basics.
ZIP Code Database
This free Access database of ZIP codes provides database designers with a valuable tool to assist in mapping ZIP codes to a city/state pair and even provides the latitude and longitude of that location.
This free Access database of ZIP codes provides database designers with a valuable tool to assist in mapping ZIP codes to a city/state pair and even provides the latitude and longitude of that location.
Database Software Options
You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's actually a simple matter of deciding what features you need and choosing a product that meets your requirements and doesn't cause too much pain in your pocketbook.
You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's actually a simple matter of deciding what features you need and choosing a product that meets your requirements and doesn't cause too much pain in your pocketbook.
Boyce-Codd Normal Form (BCNF)
What is Boyce-Codd Normal Form (BCNF)? Find out here!
What is Boyce-Codd Normal Form (BCNF)? Find out here!
SQL Books
Looking for a book to help you get started with Strucutred Query Language? Need a new reference book for your shelf? Check out my favorite SQL books.
Looking for a book to help you get started with Strucutred Query Language? Need a new reference book for your shelf? Check out my favorite SQL books.
Microsoft Access Reports Tutorial
Would you like to create professional-looking reports from your Microsoft Access database with the click of a mouse? Follow along as we walk through the simple process of designing a reusable report.
Would you like to create professional-looking reports from your Microsoft Access database with the click of a mouse? Follow along as we walk through the simple process of designing a reusable report.
UNIQUE Constraints
UNIQUE constraints allow SQL Server administrators to specify that a column may not contain duplicate values. When you create a new UNIQUE constraint, SQL Server checks the column in question to determine whether it contains any duplicate values. If the table contains preexisting duplicates, the constraint creation command fails. Similarly, once you have a UNIQUE constraint on a column, attempts to add or modify data that would cause duplicates to exist also fail.
UNIQUE constraints allow SQL Server administrators to specify that a column may not contain duplicate values. When you create a new UNIQUE constraint, SQL Server checks the column in question to determine whether it contains any duplicate values. If the table contains preexisting duplicates, the constraint creation command fails. Similarly, once you have a UNIQUE constraint on a column, attempts to add or modify data that would cause duplicates to exist also fail.
Aggregate Functions in SQL
Summarize data with SQL's SUM, AVG, MIN, MAX and COUNT functions. Your About.com Guide to Databases walks you through the process.
Summarize data with SQL's SUM, AVG, MIN, MAX and COUNT functions. Your About.com Guide to Databases walks you through the process.
bcp
The bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line. In addition to being a great tool for command-line aficionados, bcp is a powerful tool for those seeking to insert data into a SQL Server database from within a batch file or other programmatic method.
The bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line. In addition to being a great tool for command-line aficionados, bcp is a powerful tool for those seeking to insert data into a SQL Server database from within a batch file or other programmatic method.
Access File Formats: ACCDB/MDB
The release of Access 2007 brings a new file format. The MDB database files we’ve known for over a decade are now slated to become historical relics. While Access 2007 continues to support MDB databases for backwards compatibility purposes, Microsoft has now introduced the new ACCDB file format as the future standard. Wondering if you should begin using the ACCDB format?
The release of Access 2007 brings a new file format. The MDB database files we’ve known for over a decade are now slated to become historical relics. While Access 2007 continues to support MDB databases for backwards compatibility purposes, Microsoft has now introduced the new ACCDB file format as the future standard. Wondering if you should begin using the ACCDB format?
Dynamic Web Pages With Access
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.
SQL Server 2012 Editions
SQL Server 2012
SQL Server 2012
Sample Excel Document
Sample Excel Document
Sample Excel Document
Installing MySQL on Mac OS X 10.7 Lion
The MySQL database server is one of the most popular open source databases in the world. Although there is not yet an official package for installing it on the latest version of the Macintosh operating system (Mac OS X 10.7, codenamed Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6. Here’s a step-by-step walkthrough of the process.
The MySQL database server is one of the most popular open source databases in the world. Although there is not yet an official package for installing it on the latest version of the Macintosh operating system (Mac OS X 10.7, codenamed Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6. Here’s a step-by-step walkthrough of the process.
Choosing a Primary Key
Databases depend upon keys to store, sort and compare records. If you’ve been around databases for a while, you’ve probably heard about many different types of keys – primary keys, candidate keys, and foreign keys. When you create a new database table, you’re asked to select one primary key that will uniquely identify records stored in that table.
Databases depend upon keys to store, sort and compare records. If you’ve been around databases for a while, you’ve probably heard about many different types of keys – primary keys, candidate keys, and foreign keys. When you create a new database table, you’re asked to select one primary key that will uniquely identify records stored in that table.
Retrieving Data with SQL Queries: Introducing the SELECT Statement
Learn to retrieve information from your database with the SQL SELECT statement. Your About.com Guide to Databases provides a thorough introduction.
Learn to retrieve information from your database with the SQL SELECT statement. Your About.com Guide to Databases provides a thorough introduction.
Exporting Access Tables to ...
Microsoft Access allows you to export data to a variety of formats for sharing and analysis. In this tutorial, we walk through the process of exporting an Access table to an Excel workbook.
Microsoft Access allows you to export data to a variety of formats for sharing and analysis. In this tutorial, we walk through the process of exporting an Access table to an Excel workbook.
Log Shrinking and Truncation
The transaction log plays a critical role in a SQL Server database: it maintains an ongoing record of database activity crucial for the restoration of recent data in the event of a disaster. However, this benefit comes at a cost: the transaction log can consume a substantial amount of space in an active database. SQL Server provides two actions designed to counterbalance these large space requirements: transaction log truncation and log file shrinking.
The transaction log plays a critical role in a SQL Server database: it maintains an ongoing record of database activity crucial for the restoration of recent data in the event of a disaster. However, this benefit comes at a cost: the transaction log can consume a substantial amount of space in an active database. SQL Server provides two actions designed to counterbalance these large space requirements: transaction log truncation and log file shrinking.
Creating Database Relationships in Access
Join us as we walk through the process of creating database relationships in Microsoft Access.
Join us as we walk through the process of creating database relationships in Microsoft Access.
Database Relationships
Relationships allow you to describe the connections between different database tables in powerful ways. Once you’ve described the relationships between your tables, you can later leverage that information to perform powerful cross-table queries, known as joins.
Relationships allow you to describe the connections between different database tables in powerful ways. Once you’ve described the relationships between your tables, you can later leverage that information to perform powerful cross-table queries, known as joins.
Installing Northwind
The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it.
The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it.
Structured Query Language
Most large-scale databases use the Structured Query Language (SQL) to define all user and administrator interactions. This language offers a flexible interface for databases of all shapes and sizes.
Most large-scale databases use the Structured Query Language (SQL) to define all user and administrator interactions. This language offers a flexible interface for databases of all shapes and sizes.
Creating Forms in Access 2007
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.
Database Management System
A database management system (DBMS) is the software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.
A database management system (DBMS) is the software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.
Functional Dependency
What is a functional dependency? Find out here!
What is a functional dependency? Find out here!
SQL Server 2008 Editions
SQL Server 2008 is the latest release in Microsoft’s enterprise relational database platform series. In this substantial upgrade, they've packed the new database engine full of new features, but fortunately it doesn’t pack any additional punch in your wallet: SQL Server 2008 is available at the same price points used by SQL Server 2005.
SQL Server 2008 is the latest release in Microsoft’s enterprise relational database platform series. In this substantial upgrade, they've packed the new database engine full of new features, but fortunately it doesn’t pack any additional punch in your wallet: SQL Server 2008 is available at the same price points used by SQL Server 2005.
Password Protecting Access 2007
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step.
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step.
Database Beginners FAQ
Just getting started with databases? Here's a rundown of the top things that I wish I knew before I got started in the field. These facts are guaranteed to make your life easier!
Just getting started with databases? Here's a rundown of the top things that I wish I knew before I got started in the field. These facts are guaranteed to make your life easier!
MCTS 70-433 SQL Server Practice Exam
Free Practice Test for Microsoft Exam 70-433 Microsoft SQL Server 2008 Database Development Welcome to
Free Practice Test for Microsoft Exam 70-433 Microsoft SQL Server 2008 Database Development Welcome to
Converting Excel to Access 2010
Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!
Are you ready to convert your unwieldy Excel spreadsheet to a flexible Access database? Let us walk you through the process!
Data Mining: An Introduction
Data mining allows you to find the needles hidden in your haystacks of data. Learn how to use these advanced techniques to meet your business objectives.
Data mining allows you to find the needles hidden in your haystacks of data. Learn how to use these advanced techniques to meet your business objectives.
Using Self-Joins in SQL
Did you know that you can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table? Let's take a look at an example.
Did you know that you can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table? Let's take a look at an example.
What are Database Dependencies?
Database dependencies are a topic that often confuses both students and database professionals alike. Fortunately, they are not that complicated and can best be illustrated through the use of a number of examples. In this article, we examine common database dependency types.
Database dependencies are a topic that often confuses both students and database professionals alike. Fortunately, they are not that complicated and can best be illustrated through the use of a number of examples. In this article, we examine common database dependency types.
SQL Injection Testing
SQL Injection attacks pose tremendous risks to web applications that depend upon a database backend to generate dynamic content. In this type of attack, hackers manipulate a web application in an attempt to inject their own SQL commands into those issued by the database. In this article, we take a look at several ways you can test your web applications to determine whether they're vulnerable to SQL Injection attacks.
SQL Injection attacks pose tremendous risks to web applications that depend upon a database backend to generate dynamic content. In this type of attack, hackers manipulate a web application in an attempt to inject their own SQL commands into those issued by the database. In this article, we take a look at several ways you can test your web applications to determine whether they're vulnerable to SQL Injection attacks.
Choosing a Database
Database management systems (or DBMSs) can be divided into two categories -- desktop databases and server databases. Generally speaking, desktop databases are oriented toward single-user applications and reside on standard personal computers (hence the term desktop). Server databases contain mechanisms to ensure the reliability and consistency of data and are geared toward multi-user applications.
Database management systems (or DBMSs) can be divided into two categories -- desktop databases and server databases. Generally speaking, desktop databases are oriented toward single-user applications and reside on standard personal computers (hence the term desktop). Server databases contain mechanisms to ensure the reliability and consistency of data and are geared toward multi-user applications.
Access 2007 Relationships
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.
Partitioning SQL Server Tables
Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables onto separate filegroups. This technology, introduced in SQL Server 2005, allows you to spread data onto different physical disks, leveraging the concurrent performance of those disks to optimize query performance.
Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables onto separate filegroups. This technology, introduced in SQL Server 2005, allows you to spread data onto different physical disks, leveraging the concurrent performance of those disks to optimize query performance.
SQL Server Replication
Microsoft SQL Server provides a robust replication facility to distribute and update data in a decentralized fashion.
Microsoft SQL Server provides a robust replication facility to distribute and update data in a decentralized fashion.
Pattern Matching in SQL Server
You may often need to create a SQL Server query that performs inexact pattern matching through the use
You may often need to create a SQL Server query that performs inexact pattern matching through the use
SQL Server Recovery Models
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.
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.
Creating Relationships
In the seventh installment of our Building an Access Database From the Ground Up series, we create relationships between our tables to finish implementing our relational model.
In the seventh installment of our Building an Access Database From the Ground Up series, we create relationships between our tables to finish implementing our relational model.
Access Controls in SQL
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.
One-to-Many Relationships
Looking for a definition of one-to-many database relationships? Read our definition in the About Databases glossary!
Looking for a definition of one-to-many database relationships? Read our definition in the About Databases glossary!
Databases Glossary
Glossary of database related terms from your About.com Guide to Databases
Glossary of database related terms from your About.com Guide to Databases
The ACID Model
All database management systems should share four characteristics: Atomicity, Consistency, Isolation and Durability.
All database management systems should share four characteristics: Atomicity, Consistency, Isolation and Durability.
Sample Excel Spreadsheet
This sample Excel spreadsheet provides a starting point for our Microsoft Access tutorials.
This sample Excel spreadsheet provides a starting point for our Microsoft Access tutorials.
Query
What is a query? Find out here!
What is a query? Find out here!
Stored Procedure vs. Function
SQL Server user-defined functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use. This offers you a tremendous efficiency benefit, as you can save programming time by...
SQL Server user-defined functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use. This offers you a tremendous efficiency benefit, as you can save programming time by...
Third Normal Form (3NF) - Databases Glossary
What is Third Normal Form? Find out here!: state zip code database designers abc corporation city state zip columbia md 21046
What is Third Normal Form? Find out here!: state zip code database designers abc corporation city state zip columbia md 21046
Timestamps in Microsoft Access
There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s easy to do this in Microsoft Access using the Now() function. In this tutorial, I explain the process step-by-step.
There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s easy to do this in Microsoft Access using the Now() function. In this tutorial, I explain the process step-by-step.
Foreign Keys in Microsoft SQL Server
One of the most important concepts in databases is creating relationships between database tables. These relationships provide a mechanism for linking data stored in multiple tables and retrieving it in an efficient fashion. In order to create a link between two tables, you must specify a foreign key in one table that references a column in another table.
One of the most important concepts in databases is creating relationships between database tables. These relationships provide a mechanism for linking data stored in multiple tables and retrieving it in an efficient fashion. In order to create a link between two tables, you must specify a foreign key in one table that references a column in another table.
NULLs and JOINs
JOIN operations allow us to combine data from multiple tables. Learn how these operations treat the NULL value.
JOIN operations allow us to combine data from multiple tables. Learn how these operations treat the NULL value.
SQL Server Agent
Create a New SQL Server Agent Job
Create a New SQL Server Agent Job
NOT NULL Constraints
NOT NULL constraints in Microsoft SQL Server allow you to specify that a column may not contain NULL values. When you create a new NOT NULL constraint on a database column, SQL Server checks the column’s current contents for any NULL values. If the column currently contains NULL values, the constraint creation fails. Otherwise, SQL Server adds the NOT NULL constraint and any future INSERT or UPDATE commands that would cause the existence of a NULL value fail.
NOT NULL constraints in Microsoft SQL Server allow you to specify that a column may not contain NULL values. When you create a new NOT NULL constraint on a database column, SQL Server checks the column’s current contents for any NULL values. If the column currently contains NULL values, the constraint creation fails. Otherwise, SQL Server adds the NOT NULL constraint and any future INSERT or UPDATE commands that would cause the existence of a NULL value fail.
Free SQL Server Options
SQL Server is an enterprise-class relational database, but that doesn't mean it has to blow your budget. In this article, we take a look at two low cost options that let you get up and running with SQL Server 2008 for free or under $50.
SQL Server is an enterprise-class relational database, but that doesn't mean it has to blow your budget. In this article, we take a look at two low cost options that let you get up and running with SQL Server 2008 for free or under $50.
Starting a Career in Databases
Looking for a job in the database field? This article provides the advice you need to get started.
Looking for a job in the database field? This article provides the advice you need to get started.
Superkey
What is a superkey? Find out here!
What is a superkey? Find out here!
Multivalued Dependency
What is a multivalued dependency? Find out here!
What is a multivalued dependency? Find out here!
SQL Server 2008 R2 Editions
SQL Server 2008 R2 is the latest release in Microsoft’s enterprise relational database platform series. In this substantial upgrade, they've packed the new database engine full of new features, but fortunately it doesn’t pack any additional punch in your wallet: SQL Server 2008 is available at the same price points used by SQL Server 2005.
SQL Server 2008 R2 is the latest release in Microsoft’s enterprise relational database platform series. In this substantial upgrade, they've packed the new database engine full of new features, but fortunately it doesn’t pack any additional punch in your wallet: SQL Server 2008 is available at the same price points used by SQL Server 2005.
Binary Data Types
Binary data types allow you to store any type of binary data, including entire files of up to 2GB. They include binary, varbinary, image and bit.
Binary data types allow you to store any type of binary data, including entire files of up to 2GB. They include binary, varbinary, image and bit.
SQL Server Index Tuning
Looking to squeeze that last bit of performance out of your SQL Server database? The Index Tuning Wizard can help!
Looking to squeeze that last bit of performance out of your SQL Server database? The Index Tuning Wizard can help!
SQL Server Authentication
Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of your organization’s databases.
Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of your organization’s databases.
GROUP BY Statement
You may use basic SQL queries to retrieve data from a database but this often doesn’t provide enough intelligence to meet business requirements. SQL also provides you with the ability to group query results based upon row-level attributes in order to apply aggregate functions using the GROUP BY clause.
You may use basic SQL queries to retrieve data from a database but this often doesn’t provide enough intelligence to meet business requirements. SQL also provides you with the ability to group query results based upon row-level attributes in order to apply aggregate functions using the GROUP BY clause.
Access DBs from Templates
Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access database using these templates.
Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access database using these templates.
Creating an Access Database
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.
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.
Microsoft Access 2010 Fundamentals
Are you overwhelmed by the large quantities of data that need to be tracked in your organization? Perhaps you're currently using a paper filing system, text documents or a spreadsheet to keep track of your critical information. If you're searching for a more flexible data management system, a database might be just the salvation you're looking for and Microsoft Access 2010.
Are you overwhelmed by the large quantities of data that need to be tracked in your organization? Perhaps you're currently using a paper filing system, text documents or a spreadsheet to keep track of your critical information. If you're searching for a more flexible data management system, a database might be just the salvation you're looking for and Microsoft Access 2010.
Creating Reports with Access 2010
Microsoft Access 2010 allows you to easily create professionally formatted reports automatically from information stored in a database. In tis tutorial, we're going to design a nicely-formatted listing of employee home telephone numbers for the use of management using the Northwind sample database and Access 2010.
Microsoft Access 2010 allows you to easily create professionally formatted reports automatically from information stored in a database. In tis tutorial, we're going to design a nicely-formatted listing of employee home telephone numbers for the use of management using the Northwind sample database and Access 2010.
Microsoft Access SQL Queries
Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of accessing the underlying SQL code and tweaking it to perfect Access queries.
Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of accessing the underlying SQL code and tweaking it to perfect Access queries.
Date and Time Data Types
The date and time SQL Server data types are used to store calendar information. They include the datetime, smalldatetime and timestamp variables.
The date and time SQL Server data types are used to store calendar information. They include the datetime, smalldatetime and timestamp variables.
Installing SQL Server 2012 Express Edition
Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.
Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.
Password Protecting an Access 2010 Database
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step.
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step.
CHECK Constraints
CHECK constraints allow you to limit the types of data that users may insert in a database. They go beyond data types and allow you to define the specific values that may be included in a column.
CHECK constraints allow you to limit the types of data that users may insert in a database. They go beyond data types and allow you to define the specific values that may be included in a column.
Top 5 Desktop Databases
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
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
Access Sample Database
This Microsoft Access sample database provides tables containing information on the world's countries, cities and provinces. It is used to illustrate examples for a number of the articles on the About Databases site and also provides a good sample for students, professionals and others who are learning Microsoft Access.
This Microsoft Access sample database provides tables containing information on the world's countries, cities and provinces. It is used to illustrate examples for a number of the articles on the About Databases site and also provides a good sample for students, professionals and others who are learning Microsoft Access.
Repair Access Databases
Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.
Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.
Second Normal Form (2NF) - Databases Glossary
What is Second Normal Form? Find out here!: acme widgets fred flintstone abc corporation john doe two tables
What is Second Normal Form? Find out here!: acme widgets fred flintstone abc corporation john doe two tables
Database Instance
Looking for a definition of a database instance? Look no further!
Looking for a definition of a database instance? Look no further!
SQL Server Tables Tutorial
Next, highlight the column(s) that you've selected for your table's primary key. Then click the key icon in the taskbar to set the primary key.
Next, highlight the column(s) that you've selected for your table's primary key. Then click the key icon in the taskbar to set the primary key.
Access 2010 Relationships
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.
Top 10 SQL FAQs
Looking for advice on using the Structured Query Language? The About Databases SQL FAQ provides answers to the most frequently asked questions about SQL and databases.
Looking for advice on using the Structured Query Language? The About Databases SQL FAQ provides answers to the most frequently asked questions about SQL and databases.
Data Input Via Forms
Part VIII of our tutorial introduces you to the concept of Access forms to input and modify data.
Part VIII of our tutorial introduces you to the concept of Access forms to input and modify data.
Using Expression Builder 2007
Have trouble remembering function names or arguments in Microsoft Access? We all do! Access' Expression Builder is a great tool that walks you through the process of creating expressions for your forms, tables, reports and queries while keeping a handy reference at your fingertips.
Have trouble remembering function names or arguments in Microsoft Access? We all do! Access' Expression Builder is a great tool that walks you through the process of creating expressions for your forms, tables, reports and queries while keeping a handy reference at your fingertips.
One-to-One Relationships
Looking for a definition of one-to-one database relationships? Read our definition in the About Databases glossary!
Looking for a definition of one-to-one database relationships? Read our definition in the About Databases glossary!
Log Shipping in SQL Server
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.
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.
User Level Security in Access
If you’re a Microsoft Office power user, you might be familiar with the encryption features of Word, PowerPoint and Excel. These programs all allow file owners to easily apply encryption. Unfortunately, Microsoft Access doesn’t offer similar functionality, but it still has relatively powerful security functionality. In this article, we’ll take a look at Microsoft Access user-level security, a feature that lets you specify the level of access to grant each individual user of your database.
If you’re a Microsoft Office power user, you might be familiar with the encryption features of Word, PowerPoint and Excel. These programs all allow file owners to easily apply encryption. Unfortunately, Microsoft Access doesn’t offer similar functionality, but it still has relatively powerful security functionality. In this article, we’ll take a look at Microsoft Access user-level security, a feature that lets you specify the level of access to grant each individual user of your database.
Access and the Web
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.
All About NULL Values
Users new to the world of databases are often confused by a special value particular to our field – the NULL value. Read about the proper uses of NULL in this article.
Users new to the world of databases are often confused by a special value particular to our field – the NULL value. Read about the proper uses of NULL in this article.
SQL Server Administration (70-228) Practice Exam
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.
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 Forms in Access 2010
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.
Genealogy Database in Microsoft Access
Are you interested in tracing your family roots but don’t have a good place to store all of your genealogical information? While there are several full-featured family tree software packages on the market, you can also use a free Microsoft Access template to create your own genealogy database on your computer. Microsoft’s already done most of the work for you, so there is no programming knowledge needed to get started.
Are you interested in tracing your family roots but don’t have a good place to store all of your genealogical information? While there are several full-featured family tree software packages on the market, you can also use a free Microsoft Access template to create your own genealogy database on your computer. Microsoft’s already done most of the work for you, so there is no programming knowledge needed to get started.
MCTS 70-432 SQL Server Practice Exam
Free Practice Test for Microsoft Exam 70-432 Microsoft SQL Server 2008, Implementation and Maintenance
Free Practice Test for Microsoft Exam 70-432 Microsoft SQL Server 2008, Implementation and Maintenance
SQL Server Isolation Models
Normally, it's best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the ACID model. However, sometimes business requirements force database administrators to stray from the default behavior and adopt a less rigid approach to transaction isolation. To assist in such cases, SQL Server offers five different transaction isolation models.
Normally, it's best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the ACID model. However, sometimes business requirements force database administrators to stray from the default behavior and adopt a less rigid approach to transaction isolation. To assist in such cases, SQL Server offers five different transaction isolation models.
Should I Normalize?
Database normalization is one of the sacred cows of application development. Every undergraduate programming course you’ve taken or book you’ve read likely preaches about the importance of normalizing databases in an almost religious fashion. You’re made to feel like failure to normalize a database is tantamount to violating one of the laws of the universe. It’s time to challenge that truism. Sometimes it’s OK to denormalize your database
Database normalization is one of the sacred cows of application development. Every undergraduate programming course you’ve taken or book you’ve read likely preaches about the importance of normalizing databases in an almost religious fashion. You’re made to feel like failure to normalize a database is tantamount to violating one of the laws of the universe. It’s time to challenge that truism. Sometimes it’s OK to denormalize your database
Creating Relationships in Access
Join us as we walk through the process of creating database relationships in Microsoft Access.
Join us as we walk through the process of creating database relationships in Microsoft Access.
PHP
What is PHP? Find out here!
What is PHP? Find out here!
First Normal Form (1NF)
What is First Normal Form? Find out here!
What is First Normal Form? Find out here!
Creating an ADO Connection
The first step in developing an ADO application is to create a connection to a data source. This tutorial walks you through the process.
The first step in developing an ADO application is to create a connection to a data source. This tutorial walks you through the process.
Creating the Database File
In part five of our Building An Access Database From the Ground Up series, we create the Access database file that will be used for the Patrick's Widgets database.
In part five of our Building An Access Database From the Ground Up series, we create the Access database file that will be used for the Patrick's Widgets database.
Stored Procedure
Looking for a definition of the database term stored procedure? Find it here in the About Databases glossary.
Looking for a definition of the database term stored procedure? Find it here in the About Databases glossary.
Database Certifications
Popular database certifications are always in demand, whether it's Microsoft's MCTS or MCITP, Oracle's OCA, OCP and OCM or MySql's CMA, CMDEV and CMDBA. Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Database vendors offer a variety of professional certification programs that can help you advance your career while gaining valuable technical skills.
Popular database certifications are always in demand, whether it's Microsoft's MCTS or MCITP, Oracle's OCA, OCP and OCM or MySql's CMA, CMDEV and CMDBA. Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Database vendors offer a variety of professional certification programs that can help you advance your career while gaining valuable technical skills.
Access 2007 Books
So, you'd like to learn more about Microsoft Access 2007 and you don't know where to begin. I've selected
So, you'd like to learn more about Microsoft Access 2007 and you don't know where to begin. I've selected
SQLCMD Step-by-Step
Microsoft SQL Server provides users with a variety of rich graphical user interfaces to retrieve and manipulate data and configure SQL Server databases. However, sometimes it’s just easier to work from the old-fashioned command line. Whether you’re looking for a quick-and-dirty way to execute a SQL query or wish to include SQL statements in a Windows script file, SQLCMD allows you to meet your goal.
Microsoft SQL Server provides users with a variety of rich graphical user interfaces to retrieve and manipulate data and configure SQL Server databases. However, sometimes it’s just easier to work from the old-fashioned command line. Whether you’re looking for a quick-and-dirty way to execute a SQL query or wish to include SQL statements in a Windows script file, SQLCMD allows you to meet your goal.
Classification
What is classification? Learn about this data mining term here.
What is classification? Learn about this data mining term here.
Northwind in Access 2010
The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it in Microsoft Access 2010
The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it in Microsoft Access 2010
SQL Server Constraints
SQL Server constraints allow you to enforce rules in your database. These rules may affect business logic, database integrity and/or table structures. Each one plays an important role in your database architecture.
SQL Server constraints allow you to enforce rules in your database. These rules may affect business logic, database integrity and/or table structures. Each one plays an important role in your database architecture.
Oracle
What is Oracle? Find out here!
What is Oracle? Find out here!
SQL Server Data Types
Selecting appropriate data types is one of the most important considerations when designing a SQL Server database. Choices you make in the database design phase may have a significant impact on the efficiency, performance and storage requirements of your database down the road.
Selecting appropriate data types is one of the most important considerations when designing a SQL Server database. Choices you make in the database design phase may have a significant impact on the efficiency, performance and storage requirements of your database down the road.
Attribute
What is an attribute? Find out here!
What is an attribute? Find out here!
Retreiving Data with SELECT
The SELECT command is the most commonly used command in SQL. It allows database users to retrieve the specific information they desire from an operational database.
The SELECT command is the most commonly used command in SQL. It allows database users to retrieve the specific information they desire from an operational database.
Exporting Access Data to Excel
It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.
It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.
Rollback
What is rollback? Find out here!
What is rollback? Find out here!
Counting Values in a Table
The COUNT() function in SQL allows you to count database records based upon a variety of criteria. You can use it to count all records in a table, count unique values in a column or count the number of times records occur that meet certain criteria. This tutorial takes a brief look at each of these scenarios.
The COUNT() function in SQL allows you to count database records based upon a variety of criteria. You can use it to count all records in a table, count unique values in a column or count the number of times records occur that meet certain criteria. This tutorial takes a brief look at each of these scenarios.
Convert 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.
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.
Creating a SQL Server Database Account
SQL Server 2008 provides two methods for creating database user accounts - Windows authentication or SQL Server authentication. In Windows authentication mode, you assign all database permissions to Windows accounts. This has the advantage of providing a single sign-on experience for users and simplifying security management. In SQL Server (mixed mode) authentication, you can still assign rights to Windows users, but you may also create accounts that exist only in the context of the database.
SQL Server 2008 provides two methods for creating database user accounts - Windows authentication or SQL Server authentication. In Windows authentication mode, you assign all database permissions to Windows accounts. This has the advantage of providing a single sign-on experience for users and simplifying security management. In SQL Server (mixed mode) authentication, you can still assign rights to Windows users, but you may also create accounts that exist only in the context of the database.
SQL Injection Attacks
One common type of database attack, the SQL Injection, allows a malicious individual to execute arbitrary SQL code on your server. Let's take a look at how it works by analyzing a very simple web application that processes customer orders.
One common type of database attack, the SQL Injection, allows a malicious individual to execute arbitrary SQL code on your server. Let's take a look at how it works by analyzing a very simple web application that processes customer orders.
Record
What is a database record? Find out here!
What is a database record? Find out here!
Introduction to SQL Server
SQL Server offers full-featured relational database functionality in a user-oriented package. Learn about the various components of SQL Server in this article.
SQL Server offers full-featured relational database functionality in a user-oriented package. Learn about the various components of SQL Server in this article.
TRY...CATCH Error Handling
The TRY…CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and is an extremely important part of developing robust database applications.
The TRY…CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and is an extremely important part of developing robust database applications.
Backing Up Access Databases
Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-ste.
Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-ste.
Two-Tier or n-Tier?
What's best for your situation? Two-tier, three-tier or n-tier databases? Find out here!
What's best for your situation? Two-tier, three-tier or n-tier databases? Find out here!
Who Leads the RDBMS Pack?
According to most sources, Microsoft is rapidly gaining market share in the RDBMS arena. Have they finally surpassed Oracle? Read the latest results!
According to most sources, Microsoft is rapidly gaining market share in the RDBMS arena. Have they finally surpassed Oracle? Read the latest results!
Introduction to MySQL
Now that you've installed MySQL, it's time to perform some basic administrative and configuration tasks to ensure that your database environment is ready for production. In this installment of our MySQL series, we'll look at the process of configuring MySQL on a Windows system
Now that you've installed MySQL, it's time to perform some basic administrative and configuration tasks to ensure that your database environment is ready for production. In this installment of our MySQL series, we'll look at the process of configuring MySQL on a Windows system
Access 2007 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.
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.
Convert to Access 2007 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.
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.
Normalization
What is database normalization? Find out here!
What is database normalization? Find out here!
SQL Server 2005 Introduction
The long awaited Yukon is almost here! Microsoft plans to release SQL Server 2005 later this year and has packed the new database engine full of features.
The long awaited Yukon is almost here! Microsoft plans to release SQL Server 2005 later this year and has packed the new database engine full of features.