Database Journal News

Cloud Computing with Microsoft Azure SDS

July 10, 2009

Don Schlichting introduces the Microsoft Azure service and explores the SQL Data Services (SDS).

MySQL: Five More Dials To Turn

July 9, 2009

Last month we talked about some things to set and tune in a new MySQL database installation. We touched on connections, query cache, temp tables, session memory, and the slow query log. This second part in the series hits on some other very important things to tune in a new MySQL database.

RMAN Drills

July 8, 2009

This article and the next cover a couple of RMAN exercises using an older version of Oracle. The exercises or samples cover duplicating a database on the same server, and performing a tablespace point in time recovery (with a built-in error condition that requires some file editing).

Database Mirroring in SQL Server 2008

July 7, 2009

Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.

Working With Outlook from Access

July 6, 2009

Last month we discussed how to get data from Microsoft Access into Outlook objects, such as in the creation of new appointments, tasks, contacts and emails. This month we perform the reverse operation: get data out of Outlook into Microsoft Access.

Oracle Flashback Version Query—Trick or Trap

July 2, 2009

Learn how to use Oracle’s Flashback Version Query to not only see past data at a particular point in time but also to see how it changed over time.

Migrating Web Applications for use with SQL Anywhere Web Edition

July 1, 2009

This article outlines some of the motivation behind wanting to port existing applications over for use with SQL Anywhere, and then covers the steps necessary to do this.

Exploded Pie Chart for Analysis Services Data

June 30, 2009

MSAS Architect Bill Pearson leads the hands-on creation of an exploded pie chart based upon an Analysis Service data source.

T-SQL Best Practices

June 29, 2009

This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.

Creating Stored Procedures in MySQL Using HeidiSQL 4's Stored Routine Editor

June 26, 2009

In the "Write MySQL Queries Using HeidiSQL 4" article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. Today, we'll learn how to create a stored procedure using HeidiSQL's Stored Procedure Editor.