6,628 reputation
11224
bio website ratsauce.co.uk
location Chester, United Kingdom
age 53
visits member for 4 years, 11 months
seen Apr 11 at 17:03

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
30
comment MSDE database disappeared after receiving a connection error during a query
See my edit for the details
Jun
30
comment How to explain memory usage on Windows Server outside the list of running processes
See my edit for some further thoughts
Jun
30
comment Copy NT user accounts between servers
I've just tested addusers.exe (in a limited way) on Windows Server 2008 and it worked fine. I'd be very surprised if it doesn't work on Windows 2003 as it's just using the NetXXX functions in the Win32 API.
Jun
29
comment Gettings back to SBS sp1 from SP2 so I can run the transition pack
I suppose it's surprising the transition pack works at all, given that it basically reinstalls everything. All I can say is that I'm glad I will (probably) never have to use it ever again! Reinstalling as a new domain is exactly what I would. Good luck :-)
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 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.