Introducing IQReference

IQReference is an online reference platform using well known, published materials. Read about this exciting and benefical product.

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.

Undocumented Stored Procedures in SQL Server 6.5

This article examines some useful undocumented stored procedures in SQL Server 6.5

SQL Server Security Best Practices

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

Find The Baseball Players

Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.

Funny SQL Server Error Messages

This is the funniest error message Brian Knight has ever seen in SQL Server.

Using Uniqueindentifier Instead of Identity

Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.

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.