Category: Articles
-
Renaming a Failover Clustering Instance of SQL Server
Can you rename the SQL virtual name in a Cluster? The answer for this in SQL Server 2005 is obviously Yes. New to SQL Server 2005 is the ability to rename a clustered instance of SQL Server without having to uninstall and reinstall it.
-
SQL Server Configuration Settings
Introduction: This article brings you the allowable configuration options in SQL Server which includes options that are new to SQL Server 2008 also. The options can be used to tune, optimize and maximize the performance of the system in variety of ways. But careful planning and examination should be done before you implement the change.…
-
Database Mail
Introduction: Database Mail is a new feature that comes with SQL Server 2005. It was very difficult to configure and send mails with the SQL mail feature in SQL Server 2000. In fact SQL mail had lot of prerequisites and had few problems known and unknown. With SQL server 2005 Database mail had got a…
-
DBCC Commands
Introduction: Any SQL Server DBA does some maintenance or the other to the SQL Server instances and/or the databases. The maintenance tasks might include using some utility, scripts, third party software, TSQL, etc. The most used among them are the DBCC commands. This article brings in the list of commands available and those that are…
-
Memory Management in SQL Server
Introduction: I have heard people asking me how SQL Server manages memory. The answer to this was very difficult with SQL Server earlier versions. And with SQL Server 2005 it has been simpler to explain and understand. SQL Server by default installation manages memory dynamically and has settings that it can well negotiate with the…