SQL Server provides you with numerous ways to back up your database, but the best backup solution won't help you if you don't know how to restore your backups. In this 10-Minute Solution, SQL Server Pro Joe Lax walks you through the RESTORE command and demonstrate its various options. More info

You need certain data values to complete a database-programming job, but you don't know where they're located. What can you do? Follow this 10-Minute Solution to navigate through an unfamiliar database, and locate and extract the table and column names that house your values. More info

If you maintain SQL Server databases, you must be familiar with the various backup solutions that are available, as well as know when to apply each one. SQL Server Pro Joe Lax shows you the commands to execute each backup and discusses how to choose among the various options you have. More info

As we race towards better object technology, some people seem content to put relational database systems out to pasture—for no good reason. More info

SQL Server 2000 is the first version of the DBMS to enable SQL programmers to write their own functions. SQL Server Pro Joe Lax explains the three ways to write a user-defined function in SQL Server 2000. More info

Learn how statistics are used to help determine execution plans. More info

Randy Holloway explains how to use SQLXML 3.0 with SQL Server to expose Web services through your ASP.NET applications by executing T-SQL stored procedures and user-defined functions. More info

One of the most important factors in dynamic web page development is database definition More info

Get an overview of the Oracle Application Server 10g architecture, its functional components, the administrative tools for application development, and examples of commands that are used to perform frequent Application Server 10g administrative functions. More info

Learn about the CROSSJOIN() function, whose mission it is to combine two sets of dimension members into one. More info