1. Computing
Send to a Friend via Email

Keys and Transactions

As you may already know, databases use tables to organize information. Each table consists of a number of rows, each corresponding to a single database record. So, how do databases keep all of these records straight? It's through the use of keys.

Databases Spotlight10

Database Beginner Tips

Tuesday April 22, 2014
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!

Read the full article: Top Five Things Beginners Need to Know About Databases

SQL Server on Azure

Thursday April 17, 2014
SQL Server Migration Assistant (SSMA) provides database administrators with a smooth way to transition from their existing database platform to Microsoft SQL Server. The migration assistants are able to transfer data to either a server-based SQL Server database or to Microsoft's SQL Azure cloud-based database platform.

Read the full story: SQL Server Migration Assistant

Creating SQL Server Traces

Tuesday April 15, 2014
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.

Read the full article: How to Create a Trace with SQL Server Profiler

MySQL on Windows 8

Thursday April 10, 2014

The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it's certainly possible to install it on a desktop operating system like Windows 8. Once you do so, you'll have the tremendous power of the flexible MySQL relational database available to you for free. It's an extremely useful database for both developers and system administrators. Installing MySQL on Windows 8 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here's a step-by-step walkthrough of the process.

Read the full tutorial: Installing MySQL on Windows 8

Discuss in my forum

©2014 About.com. All rights reserved.