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.

What is OLAP?

An interesting question and one that The OLAP Report attempts to answer. This article is an analysis of what the increasingly misused OLAP term is supposed to mean.

SQL Server 2000 User-Defined Functions White Paper

The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.