SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

How to Upgrade a SQL Server 7.0 Cluster to a SQL Server 2000 Cluster

Every time I have to perform some major work on my production SQL Server clusters, I spend a lot of time researching and planning the task at hand. And when it comes to something as big as an upgrade from a SQL Server 7.0 Cluster to a SQL Server 2000 cluster, I even spend more […]

SQL Server 2000 Undocumented Stored Procedures

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 2000. sp_MSget_qualified_name This stored procedure is used to get the qualified name for the given object id. Syntax sp_MSget_qualified_name object_id, qualified_name where object_id - is the object id. object_id is int.qualified_name – is the qualified name of the […]

Real Life DBA: Dealing with a SQL Server Cluster Failover

Monday 9:30AM I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived […]

Microsoft SQL Server & Solid State Accelerators

Solid State Accelerators make it possible for you to give your peripheral storage the speed of memory. Essentially, a Solid State Accelerator is Solid State memory technology with an attitude, which emulates a conventional disk drive or array. It includes a built-in UPS backup system that allows the data to be copied to an available […]

Testing SQL Server 2000 Clusters

If you have successfully gotten this far, most likely the SQL Server 2000 cluster is ready to be used. But before I trust any production systems on a new cluster, it is a good idea to test the SQL Server 2000 cluster to see if it is really working as it should. This section takes […]

Installing the SQL Server 2000 Service Pack

Because of the nature of SQL Server 2000 clustering, you want to ensure that it is as reliable as possible. One of the ways to help ensure that is to be sure that you have installed the latest SQL Server 2000 Service Pack on the SQL Server 2000 Cluster before you put it into production. […]

Installing SQL Server 2000 Clustering

If you have ever installed SQL Server 7.0 in a cluster, you will need to forget what you know, as installing SQL Server 2000 into a cluster is quite different, and in fact, it is much easier.The following steps should be run from the node of the cluster that you consider your primary node. This […]

Preparing for SQL Server 2000 Clustering

The purpose of this section is to show you how to install SQL Server 2000 clustering onto a Windows 2000 two-node cluster. It already assumes that the cluster server hardware has been installed and configured correctly, and it assumes that Windows 2000 Clustering Services have also been installed and configured correctly.This document provides an example […]

How to Install SQL Server 2000 Clustering

SQL Server 2000 clustering can add much needed reliability and fault-tolerance to a production SQL Server 2000 system. But as you might imagine, its installation and configuration is not as easy an installing SQL Server 2000 on a single server. The purpose of this article is to show you how to install SQL Server 2000 […]

The Ultimate SQL Server

If you are like most DBAs, you probably don’t get a lot of opportunity to work on really big SQL Server machines. I mean the kind that can crunch a 10 million-row table in seconds without breaking into a sweat. The kind of server that can take requests from a 1,000 clients all at the […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |