Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag SQL Server 7 Rss

Search for any content tagged sql server 7

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

Free Encryption

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.   Read more...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: | Category: security
Rating: |  Discuss |   Briefcase | 75,446 reads

Reverse engineering alias data types - Part 5

Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.  Read more...
By Yakov Shlafman 2008/04/17 | Source: | Category: sql server 7
Rating: |  Discuss |   Briefcase | 1,151 reads

Starting SQL Server in Minimal Configuration

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.   Read more...
By Jay Dave 2007/05/10 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 7,209 reads

Updated SQL Injection

SQL injection has been a hot topic the last couple years and there are some great articles at 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.   Read more...
By Michael Coles 2008/03/21 (first published: 2005/09/21) | Source: | Category: security
Rating: |  Discuss |   Briefcase | 83,799 reads

Conditional Flow in DTS

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.   Read more...
By Wayne Fillis 2007/06/07 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 9,996 reads

SQL Server DBA Fights a Demon

An interesting tale of David Bird's fight with tempdb.  Read more...
By David Bird 2008/03/17 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 7,604 reads

Using VBScript to Automate Tasks

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.   Read more...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 100,379 reads

Open Source SQL DDL Scripting Tool

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.   Read more...
By Richard Sutherland 2007/03/06 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 9,550 reads

Five Realtime DTS Examples

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.   Read more...
By Jambu Krishnamurthy 2007/03/22 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 16,930 reads

Quickly Moving Databases

This article by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline.   Read more...
By Chris Kempster 2008/02/08 (first published: 2004/05/18) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 147,422 reads

A Failed Jobs Monitoring System

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)  Read more...
By TJay Belt 2009/09/04 (first published: 2008/02/05) | Source: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 22,514 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: | Category: installation
Rating: |  Discuss |   Briefcase | 152,981 reads

Running a Query Using a Text File for Input

When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools.   Read more...
By Roy Carlson 2007/03/01 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,155 reads

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.   Read more...
By Robert Cary 2007/01/22 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 7,924 reads

The Dynamic Process of Loading Data

When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.   Read more...
By Janet Wong 2007/01/23 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 9,900 reads

Overview of DTS Packages

While SQL Server 2005 is greatly changing the paradigm of ETL with Integration Services, SQL Server 2000 and DTS will be here for some time to come. New author Rama Nageshwara brings us an overview of this fantastic data movement toolset.   Read more...
By Rama Nageshwara 2007/12/21 (first published: 2005/11/09) | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 26,862 reads

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.   Read more...
By Wayne Fillis 2007/03/23 (first published: 2007/01/24) | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 52,739 reads

Exception handling in DTS

While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.   Read more...
By Jambu Krishnamurthy 2006/12/19 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 9,017 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 14,321 reads

Customizable Error Log Scanning

Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems.   Read more...
By Thomas LaRock 2006/12/27 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 8,522 reads
<< Newer    Items 21 to 40 of 941    Older >>