One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.   Read more...

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...

An alternative procedure for viewing locks based on sp_lock.   Read more...

One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.   Read more...

Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.   Read more...

Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.   Read more...

This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!   Read more...

Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.   Read more...

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.   Read more...

Need to make changes to table that is an article in a publication? Read this article to get step by step instructions on how to do it without doing a new snapshot!   Read more...

In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.  Read more...

Confused about the difference between using a DSN or DSN-less connection? This article by Andy warren explains the differences and offers some insight into when each is appropriate.   Read more...

This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5   Read more...

How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.   Read more...

The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

This article shows you in a step-by-step manner how to restore the master database.   Read more...

The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...

This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!   Read more...

Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.   Read more...