260 reputation
115
bio website basetable.wordpress.com
location Edinburgh, United Kingdom
age 25
visits member for 4 years, 4 months
seen Jul 2 at 13:01

Education is learning what you didn't even know you didn't know. - Daniel J Boorstin

On my day job I maintain a large database application for a growing Edinburgh-based travel search company. Every day I learn more about development and administration in the trenches, including how to cope with legacy worst practices and how to benefit from SQL Server best practices.

Studying part-time at Dundee University for an MSc in Business Intelligence.


May
27
comment How do I edit text files in the Windows Command Prompt?
Doesn't seem to work with psexec. Tried to edit my hosts file with copy con hosts but ^Z doesn't save and ^C doesn't cancel! Had to close the cmd window to get out. The file was unchanged.
Dec
12
comment Print screen with cursor in Windows 7
@Dennis When you press ALT + PrintScr to capture the window, the tooltip disappears just before the capture (ALT changes the window state). Work around the issue by pressing PrintScr to capture the whole screen and crop with the built-in editor.
Dec
6
comment Why does `psql --file` misinterpret tilde?
Since I discovered that psql accepts spaces instead of equals, I always use spaces. It's simpler that way. Thanks for the well-researched answer!
Nov
22
comment Can't install pg gem on mac os x Lion
Did you find a solution for this? It might be worth asking a moderator to migrate this to Stack Overflow. SO has many more Ruby experts.
Nov
15
comment Why does restarting a computer fix things?
MinWin appears to be Microsoft's push in the same direction. Robert McLaws on Windows Server Core: "Microsoft started to chart out the entire Windows dependency graph. And as they saw things that started calling up the stack when they weren’t supposed to, they rearranged the APIs to create a clean separation in the OS. MinWin is the result of that work. It is not a complete rewrite of the kernel, but a reorganization of the APIs, so that components only call down the stack, and not up it."
Nov
15
comment What's causing this boot freeze?
@techie007 Added my event log analysis. It's the best lead I have. I also performed a memory test, a hard disk test, and an optical boot test. If you think the results would help, I'll add them as well.
Nov
13
comment How to diagnose computer freezing problem
+1 for the LiveCD idea.
Oct
5
comment How to check which timezone in Linux?
On Precise Pangolin echo $TZ returns nothing for me.
Oct
5
comment Print screen with cursor in Windows 7
What a hidden gem. Unfortunately it draws a big green border around the active window, which obscures any tooltip that lies partially outside the window area. For example, you can't use it to cleanly capture Firefox's Open Containing Folder tooltip.
Sep
28
comment Why does restarting a computer fix things?
Thanks for the link to Raymond Chen's article. I don't think your summary accurately reflects the author's views. He doesn't say it should be this way. He concludes: "So it's not that Windows has to restart after replacing a file that is in use. It's just that it would rather not deal with the complexity that results if it doesn't. Engineering is a set of trade-offs." It makes me wonder: What trade-offs did the Linux developers choose? (Linux is noted for requiring a restart less frequently.) Do they deal with the complexity, or do they just break things?
Sep
28
comment How can I solve this error I get when I commit changes on an SVN repository from the Ubuntu terminal?
To reproduce: sudo rm -f ~/.nano_history (remove the file), sudo nano somefile (edit some file as root), ^K sometext (search for some text), ^X (exit), nano somefile (edit some file as you). You'll see Error reading /home/ssylee/.nano_history: Permission denied. nano creates .nano_history to store your search history. The file belongs to root if it is created during a sudo nano session.
Sep
26
comment How do I make sudo preserve my environment variables?
Solved my problem on Server Fault! Thanks.
Aug
23
comment Is there a Shortcut for “Mark all messages as read” in Outlook?
When you have an inbox with 25,000 messages it's hard to scroll to the last message. It does work, though.
Aug
23
comment Is there a Shortcut for “Mark all messages as read” in Outlook?
This is slow in a large inbox, but works. I have 25,545 items in my inbox and 4,778 unread items. Outlook became unresponsive for a minute when I pressed CTRL+A to select all. When I pressed CTRL+Q to mark all as read, a dialog appeared for a minute to show a progress bar. After another minute, I have no unread emails. Thanks!
Aug
23
comment Is there a Shortcut for “Mark all messages as read” in Outlook?
Some keyboards have a menu key that simulates a context-click. It's usually between right ALT and right CTRL. It looks like a cursor hovering over a menu.
Aug
23
comment Is there a Shortcut for “Mark all messages as read” in Outlook?
Which context menu contains the item 'Mark all as read'? I can see a 'Mark as read' item when I highlight one or many messages and bring up the context menu. Is that what you mean?
Aug
23
comment Is there a Shortcut for “Mark all messages as read” in Outlook?
Sorry, I don't understand this. Do I have to press three keys together? I have only one E key. I tried holding ALT and pressing E twice while focused on the message pane but nothing happened.
Nov
24
comment Deleting entire lines in a text file based on a partial string match with Windows PowerShell
@JasonMArcher Can you post an example using Set-Content? I don't believe that Set-Content is a drop-in replacement for Out-File.
Nov
1
comment How can I allow non-administrators to use shutdown.exe?
+1 This helped to solve a 'Using Windows Server 2012 as a workstation' problem. How do I turn off the computer as a user rather than an administrator? By adding the Users group to the 'Shut down the system' right!
Sep
30
comment How can I copy this quote from PDF?
I forgot that Google cached PDFs that way! Very useful. I edited your answser to include a step-by-step guide with pictures to make this answer more generally useful.