-
Grant database read/write access to Windows login
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…
-
Swedish Candy / Godis
Relatives from Sweden brought us Swedish candy this summer. It sure made the family very happy. Thanks Malin and Mathias. It’s great to have you here! In case you don’t know, I am a Swede who dyes his blond hair black as a fashion statement. Godis Saft, sylt, och O’boy
-
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…
-
A short trip to Madison, Wisconsin
We took a short trip to Madison, Wisconsin, before school got started. It was a pretty good trip. The only downside of it is that it is too short. (I learned over the years that “The vacation/weekend is too short” is a fairly common response when you ask the question. I do mean it here,…
-
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…