SQL Server Magazine November 2001
[Focus]
Linking servers is fairly straightforward when they're all SQL Servers--but what happens when your company has data in both SQL Server and Oracle? Here's a guide to what Microsoft and Oracle don't tell you.
By John Paul Cook
[Features]
SQL Server 2000’s XML support is not only cool but practical. Here’s an example of how you can use it to build a search application for Web and WAP browsers.
By Wei-Meng Lee
The data-mining features in SQL Server 2000 Analysis Services can help your organization find the patterns and rules to improve its marketing, sales, and customer-support operations and gain a better understanding of its customers.
By Jim Yang , et al.
Windows Installer and a set of VBScript and T-SQL scripts deliver a one-two punch for custom-installing your SQL Server databases.
By William Sheldon
[SQL Server Savvy]
Learn how SQL Server orders data when you try to sort by a column which is defined with a uniqueidentifier data type.
By Brian Moran
Query Analyzer provides a simple but relatively unknown mechanism for working with properties.
By Brian Moran
Extended properties are great for managing metadata in SQL Server environments.
By Brian Moran
Learn how to use Profiler to display information about queries that Enterprise Manager generates.
By Brian Moran
To use table variables in a join, you must first alias the local table variable. Here's how.
By Brian Moran
[Editorial]
A one-size-fits-all approach to application implementation certainly requires less expense up front, but it comes with its own—and possibly much higher—cost in the long run.
By Michael Otey
[SQL Seven]
Use these SQL Server-specific performance counters to keep tabs on your system's response to gradual load changes.
By Michael Otey
[Mastering Analysis]
The number of users who work remotely is growing, but most analytic applications don't work without a network connection. Here's a way to give mobile users access to the specific data they need.
By Russ Whitney
[Solutions by Design]
Design a metamodel for scheduling a company’s employees and their work, workplaces, and work shifts.
By Michelle A. Poolet
[T-SQL Black Belt]
Forget cursors. The key to a successful switch to set-based programming is to test several approaches and optimize, optimize, optimize.
By Itzik Ben-Gan
[Answers from Microsoft]
Richard Waymire tells a reader how to replace the Named Pipes Net-Library.
By Richard Waymire
Richard Waymire helps a reader retrieve existing DDL information for rows in a new SQL Server 2000 table.
By Richard Waymire
Richard Waymire answers a reader’s question about sa mapping to DBO.
By Richard Waymire
Richard Waymire answers a reader’s question about estimating the time a query will run.
By Richard Waymire
Richard Waymire tells a reader how to work around a failed installation of SQL Server 7.0 SP2.
By Richard Waymire
Richard Waymire answers a reader’s question about dependency tracking.
By Richard Waymire
Richard Waymire answers a reader’s question about resetting the password for the SQL Server and SQL Server Agent services.
By Richard Waymire
Richard Waymire helps a reader use SQL-DMO to test a connection between VB and SQL Server.
By Richard Waymire
[Exploring XML]
Rich Rollman describes three techniques for detecting updategram errors.
By Rich Rollman
[Letters]
Readers submit an alternative solution for retrieving specified rows within a resultset and request continuing OLAP coverage.
By Various Authors
|
