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

Content with tag sql server 6.5 Rss

   Items 1 to 20 of 64    Older >>
 

SQL Server 6.x Build List

The list of builds for SQL Server v6.x  Read more...
By Steve Jones 2010/08/26 | Source: SQLServerCentral.com | Category: sql server 6.5
Rating: (not yet rated) |  Discuss |   Briefcase | 165 reads

SQL 6.5 and Y2K

By Henrico Bekker 2010/08/13 | Category: sql server 6.5
Rating: (not yet rated) |  Discuss |   Briefcase | 2,760 reads

Versioning Over Time

How do you handle the tracking of changes across time in a database? Not auditing, but the actual structural and schema changes. Steve Jones talks about some of the issues with rapidly changing versions.  Read more...
By Steve Jones 2008/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 335 reads

Versioning Over Time

How do you handle the tracking of changes across time in a database? Not auditing, but the actual structural and schema changes. Steve Jones talks about some of the issues with rapidly changing versions.  Read more...
By Steve Jones 2008/12/10 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 323 reads

Versioning Over Time

How do you handle the tracking of changes across time in a database? Not auditing, but the actual structural and schema changes. Steve Jones talks about some of the issues with rapidly changing versions.  Read more...
By Steve Jones 2008/12/10 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 293 reads

Versioning Over Time

How do you handle the tracking of changes across time in a database? Not auditing, but the actual structural and schema changes. Steve Jones talks about some of the issues with rapidly changing versions.  Read more...
By Steve Jones 2008/12/10 | Source: SQLServerCentral.com | Category: editorial - mp3
Rating: (not yet rated)  Rate this |   Briefcase | 375 reads

SQL Server 2005 In-Place Upgrade Versions

By Key DBA 2008/03/28 | Category: sql server 2005
Rating: (not yet rated) |  Discuss |   Briefcase | 3,296 reads

SQL Server Security: Server Roles

As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.   Read more...
By Brian Kelley 2007/05/04 (first published: 2003/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 54,055 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

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,263 reads

SQL Server Security Part 2

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...
By Chris Kempster 2005/11/04 (first published: 2004/01/30) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,069 reads

Help! My Database is Marked Suspect.

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.   Read more...
By Brian Knight 2005/10/28 (first published: 2004/03/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 57,731 reads

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,852 reads

10 Steps to Securing your SQL Server

Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.   Read more...
By Brian Knight 2005/05/27 (first published: 2003/04/03) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 43,769 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

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

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,432 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

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,263 reads

Help! My Database is Marked Suspect.

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.   Read more...
By Brian Knight 2005/10/28 (first published: 2004/03/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 57,731 reads
   Items 1 to 20 of 64    Older >>
 
Tags
sql server 7 (33)    
administration (25)    
security (11)    
performance tuning (9)    
monitoring (7)    
configuring (4)    
legal issues (4)    
programming (4)    
t-sql (4)    
replication (3)    
strategies (3)    
miscellaneous (2)    
miscellaneous (2)    
ado (1)    
advanced querying (1)    
basics (1)    
best and worst practices (1)    
build list (1)    
database design (1)    
dts (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
sql server 2005 (1)    
sql-dmo (1)    
stored procedures (1)    
upgrading (1)    
worst practices (1)