650 reputation
47
bio website
location Pennsylvania
age 37
visits member for 4 years, 2 months
seen Jul 2 at 19:37

Jan
3
comment Fast Compression of Database Backups
What SQL server are you using? MS SQL (since 2008 I believe) and PostgreSQL have compressed backups which may be good enough for your purposes.
Dec
4
comment Postgres 8.4 stopped working
Ouch. Windows generally locks running executables and DLLs and prevents their replacement. (You can, however, rename the running program and put the new one in place.) If you attempted to use an MSI based installer it probably replaced some of the files but others will be replaced on reboot. You can try killing pg_ctl.exe and all the postmaster.exe processes, which should kill everything that's running. Then you can attempt to reinstall 8.4.17 and the service.
Oct
29
comment A faulty Caviar Blue hard drive?
Individual hard drives are simply not that expensive. There's no reason not to have a 3rd drive as a hot spare or sitting on a shelf ready to be installed at a moment's notice. Then you're not in the uncomfortable place where you're hoping the last drive doesn't die while you're waiting for the replacement and rebuild.
Oct
29
comment A faulty Caviar Blue hard drive?
Make sure your backups are working, up to date, and more importantly, restore properly. RAID is not a substitute for a backup.
Oct
29
comment A faulty Caviar Blue hard drive?
If you're going to use WD drives, make sure to get drives designed to run in a RAID, like the WD Reds. Google for TLER for more information.
Jul
13
comment Windows file sizes
NTFS can do tail packing, where extremely small files have their contents placed in the MFT entry itself. It's not the only filesystem to do that either. Explorer still reports 4k used on disk for these files though.
Jun
11
comment Why is it a bad idea to use a customer email as the from address
"Interestingly the server sending the email and the mail box that it is going to are both behind the same firewall so the client says they are unconcerned about spam." That's fine as long as the application also behind the same firewall and not reachable by the rest of the internet. Hopefully this mail box inside the firewall is also not available from the internet -- it sounds like an open relay!
May
10
answered SQL Server 2008 r2 SP2 IA64 Vs x64 Vs x86
Apr
19
awarded  Yearling
Mar
20
comment Secure TCP based protocol through an application layer firewall
Generally speaking servers already don't trust clients when it comes to the internet. What can other programs running on the clients do that a proxy is going to prevent? They can't talk to other servers in A, they can't talk to other services on a, so the only thing left is if they send non-compliant data -- what can a proxy do that the service already in place can't?
Mar
19
answered Secure TCP based protocol through an application layer firewall
Oct
19
comment Defrag in Windows VM?
Is it theoretically possible for a guest's HD to be "fragmented" (as the VM sees it) badly enough for split I/O to become a problem inside the VM? That would be one of very few use cases I can think of for defragmenting inside a VM. I'm not sure how a VM would get to that state while still being otherwise useful though.
Oct
16
answered Confused with creating an ODBC connection, apparently I have two separate odbcad32.exe files?
Oct
7
comment For L2ARC and ZIL: is it better to have one large SSD for both, or two smaller SSDs?
Those most likely to be intimately familiar with ZFS are more likely to be at Server Fault than SuperUser. Voting to move, but an excellent question.
Oct
2
comment Scan raw block device data for known file types on linux
Beat me to it! It's also possible to add your own signatures if necessary.
Sep
26
comment What's the purpose of a wildcard DNS?
I use it for development as well. With Apache's mod_vhost_alias‌​, setting up a new site is as easy as creating a directory.
Sep
25
comment Multiple DHCP offers
If you can't touch the proprietary system directly, filter the traffic so DHCP requests don't arrive to it. (or prevent replies from getting out)
Apr
19
awarded  Yearling
Apr
17
comment Should I serve compressed PDFs?
+1 - A properly created PDF should already be compressed. If not, then it should be modified or redistilled unless there's some mitigating factor. (e.g. must be sent through a production workflow that doesn't support compressed streams/images inside the PDF)
Dec
28
comment Blinking Cursor when booting restored Ghost image
Thanks for the follow up. Good to see that it's system specific. Do you think that BIOS revisions come into play? I can understand if the answer is "I don't know, and to be honest, I'd rather not bother with it anymore." :-)