SQL 2005 DBA
SQL Blocking & Lock Info
- http://www.sommarskog.se/sqlutil/beta_lockinfo.html - Erland has created a great all in one script for SQL 2005 SP2 blocking information. He also has a different script for previous versions.
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
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')
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.
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
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
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