1. Computing
Send to a Friend via Email

Discuss in my forum

Mike Chapple

Databases

By

Follow me on:

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
Installer

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

Access 2013 Form Management

Tuesday April 8, 2014
Access 2013 Form

Looking for an easy way to facilitate data entry for your Microsoft Access 2013 database? Using the application's built-in form functionality may meet your needs.

Read the tutorial: Creating Forms in Access 2013

Databases on ACID

Saturday April 5, 2014
The ACID model is one of the oldest and most important concepts of database theory. It sets forward four goals that every database management system must strive to achieve: atomicity, consistency, isolation and durability. No database that fails to meet any of these four goals can be considered reliable.

Read the full article: The ACID Model

Windows Authentication on SQL Server

Friday April 4, 2014
In a recent forum message, a user wrote:

"Right now we are using SQL authentication for accessing our SQL Server database. We are planning to switch to Windows authentication.

What steps do you think I should follow?"

Can you help? Interested in answers to the same question? Visit the About Databases Forum and join the discussion!

What are Facts and Dimensions?

Thursday March 27, 2014
Facts and dimensions form the core of any business intelligence effort. These tables contain the basic data used to conduct detailed analyses and derive business value. In this article we take a look at the development and use of facts and dimensions for business intelligence.

Read more: Facts vs. Dimensions

Introduction to Data Classification

Monday March 24, 2014
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. Read the full article: Data Classification Simplified

Running MySQL on Windows 8

Thursday March 20, 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

Regular Expressions in SQL

Tuesday March 18, 2014
You may often need to create a SQL Server query that performs inexact pattern matching through the use of wildcard characters. The use of wildcards allows you to find data that fits a certain pattern, rather than specifying it exactly. For example, you can use the wildcard 'C%' to match any string beginning with a capital C.

Read the full article: Pattern Matching in SQL Server Queries

Creating Mailing Labels with Access 2013

Thursday March 13, 2014


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 using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.

Read the full story: Printing Mailing Labels in Access 2013

©2014 About.com. All rights reserved.