SQLServerCentral.com Articles tagged SQL Server 7

Disaster In The Real World - #2

Fri, 14 Dec 2012 07:00:00 UT

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.

SQL Server 7 Build List

Thu, 26 Aug 2010 15:59:57 UT

A list of builds and versions for SQL Server 7.

A Failed Jobs Monitoring System

Fri, 04 Sep 2009 06:00:00 UT

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)

Sending E-mail from SQL Server 200X

Wed, 01 Jul 2009 06:00:00 UT

From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.

Enhancing the readability of your code: Table aliasing in sql

Thu, 07 May 2009 06:00:00 UT

When writing SQL, picking good tables aliases can greatly enhance the readability of your code

From the Real World: SQL Server 2000 SP4 Installation Failure

Wed, 04 Mar 2009 07:00:00 UT

SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes

Get Error Description in SQL Server 2000

Tue, 13 Jan 2009 07:00:00 UT

How to Extract Error Description in SQL Server 2000 based on Error Number

Proxy Accounts in SQL Server

Tue, 30 Dec 2008 07:00:00 UT

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them

Powering up DTS with PerlDTS

Mon, 22 Dec 2008 07:00:00 UT

This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.

The Full Potential of SQL 2000

Mon, 01 Dec 2008 07:00:00 UT

Attending a conference and hearing about all the latest and greatest new features is a bit like spending holiday sampling exotic seafood and imbibing strange new cocktails. When you return, you're decidedly in the mood for a pie and a pint of beer.

Compare Dates in an iterative manner for a particular set of records

Wed, 12 Nov 2008 07:00:00 UT

Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000

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

The Basics of Sizing a SQL Server Database

Fri, 01 Aug 2008 06:00:00 UT

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.

SQL Server Security: Pros and Cons of Application Roles

Fri, 25 Jul 2008 06:00:00 UT

Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.

Return Query Text Along With sp_who2 Using SQL 2000

Fri, 18 Jul 2008 06:00:00 UT

This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".

Bookmark Lookups

Fri, 18 Jul 2008 06:00:00 UT

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.

Log Shipping vs. Replication

Fri, 27 Jun 2008 06:00:00 UT

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.

Oracle and SQL Server Data Interoperability Issues - Part 1

Fri, 06 Jun 2008 06:00:00 UT

As much as we're SQL Server folks here, sometimes we do need to connect to other data stores. Hai shares some of his experiences doing so. Might come in handy someday.

XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000)

Wed, 04 Jun 2008 06:00:00 UT

SQL Server MVP Jacob Sebastian continues his very successful XML series with a foray into SQL Server 2000's XML capabilities for generating custom documents.

Is a Temporary Table Really Necessary?

Fri, 30 May 2008 06:00:00 UT

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.

Worst Practices - Not Using Primary Keys and Clustered Indexes

Fri, 09 May 2008 06:00:00 UT

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!

Free Encryption

Fri, 25 Apr 2008 06:00:00 UT

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.

Reverse engineering alias data types - Part 5

Thu, 17 Apr 2008 06:00:00 UT

Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.

Starting SQL Server in Minimal Configuration

Mon, 14 Apr 2008 06:00:00 UT

Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.

Updated SQL Injection

Fri, 21 Mar 2008 06:00:00 UT

SQL injection has been a hot topic the last couple years and there are some great articles at SQLServerCentral.com on this topic. Michael Coles brings us an updated look at this SQL Server security issue with some new examples you might not have previously thought.

Conditional Flow in DTS

Wed, 19 Mar 2008 06:00:00 UT

While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

SQL Server DBA Fights a Demon

Mon, 17 Mar 2008 06:00:00 UT

An interesting tale of David Bird's fight with tempdb.

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

Using VBScript to Automate Tasks

Fri, 07 Mar 2008 07:00:00 UT

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.

Open Source SQL DDL Scripting Tool

Mon, 03 Mar 2008 07:00:00 UT

Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.

Five Realtime DTS Examples

Fri, 08 Feb 2008 07:00:00 UT

SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server 2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.

Quickly Moving Databases

Fri, 08 Feb 2008 07:00:00 UT

This article by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline.