SQLServerCentral.com Articles tagged SQL Server 6.5

SQL Server 6.x Build List

Thu, 26 Aug 2010 16:21:34 UT

The list of builds for SQL Server v6.x

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Versioning Over Time

Thu, 11 Dec 2008 07:00:00 UT

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.

Versioning Over Time

Thu, 11 Dec 2008 03:25:21 UT

Versioning Over Time

Thu, 11 Dec 2008 03:12:11 UT

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Versioning Over Time

Thu, 11 Dec 2008 01:37:04 UT

SQL Server Security: Server Roles

Fri, 04 May 2007 06:00:00 UT

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.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Encrypting Data With the Encrypt Function

Mon, 29 May 2006 06:00:00 UT

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.

Measuring SQL Performance

Fri, 23 Dec 2005 07:00:00 UT

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.

SQL Server Security Part 2

Fri, 04 Nov 2005 06:00:00 UT

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.

Help! My Database is Marked Suspect.

Fri, 28 Oct 2005 06:00:00 UT

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Reducing Round Trips

Fri, 15 Jul 2005 06:00:00 UT

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.

10 Steps to Securing your SQL Server

Fri, 27 May 2005 06:00:00 UT

Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

SQL Server Security Part 1

Fri, 11 Feb 2005 07:00:00 UT

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.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Duplicate Key Inserted Error During Replication

Fri, 15 Oct 2004 06:00:00 UT

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.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Not All SQL Server Indexes Are Created Equal

Fri, 24 Sep 2004 06:00:00 UT

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.

Moving Logins - A Gotcha!

Wed, 12 May 2004 06:00:00 UT

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

Measuring SQL Performance

Fri, 23 Dec 2005 07:00:00 UT

Help! My Database is Marked Suspect.

Fri, 28 Oct 2005 06:00:00 UT

If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.

Review of Review of SQL Server 2000 Administrators' Companion

Fri, 26 Mar 2004 06:00:00 UT

Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.

Dump SQL Permissions

Wed, 17 Mar 2004 06:00:00 UT

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.

SQL Server Security Part 2

Fri, 04 Nov 2005 06:00:00 UT

Automatically Gathering Server Information Part 2

Thu, 25 Dec 2003 07:00:00 UT

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

Using Xp_cmdshell

Fri, 14 Nov 2003 07:00:00 UT

One of the most handy extended stored procedures in SQL Server is xp_cmdshell. This article will show you how to use it.

SQL Server Security: Server Roles

Fri, 04 May 2007 06:00:00 UT

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.

SQL Agent Problem

Wed, 09 Jul 2003 06:00:00 UT

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.

Example VSS Framework - Source Code Management - Part 1

Mon, 07 Jul 2003 06:00:00 UT

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.

10 Steps to Securing your SQL Server

Fri, 27 May 2005 06:00:00 UT

Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.

Saving Space To Increase Performance

Fri, 21 Feb 2003 07:00:00 UT

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.

How Safe are Your Passwords?

Tue, 10 Dec 2002 07:00:00 UT

How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.

SQL Server 6.5: Index Statistic Details

Fri, 08 Feb 2002 07:00:00 UT

This article examines how index statistics are used in SQL Server 6.5