by Drew Georgopulos – 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.

Learn how other companies put together their SQL Server disaster recovery plans.

Q. As you’re building an index on a table, does SQL Server block access to that table?A. SQL Server doesn’t block read access to the table you’re building an index on unless you’re building a clustered index. However, if someone tries to update the table’s data, SQL Server blocks the update—

By Brian Moran – Currently, Microsoft doesn’t have a grid-computing story to tell in the SQL Server space. Oracle has been talking nonstop. SQL Server users will be faced with hard choices if Oracle delivers a commodity grid-computing solution years ahead of Microsoft.

by Baya Pavliashvili – Check out this and other tips at SearchDatabase.com.(R)

By Marcin Policht – In the last article of this series, we will focus on Web Services and their implementation in the SQL Server 2000 environment with the help of the SQLXML component. In particular, we will look into a non-programmatic way of publishing SQL Server 2000 stored procedures, user-defin

By Gregg Keizer – A panel of leading security experts Wednesday blasted Microsoft for vulnerabilities in its software, and warned that reliance on the Redmond, Wash.-based developer’s software is a danger to both enterprises and national security.

By Michael Hotek – SQL Server 2000 provides three technologies that you can use to build highly available systems. But availability is more than technology. This article can help you put all the pieces together.(R, $)

To be a successful DBA, you must have an inquisitive mind and a desire to learn. Much of the DBA’s knowledge will be self-taught, especially in these days of austere budgets and cost cutting. One of the most cost-effective ways to learn something new is by reading. Fortunately, there is no shortage

(Lisa Vaas) The latest battle in the war against database piracy took place on Capitol Hill on Tuesday, as the Coalition Against Database Piracy testified before a joint House Judiciary and Energy and Commerce Subcommittee hearing on draft legislation to protect against database thievery.