Automated administration is the programmed response to a predictable administrative responsibility or server event. By using automated administration, you can free time to perform administrative tasks that lack predictable or programmable responses and require creativity.

Excel SpeedWriter v1.3 has been released. Generate Excel Spreadsheets from ADO or DAO databases (or variables or arrays) on the Desktop or Server in record time. Excel SpeedWriter is the ultimate in speed, power, reliability and ease-of-use. Virtually all Excel features are supported.

By Chris Prosise and Saumil Udayan Shah – In our last column, we looked at how tiny oversights in Web applications that make SQL queries can lead to security vulnerabilities with serious consequences. Before we dive into further SQL details, let's look at why resolving such errors is so importan

A Microsoft® SQL Server™ 2000 Meta Data Services installation consists of certain core components, each of which can vary by version or format. A single configuration includes the following: a DBMS, a repository engine, a repository database, one or more information models, and an Extensible Markup

From Sql Team – Jerald writes "Dear SQL Team, I am working on SQL Server 7 and also on SQL 2000. Now our company has many SQL Servers running on the Network and also in different domains. Now is there a way where I can find out which SQL Servers are currently running on the Network and list them

By Evan Koblentz – Embarcadero Technologies Inc. last week announced a Sybase version of its SQL Debugger tool, which will be available later this month for Sybase's Adaptive Server Edition 12.0 and 12.5 as a plug-in to Embarcadero's DBArtisan product. It's the first third-party debugger

By Michael D. Reilly – SQL Server's powerful backup and restore capability offers reliable protection for your data. If you have an effective backup-and-restore strategy, you can sleep well at night knowing that if a problem occurs, you can recover from it with minimal downtime and minimal disru

Tip by Stan Zylowski – Suppose you have a shopping cart with several categories of products, and your ASP pages use SQL statements that access database queries for the different categories. Instead of creating an ASP page for each category (for example, shirts.asp, caps.asp, and so on), you can have

By Chris Prosise and Saumil Udayan Shah – For many of us, Web applications have become as much a part of our daily life as the meals we eat. (Some of us even eat while we work on Web apps.) Unfortunately, just as these applications are something else that we have to cook up, they're just as susc

By Russ Whitney – Solve order and pass numbers are among the most complex concepts in SQL Server 2000 Analysis Services' MDX language. Many analytical applications require calculations—in the form of calculated members, custom formulas, and cell calculations—to be embedded in the cubes. Individu