SqlServerCentral Announces New Guest Columnist

• by Andy Warren

• SQLServerCentral.com

We've got a new guest columnist! Click here to find out a little bit about Mindy Curnutt, then read her first article for SqlServerCentral.com.

Using Stored Procedures for SQL Server DML

• by Mindy Curnutt

• SQLServerCentral.com

• Stored Procedures

Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!

On Your Mark, Get set, Bill!

• by Steve Jones

• SQLServerCentral.com

• The Lighter Side

An oldy but goody...from the lighter side of Steve Jones.

SQL Server 6.5 Data Page Structure

• by Alexander Chigrik

• SQLServerCentral.com

• Administration

This article presents the technical details of the page layout for data in SQL Server 6.5

Using Cursor Metadata to Dynamically Generate HTML Tables

• by Les Smith

• SQLServerCentral.com

• Miscellaneous

The following stored procedure will demonstrate the use of cursor metadata. Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures.

SQL Server 2000: .NET and the Death and Re-Birth o

• by Additional Articles

• Microsoft MSDN

• Triggers

In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.

The DBA Dot Com Bust

• by Steve Jones

• SQLServerCentral.com

• State of the Business

The downturn in the economy has left quite a few technical people out of work. This ongoing article describes the experiences over the past two years of Steve Jones. Reader experiences are requested and the article will be updated weekly.

Lock View: sp_lock2

• by Alexander Chigrik

• SQLServerCentral.com

• Performance Tuning

An alternative procedure for viewing locks based on sp_lock.

SQL Server 2000 Operations Guide

• by Additional Articles

• Microsoft MSDN

• Administration

Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.

Review: SQL Server 2000 Database Design

• by Andy Warren

• SQLServerCentral.com

• Book Reviews

Is this a book you should read? Spend a few minutes reading the review to find out!