Using AWE Memory in SQL Server 2000

Learn how to take advantage of AWE memory to boost the performance of SQL Server 2000.

SQL Server Gets Java Support

Microsoft has liscensed JDBC drivers to be included with SQL Server.

Managing Spatial Information with SQL Server

You already know how to use SQL Server to manage your core business data, now learn how to leverage this knowledge to manage your "spatial" data.

DATE: September 25, 2001
TIME: 2:00pm ET, 6:00pm GMT
DURATION: 40 minutes, including questions & answers at the end

With SpatialWare for SQLServer, you now have the ability to manipulate spatial objects and store them inside of SQL Server allowing you to share information across the enterprise.

SQL Server Security Best Practices

Learn how to secure your data by implementing SQL Server security best practices.

DBCC SQLPERF (Logspace) Reporting Internals

This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.

Support for Network Database Files

By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.

Microsoft SQL Server OLAP Services Cell-Level Security

This article describes how SQL Server 7.0 (Service Pack 1) OLAP Services takes advantage of the user and group structure in Microsoft Windows NT to offer cell-level security, and describes several ways to tailor permissions to data across the enterprise.

Connection Pooling with Microsoft SQL Server 2000 Analysis Services

This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)

SQL Server Database Coding Conventions and Best Practices

Learn the key basics of writing quality Transact-SQL code.

Measure for Measure

Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools.