SQL 2005 DBA

Learn about SQL Server 2005

0
Your rating: None

If you are new to SQL Server 2005, I have composed over time many links of interest to get you started. Just the basic introduction items will be here as most of this site includes detailed information on SQL 2005.

DBA Scripts

SQL Blocking & Lock Info

Partitioned Tables

How to Rename SQL Server

3
Your rating: None Average: 3 (5 votes)

You can rename a stand alone SQL Server name and it is best covered in this MSDN article: http://msdn2.microsoft.com/en-us/library/ms143799.aspx  You can also rename a virtual cluster name, but not the instance name as that requires a reinstall: http://msdn2.microsoft.com/en-us/library/ms178083.aspx

How to determine SQL Server Version and Edition

0
Your rating: None

Often in code you need to determine which version of SQL you are running against in a multi version environment. The ServerProperty function can help with this.

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

SQL 2005 Database Mail Troubleshooting

4.4
Your rating: None Average: 4.4 (5 votes)

Free Real-time Log Monitoring Tool

4
Your rating: None Average: 4 (1 vote)

Microsoft has a free utility that can read log (text) files in real-time, it's called SMS Trace. 

Poor Windows 2003 SP2 Networking Performance

0
Your rating: None

Experiencing poor networking performance on Windows 2003 server with SP1 or SP2 installed? Can't make sql connections to some servers? RDP doesn't work? RPC communication failure messages? But permissions are totally fine. Read on to learn more.

Top 10 Storage Tips for SQL 2005

0
Your rating: None

The SQLCAT team has some great guidance on storage configuration for SQL server: http://sqlcat.com/top10lists/archive/2007/11/21/storage-top-10-best-practices.aspx

Summary

Top 10 OLTP Performance Issues SQL 2005

0
Your rating: None

The SQLCAT team has a top ten list of OLTP performance issues: http://sqlcat.com/top10lists/archive/2007/11/21/top-sql-server-2005-performance-issues-for-oltp-applications.aspx

Summary

Top 10 Hidden Gems in SQL 2005

0
Your rating: None

The SQLCAT team has posted some good information about seldom used tools that should be of interest to many us: http://sqlcat.com/top10lists/archive/2007/11/21/top-10-hidden-gems-in-sql-server-2005.aspx

Summary