SQL Server Magazine

		Options
Web Application Security Learn how to write secure SQL Server-based applications, how to get the data you need from poorly designed tables, how to take advantage of two new DTS 2000 tasks, and how to use SQL Mail to simplify SQL Server 2000 administration and troubleshooting.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Many Levels of Web Security

Safeguard your Web applications by using COM+ components to provide vital authentication and authorization services.
By Ken Spencer 

Rest Secure

Keep your SQL Server--based applications secure by being aware of what code is getting back to the server at every tier.
By Chip Andrews 

DTS 2000 in Action

DTS 2000’s new Dynamic Properties and Execute SQL tasks help programmers zip through package development and testing.
By Larry Barnes 

SQL Server's Got Mail!

Use SQL Mail to simplify SQL Server 2000 administration and troubleshooting.
By Christopher R. Shaw 

The First Abnormal Form

Ever find yourself stuck with an assignment to code against poorly designed tables? Learn some tricks that will help you get the data you need from these abnormal tables.
By Jeffrey Bane 

SQL Server Savvy

Brian Moran answers readers’ questions about tracing events on a selected SQL Server machine, retrieving specified rows within a result set, and more.
By Brian Moran 

A True .NET Server?

Is SQL Server 2000 a true .NET Server? Michael Otey says the relational database management system falls short of meeting all the .NET Server requirements. But the next SQL Server version will fill in the holes.
By Michael Otey 

Answers from Microsoft

Richard Waymire answers readers’ questions about estimating replication time, changing database names during a restore, and more.
By Richard Waymire 

Cool Resource Kit Tools

Here are seven cool tools in the Microsoft SQL Server 2000 Resource Kit.
By Michael Otey 

Time for a Tune-Up

Try these tips and tricks to keep your indexes working their best.
By Kalen Delaney 

Analyze Disk Utilization

This column, which continues last month’s discussion of analysis applications, shows you how to build an application that monitors disk usage.
By Russ Whitney 

Using T-SQL to Create T-SQL

The rarely used cross join is an option when you need to create a large number of tables.
By Michelle A. Poolet 

The Auxiliary Table Advantage

Sometimes, the use of an auxiliary table can help you provide shorter, more efficient code than a solution that doesn’t use an auxiliary table.
By Itzik Ben-Gan 

Exploring XML

In this column, Rich looks at follow-up questions about some of the subjects covered in previous columns such as transforming a recordset into an XML document, querying a column that contains an XML document, and more.
By Rich Rollman