Reputation
1,425
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 11 31
Impact
~247k people reached

Feb
20
answered Will there ever be faster CD and DVD discs and writers?
Feb
19
comment I just ran rm /* accidentally, any fix?
lug.wsu.edu/node/414
Feb
15
comment How do I change the default format for an date time value copied from SSMS to Excel
It does not affect the behavior I'm trying to change because Excel isn't using any of the formats listed there. It may be used to produce some of the alternate formats I can change the cells to use; but the default format Excel is picking isn't on that dialog.
Feb
15
comment How do I change the default format for an date time value copied from SSMS to Excel
Despite having office in the URL, your second link directs to how to change OS level default formats; the one Excel is defaulting to isn't on that dialog so it's apparently getting it from somewhere else.
Feb
15
awarded  Quorum
Feb
14
comment How do I change the default format for an date time value copied from SSMS to Excel
@nixda No twice over. Firstly: Open Excel, change cell format, paste data isn't any less tedious than open Excel, paste data, change cell format. Secondly, if the data I'm pasting has numeric columns I want those to be treated as numbers for the purpose of sorting not as text.
Feb
14
asked How do I change the default format for an date time value copied from SSMS to Excel
Jan
31
awarded  Informed
Jan
31
comment How do I physically prevent people from unplugging an Ethernet cable?
+1 for #1. All the other solutions will fail because the universe's ability to create idiots always wins.
Jan
31
comment How do I physically prevent people from unplugging an Ethernet cable?
The OP's primary reason of concern appears to be damage to ports on the desktops. That's something that would only happen because of people yanking the cords out abusively. This seems likely to deter the people who unplug the cables correctly; but not the idiots who're yanking the cables out violently enough to damage hardware (because they don't understand they're supposed to press the clip to release them, or just don't care). My concern is that locking the cables in more tightly will increase the likelyhood of them breaking ports before figuring out their stupidity won't work.
Jan
31
comment How do I physically prevent people from unplugging an Ethernet cable?
What happens when someone tries yanking it hard thinking it's just stuck or tries to overcome the locking mechanism via brute force?
Jan
31
comment How do I physically prevent people from unplugging an Ethernet cable?
I'm not sure how well this would work. First couldn't you force the cable through the loop. Second those little zipties are typically only rated for 25/40lbs; snapping one by hand isn't hard; and jamming a pen/cil into the small loop where the one ties onto the case would probably work even if you don't have the strength needed to rip it free.
Jan
28
comment How do I tell if a laptop has a TPM without buying it first
@Darael only as a last resort; and I'd probably be forced to contact OEMs directly since I'm skeptical about Newegg's support staff knowing that.
Jan
28
asked How do I tell if a laptop has a TPM without buying it first
Jan
28
comment Why does one person downloading kill the internet for the rest of the house?
...especially if the text consists of base64 encoded binaries.
Jan
24
comment Increase page file or buy RAM?
@JourneymanGeek I wouldn't waste money buying new ram; but DDR1 is really cheap on ebay. If you're concerned about getting dud parts, buy from a computer salvage company with good reviews instead of some random person trying to part out his personal relic. Don't forget to run memtest86 overnight once you install the ram.
Jan
23
comment Why do laptops need fans but tablets don't?
@JoelCoehoorn I purged the list of running services, and killed every tray background app I could and it still fell short on battery life. Otherwise performance was usable since aside from lacking HT the CPU was in the same ballpark as an atom. From the other direction "go back to kindergarten and learn how to write correctly" is the proper solution but not an SU answer. My handwriting is horrific and poking at the on screen keyboard was faster than drawing blockprinted letters. Fundamentally though I don't care enough to put time into it; especially since the batteries probably near dead.
Jan
23
comment Why do laptops need fans but tablets don't?
@Karan There've been fan sporting windows/pen tablets for over a decade. Somewhere in my clutter I've got one with a 12(?) inch screen, about an inch thick, that was good for 5-6 hours/charge with XP and a ULV p3-900ish processor. For ~$140 it made a usable ereader when an early kindle was $300+. I never used it for much else, XP's hand writing recognition needed better penmanship than mine; and while W7 could handle my scrawl it idled at 5% load, enough that the chip never made the lowest power state and battery life collapsed to ~3 hours.
Jan
18
revised What is “.Net Framework 4.5 Advanced Services”?
Added info on Advanced Services
Jan
18
revised What is “.Net Framework 4.5 Advanced Services”?
Rewrite based on feedback in comments.