Developer.com: Your Home for Java and Open Source Development Knowledge

Database Section Index

3 SQL Join Concepts to Help You Choose the Right Join

By Jason Gilmore

| Database Article Published 14-Feb-11

Conceptualizing your desired data's relationship with database tables will quickly help you determine which type of SQL join to use.

10 Command-line Timesavers for MySQL Tasks

By Jason Gilmore

| Database Article Published 28-Oct-10

Whether you pick and choose or apply all 10, these MySQL command-line tips will save you a great deal of time and effort.

CouchDB Hits 1.0 with Open Source NoSQL for Windows, Too

By Sean Michael Kerner

| Database Article Published 14-Jul-10

First production-ready milestone of the CouchDB open source NoSQL database is released, providing stability and performance gains for developers and users.

MongoDB Delivers NoSQL Flexibility and Scalability to Developers

By Jason Gilmore

| Database Article Published 16-Jun-10

The NoSQL database MongoDB is on the rise because of its flexibility and scalability. Find out how to implement MongoDB in your Web development.

Crank Up the Volume with HTML5 Music

With HTML5, music is making a comeback on the Web. In this tutorial we will show you how to create amazing music experiences for visitors to your website--and it's as easy as inserting an image.

Doctrine: Object Relational Mapping for Your PHP Development

By Jason Gilmore

| Database Article Published 11-Jun-10

Use Doctrine, the open source object-relational mapper, to map database tables to PHP objects.

Top 10 MySQL GUI Tools -- Plus One for the Command Line

By Sean Hull

| Database Article Published 18-May-10

Here are ten outstanding graphical interfaces for MySQL management, development and administration, as well as one great MySQL toolkit with a wealth of command-line tools.

Video: Analyzing MySQL Queries with EXPLAIN

By Jason Gilmore

| Database Article Published 28-Apr-10

The MySQL EXPLAIN statement provides insight into MySQL's query execution plans. This video demonstrates how you can use this powerful feature to boost your MySQL database performance.

The Basics of SQL Joins in MySQL

By Jason Gilmore

| Database Article Published 29-Mar-10

SQL JOINs can help you retrieve interrelated data stored in multiple tables from your MySQL (or really any relational) database.

Five Indispensable MySQL Tools

By Jason Gilmore

| Database Article Published 26-Feb-10

Use these powerful tools to increase your MySQL development productivity.

Mnesia: A Distributed DBMS Rooted in Concurrency

By Roberto Giorgetti

| Database Article Published 10-Feb-10

Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers.

Installing SQL Server 2008

By Greg Larsen

| Database Article Published 20-Nov-09

Need your server and your site up and running quick? Let Greg Larsen show you what you need to know to get SQL Server running and configured.

Using new location-aware data types in SQL Server 2008

By Jani Järvinen

| Database Article Published 21-Sep-09

Learn how leverage location based data using Microsoft SQL Server 2008 from C# applications and combine them with interactive maps.

Performance Improvement: Understanding

By Robert Bogue

| Database Article Published 29-Jun-09

The results you get out of any performance prediction exercise are bound to be wrong. The goal is to make them as least wrong as possible. Rob Bogue will help you understand how to avoid getting them too wrong.

Using SQL Server 2008 Change Data

By Jani Järvinen

| Database Article Published 14-Apr-09

In many business applications, it is crucial to know how data has changed over time. For developers, this is not a new problem; many different solutions have been created to log changes. But creating a log is time-consuming. Read on to learn how SQL Server 2008 can help you save time and work more effectively.

Text Transformation with MGrammar and the Oslo SDK

By Jeffrey Juday

| Database Article Published 17-Feb-09

Learn to build a text DSL in MGrammar.

Updating a Database from WinForms Controls, Old School

By Paul Kimmel

| Database Article Published 12-Feb-09

Old school programming, whereby the programmer reads control values and writes inline SQL, still works, but it's so 90s. If you are new to WinForms or Web programming but experienced, peruse the article and then master LINQ.

Using T-SQL CROSS APPLY and OUTER APPLY

By Paul Kimmel

| Database Article Published 26-Jan-09

Elevate your SQL game (a little bit) with CROSS APPLY and OUTER APPLY.

Building Microsoft Oslo Models

By Jeffrey Juday

| Database Article Published 18-Dec-08

Learn modeling and M development with the Oslo CTP SDK.

Exploring the Oslo Repository

By Jeffrey Juday

| Database Article Published 08-Dec-08

Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.

Building a Windows Workflow SQL Server Integration Services Activity

By Jeffrey Juday

| Database Article Published 27-Oct-08

Learn to how to make SQL Server Integration Services a part of Windows Workflow Foundation.

.NET Tip: Using a Nullable Value Type

By Jay Miller

| Database Article Published 03-Oct-08

Discover how to use nullable types when retrieving data from your database.

Deploying and Configuring SQL Server Integration Services Packages Without the Wizard

By Dee Quang

| Database Article Published 02-Oct-08

Ever get confused by or dislike using the SQL Server Integration Services deployment wizard? Learn how to manually deploy the packages to SQL Server 2005 and configure the packages in a multitude of ways as well.

Dynamically Building Windows Presentation Foundation DataTemplates

By Jeffrey Juday

| Database Article Published 15-Sep-08

Discover how to use the XamlReader to dynamically create a Datatemplate. Then, see how you can bind to a Dataset and display the data in a ListView control (via a sample application pointing to the Northwind database).

TIP: Nested Stored Procedure Calls with SQL Server Transactions

By Michael Klaene

| Database Article Published 02-Sep-08

Discover how you can utilize SQL Server transactions when nesting calls to stored procedures.

Creating Native Web Services in SQL Server

By Bipin Joshi

| Database Article Published 25-Aug-08

Expose your SQL Server data directly over the web. Learn to create SOAP-based native web services in SQL Server 2005/2008 that can be consumed from client applications over HTTP.