6,368 reputation
11223
bio website ratsauce.co.uk
location Chester, United Kingdom
age 52
visits member for 4 years
seen Apr 15 at 17:02
stats profile views 478

Semi retired old time computer nerd who started programming on a Commodore Pet.

Since I'm also active in the Physics forum I should add that I started as a theoretical chemist, moved into solid state photochemistry and finally worked in industry as a colloid scientist. I only became a full time computer nerd in 1997.


Jun
26
comment Local disk resources not working when connecting with remote desktop
Get you colleague to TS from your laptop. If the drives don't connect it's your laptop, if they do it's your account. It's possible to disable drive connection in the Active Directory user properties (on the Environment tab of the user properties).
Jun
25
comment How to workaround the NTFS Move/Copy design flaw?
Well it's a trade-off. If inheritance were real-time then every time you opened a file at the bottom of a deep tree the OS would have to run up the tree to find out what the effective permissions are. Of course the tradeoff is if you change the permissions at the top of a deep tree you have a loooong wait! Doesn't Active Directory use the same model?
Jun
25
comment Can I change a live SQL Database from Autogrow safely?
Paul, I ran the script from your blog and sure enough 98% fragmentation. However a simple reindex reduced the fragmentation to zero again. Is there some longer term harm that a reindex does not cure?
Jun
25
comment Active Directory: Is it required that the “A” record for a domain point to a Domain Controller?
Of course if you would be happy to use domain.com the problem goes away (unless you have a server called "www").
Jun
25
comment Can I change a live SQL Database from Autogrow safely?
Re SuperCoolMoss' comment, you need to do a full or log backup first to truncate the log (or backup log with truncate only if you absolutely must). This truncates the log but won't shrink the .ldf file. You need the dbcc shrinkfile for that. NB dbcc shrinkfile is unlikely to do much unless you truncate the log first.
Jun
25
comment Howto migrate the system partion to another disk on Windows 2008 enterprise
See my edit ...
Jun
25
comment Slow INFORMATION_SCHEMA query
Left joins seem to be particularly problematic.
Jun
24
comment Is this a good way to install SQUID on Windows?
The question is a way of advertising how easy SQUID can be to set up on Windows!
Jun
24
comment vim syntax files under windows vista+?
See my reply. You live and learn :-) Of course real nerds use the command line!
Jun
24
comment Slow INFORMATION_SCHEMA query
You'd have to looks closely at the data in the tables to see why, but bear in mind that the total record count in the joined tables could be 376*2224*2221*2224*2221, which is, erm, a large number. Normally the joined columns are indexed and the join is very efficient, however with left joins I have seen SQL give up on indexing and resort to table scans. This makes things very slow. Exactly how SQL decides this I don't know.
Jun
23
comment How can I monitor failed job steps on SQL server?
I suspect this is a cultural thing. I run all my scripts from one server so I can see at a glance everything that's being run by opening one .bat file in Notepad, and I can see what time(s) they run by running \\myserver and looking in the scheduled tasks. To an old time command line nerd like me this seems easy.
Jun
23
comment Slow INFORMATION_SCHEMA query
See the edit to my post.
Jun
23
comment Exchange Server 2003: Auto-BCC
Create a distribution group containing both Mark and William and set this group as the forwarding address for both users. Leave the "Deliver messages to both ..." box ticked for both users. Now any mail that comes in for either Mark or William is delivered to them both without any mail loops.
Jun
23
comment Dell Open Manage - Finding Information
Bad blocks? As far as I know the RAID BIOS doesn't show bad blocks either. SCSI disks shouldn't show any bad blocks anyhow, as they dynamically remap any sectors deemed to be at risk. If you look in the OpenManage logs they will contain any errors or warnings from the RAID controller. I forget which log they usually appear in.
Jun
23
comment Exchange Server 2003: Auto-BCC
In AD Users and Computers select the Organisational Unit where you want to create the distribution group. Right click the OU and choose New then Group. Set the group type to "Distribution". I usually leave the Group scope on Global (the difference between Global and Universal is a bit involved to explain). Feed in the group name as appropriate. Note that it may take a few minutes for Exchange to ste up the group's e-mail address.
Jun
22
comment Manage local network Internet usage
Did you use my notes? If so have you edited local_network.txt and what if anything did you do about enabling Windows authentication?
Jun
22
comment PowerShell Quickstart
As Doug says below, I found the best approach was to choose a problem. Then search the Script Center for example code and do it. The Powershell language is very simple, it's learning all the useful scriplets and objects supplied by Powershell that takes the time. If you sit down and start coding, with the Script center to hand, you'll be surprised how quickly you pick it up.
Jun
22
comment Simple VPN for iPhone using Windows Server 2008
OK, but make sure you read up on RRAS before you enable it as it isn't trivial to configure. Also make sure your current hardware can forward GRE or IPSEC to your server (if you use NAT many can't). Yes, changing the firewall costs money, but it's a lot simpler.
Jun
21
comment Respond to HTTP OPTIONS with basic auth
Do I get my Necromancer badge? :-)
Jun
21
comment Respond to HTTP OPTIONS with basic auth
You can disable WebDAV without appcmd, but obviously if you need WebDAV you're stuck. Even if you need WebDAV maybe you could still split the site into two separate sites, one with WebDAV enabled and one without. They could point to the same physical directory and you would use the WebDAV disabled site only when you don't want the HTTP OPTIONS verb to be processed. Other than that, your suggestion of an ISAPI filter is the only solution I can think of. Sorry :-(