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

Articles with tag SQL Server 6.5 Rss

Search for any content tagged sql server 6.5

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

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

Automatically Gathering Server Information Part 2

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

Using Xp_cmdshell

One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.   Read more...
By Brian Knight 2003/11/14 (first published: 2001/05/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,831 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,119 reads

SQL Agent Problem

Andy takes us through a recent troubleshooting session that includes a call to PSS. Ever run agent from the command line? Have a good idea of what justifies a call to PSS? Read this to learn more.   Read more...
By Andy Warren 2003/07/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,782 reads

Example VSS Framework - Source Code Management - Part 1

We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs.   Read more...
By Chris Kempster 2003/07/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,486 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,775 reads

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.   Read more...
By Neil Boyle 2003/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,875 reads

How Safe are Your Passwords?

How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.   Read more...
By Joseph Gama 2002/12/10 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,783 reads

SQL Server 6.5: Index Statistic Details

This article examines how index statistics are used in SQL Server 6.5   Read more...
By Alexander Chigrik 2002/02/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 150 reads

SQL Server Encryption Best and Worst Practices

In this article by Neil Weicher, he talks about encryption of data and files for SQL Server.   Read more...
By Neil Weicher 2002/01/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,579 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,861 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,996 reads

SQL Server 6.5: Index Statistic Details

This article examines how index statistics are used in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/10/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,247 reads

Undocumented Stored Procedures in SQL Server 6.5

This article examines some useful undocumented stored procedures in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/09/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,224 reads

SQL Server 6.5 Data Page Structure

This article presents the technical details of the page layout for data in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,682 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,378 reads

SQL Server 6.5 Security Modes

A look at the different security modes availabe in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,380 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,989 reads

Locking in SQL Server 6.5

This article examines how locking occurs in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,862 reads
<< Newer    Items 21 to 40 of 62    Older >>