DevX: Latest Database Content

Restore a SQL Server 2008 Database into SQL Server 2005

Chris Goddard — Wed, 07 Jan 2009 19:42:41 PST

You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.

An Introduction to the Yahoo! Query Language Platform

Jonathan Trevor — Tue, 23 Dec 2008 18:47:08 PST

Yahoo! has released a base platform that opens up Yahoo! user data via web standard APIs and also provides a framework for how developers, publishers, and advertisers can build applications on and off Yahoo!.

Find and Generate Missing Values in an Access Table

Gustav Brock — Wed, 17 Dec 2008 19:02:54 PST

Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. Find it here.

Adobe AIR: Running SQL Commands Against a Local Database

Kathryn Rotondo — Tue, 16 Dec 2008 20:33:41 PST

Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.

Flexible and Powerful Data Binding with WPF

Walt Ritscher — Mon, 15 Dec 2008 18:09:23 PST

Microsoft has been building data binding frameworks for years, and each promises to solve our data binding woes forever. But we're still waiting for the perfect one. Could WPF data binding be the one we've been waiting for?

SQL Techniques for Performing Operations on Matrices

Alex Kozak — Wed, 10 Dec 2008 18:53:07 PST

SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.

Build Composite WPF Applications

Brian Noyes — Mon, 08 Dec 2008 16:34:16 PST

Build loosely-coupled, maintainable WPF applications using the Composite Application Guidance patterns and practices.

Creating an oBAMP Stack: OpenBSD, Apache, MySQL, and PHP

Gregory L. Magnusson — Sat, 06 Dec 2008 14:48:41 PST

The OpenBSD, Apache, MySQL, and PHP (oBAMP) platform provides a powerful point of departure for the creation of dynamic web content. Learn the procedures for running OpenBSD 4.4 with Apache SSL, MySQL 5, and PHP 5.

Execute a Block of Text in SQL Server Management Studio

Cindy Rodriguez — Tue, 02 Dec 2008 16:51:44 PST

In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.

Beans Binding: A Java Data-Binding Solution with a Serious Problem

Jacek Furmankiewicz — Wed, 19 Nov 2008 16:36:43 PST

Data binding simplifies how you sync a data object's properties with their visual representations, and Beans Binding for Java (JSR 295) aims to deliver a default data-binding specification for the Java platform. Find out how to use Beans Binding and work around its onerous overhead.