SQL Server Magazine

		Options
Security SQL Server 7.0 security features offer database administrators more flexibility and control. Here's an overview of SQL Server 7.0's rich security feature set.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Securing a Web Site on SQL Server 6.5

When a Web site’s traffic begins to outweigh the Web server's ability to keep up with the incoming client requests, you need to upsize the Web server. Take advantage of the opportunity to build in security measures.
By Mark Joseph Edwards 

Security in SQL Server 7.0

SQL Server 7.0 has a radically different way of validating logins and assigning permissions to users that will require you to rethink your security plan. With a little planning, securing your data can be much easier than with SQL Server 6.5.
By Morris Lewis 

Advanced JOIN Techniques

Advance your knowledge of SQL Server 7.0 joins with this detailed examination of their inner workings.
By Kalen Delaney  , et al.

Standalone DTS

Discover how to leverage DTS’ power and flexibility in a non-SQL Server environment.
By Don Awalt  , et al.

Certifiably SQL: Data Constraints and Integrity

Here are some study tips on using constraints with SQL Server 7.0.
By Michael D. Reilly 

Inside SQL Server: Parse, Compile, and Optimize

An introduction to the query processor.
By Kalen Delaney 

Mastering OLAP: Cell-level Security

SQL Server 7.0 Service Pack 1 (SP1) for OLAP services enabled the cell-level security feature. Here’s how to use the Decision Support Object (DSO) COM interface to set and manage security.
By Russ Whitney 

Querying & Reporting: Using Visual Basic to Drive Excel 97

Here is a simple application that leverages Visual Basic (VB) and Excel by integrating them into one powerful tool.
By Ken Spencer 

Solutions by Design: Adding a Questionnaire to a Design

The questionnaire is a popular and valuable source of data for an organization. After gathering the questionnaire data comes the inevitable question of how to integrate these questionnaires into an existing database’s design.
By Michelle A. Poolet 

SQL Server 7.0 Backup Roundup

Data backup matters! A reviewer compares four enterprise-level backup products and SQL Server’s native backup utility.
By Jonathan Cragle 

Editorial

Reliability and reputation. Strangely enough, users expect software to work -- and they should.
By Michael Otey 

Reader Challenge: Handling File Growth

Test your SQL Server Savvy
By Tibor Karaszi 

Reader to Reader: Undocumented Power

In SQL Server 6.5 and 7.0, Microsoft ships a set of stored procedures that let you use a one-line cursor query for querying the master database for all tables or databases and performing an action on the results.
By Brian Knight 

SQL Server Q & A

Answers from Microsoft
By Richard Waymire 

SQL Seven: The Coolest Shiloh Features

Here are the seven coolest new features forthcoming in Shiloh.
By Michael Otey