Diagnosing and Troubleshooting Slow Partitioned Merge Processes

Direct from Microsoft, learn how to achieve scalable, high-performance merge replication applications.

Support WebCast: How to Connect to Analysis Services over the Internet

See how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection.

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!

The undocumented nature of sp_readerrorlog in SQL Server 2000

Sp_readerrorlog can read any file on the hard disk, not just error logs. Read on to learn how!

Pitfalls to Avoid when Designing OLAP Cubes

Creating even the simplest of cubes has its pitfalls. This article by Daniel Gallager steers you through the sometimes treacherous world of OLAP.

SQLServerCentral.com Launches its New Contest!

Is your budget tight this year? Be the user who enriches the SQL Server community the most and receive the top prize of a full version of Lumigent's Log Explorer (a $995 value!). You could also win an Apress prize pack or a T-SQL Solutions subscription. Any SQLServerCentral.com user who helps to build the SQL Server community by submitting a script, posting in the forum or posting an original FAQ is eligible.

SQL Server Encryption Best and Worst Practices

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.

BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.

How to Setup Log Shipping with SQL 2000

This white paper outlines the following:

-The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition.

-The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition.

-A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.

Advanced T-SQL for SQL Server 2000

A new T-SQL Bible that is a must have for SQL Server DBAs. Read a review of this book.