-
sp_who has a new column
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…
-
Transferring files to a box with McAfee VirusScan
If you have McAfee VirusScan on your server, most likely the On-Access Scan feature is enabled. This is good but can cause you problems when you transfer files to the server. For example, say you want to copy some install media to \\MyServer\C$, most likely it contains files like autorun.exe, autorun.inf, and/or autorun.ini. When you…
-
Quick guide to Database Mail in SQL Server 2005
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…
-
No remote connection to the other node(s) during Sql server cluster install
I have done a number of Sql Server cluster installs on a variety of platforms: 32-bit Sql Server 2000 on Windows 2000 and Windows 2003, 32-bit and 64-bit Sql Server 2005 on Windows 2003, both on AMD and Intel hardware. So I feel I am pretty experienced. Recently I did an install of Sql Server…
-
Connecting to Sql Server from Unix or Linux with FreeTDS
To connect to Sql Server from *nix environment, you can use JDBC (Java), Perl’s DBI and DBD packages, unixODBC, etc. You can also use another open source tool called FreeTDS. TDS stands for Tabular Data Stream. It is a protocol that defines how data is transmitted between computers. Both Sybase and Sql Server implement TDS.…