A default installation of Sql Server 2005 is pretty easy. After install, you can connect to it remotely, either through Sql Server Management Studio or sqlcmd. However, if you install a named instance on the same box, you may not be able to connect to it remotely, although connecting to it locally would still work.…

In Sql Server 2005, you cannot cluster Sql Server Integration Service (SSIS). During database cluster install, you can pick to install Integration Service. SSIS will only be installed on the node where installation process starts from. For example, suppose you have Node1 and Node2, and the install is started from Node1, then database service and…

Regular readers may have noticed that I am a big fan of automation. As such, for repetitive tasks, I prefer scripting over point and click. Nothing wrong with point and click though. For one time task, I don’t mind using GUI to get it done quickly. Repetitive is the key word here. Below is a…

For Sql Server DBAs, sp_who is an indispensable diagnostic tool for researching, monitoring, and troubleshooting. For example, you can use it to iterate through all sessions to a particular database, logins used, and host name where a session is initiated from, etc.. sp_who is modified slightly in Sql Server 2005. It now returns one additional…

All right dear reader, I am sure you’ve waited long and hard for this moment. So let’s cut to the chase. Here is the gist of Database Mail in Sql Server 2005: 1. Say goodbye to the silly and cumbersome Sql Mail of SQL Server 2000; 2. Database Mail uses SMTP service. You can use…