2,818 reputation
21351
bio website richard.gadsden.name
location Manchester, United Kingdom
age 41
visits member for 5 years, 2 months
seen yesterday

VB6 / VB.NET programmer, mostly Office, some ASP.NET

Also security, server and network administrator. And even helpdesk tech when they're short-staffed.




Jun
27
comment Why do I need to purchase an SSL certificate when I can generate one locally?
You could also use DNSSEC stapling for your SSL certificate, so the certificate derives (ultimately) from ICANN as CA, rather than from a another certification authority. None of the current browsers support this, though Chrome used to.
Jul
17
comment Disable IPv6 address autoconfiguration on Windows XP
Superb answer to a horrible situation.
Jul
17
comment MS SQL Server 2000 IPv6
... and SQL 2005 included a major redesign of connectivity, so that's not just Microsoft not listing it as supported, they actually added the functionality then.
Dec
11
comment windows internal database consuming a lot of memory
I'm doing a little tour of questions that relate to WID on Windows 2008 to note that Windows 2012 changes the pipe to \\.\pipe\MICROSOFT##WID\tsql\query
Dec
11
comment Can't access Windows Internal Database in SQL Server 2008 - login fails
I'm doing a little tour of questions that relate to WID on Windows 2008 to note that Windows 2012 changes the pipe to \\.\pipe\MICROSOFT##WID\tsql\query
Dec
11
comment Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)
I'm doing a little tour of questions that relate to WID on Windows 2008 to note that Windows 2012 changes the pipe to \\.\pipe\MICROSOFT##WID\tsql\query
Oct
29
comment What is the difference between SAN, NAS and DAS?
@Dan So there's no difference any more between a file server and a NAS?
Oct
25
comment ISA 2006 can run on Windows Server 2008?
This is going to create an interesting situation for Microsoft's support lifecycle. Windows 2003 End of Life is 14 July 2015; ISA 2006 End of Life is 10 January 2017, so you have a supported product, but no supported OS to run it on!
Oct
17
comment What's a read-only domain controller actually useful for?
@Massimo You don't need administrative access to AD to change anything - boot from a DVD and you can directly write to the AD databases.
Jun
27
comment Why is Enterprise Storage so expensive?
Worth pointing out that what is from the user's point of view "running out of space" may well be "filling your quota" from the sysadmin's point of view.
Apr
26
comment Cannot rebuild index because row above maximum size (Microsoft SQL)
Looks like there are lots of fixed length nullable columns. Certain rows have lots of empty columns (ie '' instead of NULL) and that appears to be the problem. I'm going to have to do a manual insert and replace all the ''s with NULLS
Apr
26
comment Cannot rebuild index because row above maximum size (Microsoft SQL)
Actually, in this case, there aren't lots of variable length columns, but lots of nullable columns. Same difference, though. I'll have a look.
Feb
2
comment Using .local for internal websites
@Brian Set up a domain search path on your computers (you can do this by Group Policy in the Microsoft world; I'm sure there are equivalents for Mac / Linux) and then all you need in the URL is http://app/
Oct
13
comment Multiple public IPs with multiple default routes - Windows
I'm in RIPE. And yes, there is a similar policy here too. But we're a heck of a lot closer to exhaustion, and RIPE NCC will probably say "no" based on experience.
Oct
7
comment Multiple public IPs with multiple default routes - Windows
That's what I do at our (much larger) main office, but have you tried getting a /24 these days? It was hard enough in an office where I could actually justify needing over 20 IPs; in an office where I really don't need more than three it will be impossible. I'll just have to buy a router that will let me do source based routing.
Sep
28
comment Exchange 2007 - Need to find all emails sent to and from particular domain
Did you ever resolve this?
Sep
7
comment What does fixup protocol http actually do on a Cisco PIX firewall?
Awesome answer!
Sep
1
comment How many computers can have the same public IP?
@Emanuil Rusev No. There are 65,536 ports, so the NAT router can allow 65,536 connections from 65,536 different computers at the same time. In theory, that's only to a particular IP address; they could have another 65,536 computers using those ports to connect to another IP address. In sum, if you got 100,000 requests from the same IP, then they are probably from less than 100,000 computers. But you can't say much more than that.
Jul
28
comment Our security auditor is an idiot. How do I give him the information he wants?
@Chopper3 Yes, I still think that it's inappropriate. Plus, I'm countering AviD.
Jul
28
comment Our security auditor is an idiot. How do I give him the information he wants?
-1 for the threat of physical violence