Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, SQL Server 6.5 Rss

<< Newer    Items 21 to 40 of 43    Older >>
 

Reducing Round Trips

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...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,851 reads

SQL Server Security Part 1

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...
By Chris Kempster 2005/02/11 (first published: 2002/01/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 49,987 reads

Lock View: sp_lock2

An alternative procedure for viewing locks based on sp_lock.   Read more...
By Alexander Chigrik 2001/07/24 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,367 reads

Encrypting Data With the Encrypt Function

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...
By Brian Knight 2006/05/29 (first published: 2001/07/17) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,977 reads

Non_Continuous Replication

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...
By Andy Warren 2001/05/15 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 4,692 reads

Securing Your SQL Server

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...
By Brian Knight 2001/05/14 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,426 reads

Using the Public Role to Manage Permissions

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...
By Andy Warren 2001/05/10 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 17,261 reads

Sweeping Up The Slackers

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...
By Steve Jones 2001/05/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,991 reads

Duplicate Key Inserted Error During Replication

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...
By Andy Warren 2004/10/15 (first published: 2001/05/04) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 8,462 reads

Altering Replicated Tables

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...
By Andy Warren 2001/05/02 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 7,210 reads

Analyze Databases Using Coefficient

In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.  Read more...
Rating:  Rate this |   Briefcase | 1,182 reads

DSN-Less Connections

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...
By Andy Warren 2001/05/02 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 5,045 reads

Moving Logins - A Gotcha!

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...
By Andy Warren 2004/05/12 (first published: 2001/05/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,819 reads

Log Your Changes

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...
By Steve Jones 2001/04/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,336 reads

Automatically Gathering Server Information Part 8

The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,481 reads

Restoring the Master Database

This article shows you in a step-by-step manner how to restore the master database.   Read more...
By Brian Knight 2001/04/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,790 reads

Automatically Gathering Server Information Part 6

The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,480 reads

Automatically Gathering Server Information Part 5

The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2001/04/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,672 reads

Introduction to DSN's

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...
By Andy Warren 2001/04/23 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 7,835 reads

Not All SQL Server Indexes Are Created Equal

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...
By Additional Articles 2004/09/24 (first published: 2001/04/22) | Source: SQL Server Performance | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,431 reads
<< Newer    Items 21 to 40 of 43    Older >>
 
Tags
administration (16)    
security (9)    
monitoring (7)    
performance tuning (6)    
configuring (3)    
programming (3)    
replication (3)    
strategies (3)    
t-sql (3)    
ado (1)    
advanced querying (1)    
basics (1)    
best and worst practices (1)    
database design (1)    
dts (1)    
miscellaneous (1)    
sql server 2005 (1)    
sql-dmo (1)    
upgrading (1)    
worst practices (1)