By S.S. Ahmed – Before starting, let's shed some light on the SQL Distributed Management Objects (SQL-DMO). ASP gets its functionality by using server components. In ASP we can combine scripts, HTML, and reusable server components to create scalable Web applications. These server-side ActiveX co

By Eran Sandler – Software is only as complicated as its developers make it. It seems like a very profound sentence but it is so true and it is relevant to all commercial software that I know of. Let's take a test case of a certain piece of software most of us have probably encounter

by Brad M. McGehee – Being a SQL Server DBA can be demanding and stressful, especially as the success of your company is often a function of your SQL Server’s uptime. While we, as DBAs, have some control over the uptime of our SQL Servers, we don’t have full control. There is not much we can do if a

By Joe Celko – Some answers to some common questions about SQL trees and hierarchies.

This paper discusses the design and implementation of a series of test scenarios that include building and querying cubes using Microsoft SQL Server 2000 and Analysis Services.

SQL Server 2000 gives users an excellent streamlined database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications. This paper provides brief overviews of the improvements made to SQL Server version 7.0. SQL Server 2000 offers users a fully i

From SQLTeam, Tim writes "The most obvious thing to do for records that have no unique column/s is to create an int identity column. For example, I have a 'address' table that should have a unique address_id for each record. Now, normally, I would configure a column address_id as 'in

The Local Cube Creator is an inexpensive ($49.00) utility that allows you to create a local cube from an Analysis Server (or OLAP Server) cube. It is identical in functionality to the Local Cube Task, except for three things:

Lumigent is pleased to announce the release of version 2.0 of Log Explorer for SQL Server. With new features, special pricing, and two separate editions, you'll see that Log Explorer is a "must have" product! Microsoft has chosen to present Log Explorer to their strategic SQL

Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization.