Hey everyone,
Welcome back to HTHDI, sorry for the down time, server went down last month due to script kiddies and just haven’t had the time to put everything back together.
The site is back up and fully working now, I’m still in the process of putting everything back together so don’t be surprised if stuff moves from day to day.
Anywho welcome back and how you find some helpful tips.
Regards
Smurf
Hey all,
Thought I would post up my latest little tip, just spent the last hour trying to get my laptop to connect to my work PC, only to find as usual a single checkbox ruining my life.
Normally when working from I just jump on my normal desktop rig and off I run no issues. When I’m out and about I fire up my trusty Dell Adamo. This afternoon though I decide to work from the lounge as I was only loading data and doesn’t need alot of attention just the occasionaly an F5, silly idea on my part.
Although my laptop will quite happily connect using my 3G dongle, apparantly it didn’t feel the same way about using my wifi connect at home. Even though my desktop was connecting to work perfectly, the laptop VPN connection repeatly kept going to failover server and returning “Unable to reach server”
Ok troubleshoot time, can i browse — yes, ping VPN server — yes… hmmmm ok then, retry on desktop fine…. crap, test using 3G on laptop fine… ok it’s the laptop and wifi then… router firewall – check, router ports – check, reset router – no change wtf…… rebuild tcp stack – nope, recheck all settings – fine …. hang on I don’t share my internet connect untick… boom working.
That’s was all it was stupid ICS apparantly will stop Nortel VPN from connecting, I assume it must have something to do with IPtunnelling and security but apparantly doens’t deserve a custom “turn off ICS you fool” error.
Either way if you find yourself receiving “Unable to reach server” next time you try to VPN have a quick check to make sure ICS(internet connection sharing) is off.
1. Open Control panel -> click on Network & sharing center
2. Click on “Change adaptor settings”
3. Right CLick on the connection you are usng and select properties then click on the “Sharing” tab.
4. Untick “Allow other netowrk users to connect through this computer’s Internet connection”
5. Click Ok
and that’s it, reattempt to VPN and should be working. (maybe restart PC if fails)
Anywho time for some TF2, hope this helps
Cheers
Smurf
Like most corporate Outlook users I tend to have a running battle with in-box space the minuscule 130mb that is allocated tends to get chewed up in a matter hours(especially with people spamming 4mb excel attachments), and no matter how many PST’s and mail rules I have it doesn’t seem to help get the most out of my inbox.
Through playing around this morning I did stumble over another way to help free up some valuable mb of in-box space. If you are like me you probably have a calendar spanning many years with appointments, meetings, attachments etc… that’s always sitting there taking up some space, if you are also like me even though you regularly clean out your in-box you have never cleaned or thought of cleaning your calendar.
Needless to say I don’t need to know that I had a meeting on the 5th of June 2003, nor do I need the 1mb file attached to that meeting.
Thankfully there is an easy way to find and clean out all these old meetings.
On the toolbar click View->Current View-> By category
Outlook calendar
Once you have this view open, you can now sort by create date, due date, event type and delete away as you normally would.(Note:You may want to check with your IT policy regarding this first, some company’s have a policy that you MUST keep certain things for a certain time.)
Anyway I found this help me out, so thought I would share, hope it’s useful for you, don’t forget if you have any tips post up in the comments
This tends to be a fairly common problem, well at least for me anyway. Flash a new rom and chances are this will popup, some users get this straight out of the gates.
Normally when you first go into “Market” it will hang for a while then show up
cannot establish a reliable data connection to the server. This could be a temporary problem or your sim card may not be provisioned for data services. If it continues call customer care
There are quite a few fixes etc… around, I found most of them didn’t do very much, and usually had to resort to “Factory reset”, which is a hard way to fix a little bug.
I have done this multi times on my Notion Ink Adam and found it works pretty well.(sign up for a google account first if you don’t have one on a PC)
1. Open YouTube app(should be pre-installed if it’s not may as well stop reading).
2.Click on the menu key, then select “My Channel”
3. Enter your details to sign in
4. Once signed in, goto settings -> Accounts & Sync
5. Turn “Background Data” on, then sync your google account below(contacts, gmail etc…)
6. Once everything has sync, close settings and open market
7. That’s it your done, if everything works as it does on mine, market should just open straight up.
Hope this helps fix it for you, if you have another way you have found which works, post it up in the comments
Just install win 7 via an upgrade disk? Go to activate only to find the you apparently select the wrong option somewhere in the setup? Don’t really feel like reinstalling windows again?
Well I have and if you are reading this I guess you have as well. Luckily there is a fairly easy fix to this error. Note: This fix is only if you have a legitimate version of windows and just stuffed up your install selection. This fix does use regedit, if you aren’t familar with regedit don’t play with it, as setting a value in regedit could stop windows from working(don’t blame me if you fry you win7 install)
1. Once you have completed the install and had your activation attempt fail.
2. Click on Start -> All Programs -> Accessories -> right click on “Command Prompt” and select “Run as administrator”
3. At the command prompt type “Regedit” and press enter
4. In Reg edit navigate to “HKEY_LOCAL_MACHINE/Software/Microsoft/Windows/CurrentVersion/Setup/OOBE”
5. Edit “MediaBootInstall” and set value to “0″
6. Close Regedit
7. In the command Prompt window(should still be open) type “slmgr /rearm”
8. You should receive a success message asking you to restart
9. Restart, after you restart you should be able to use windows activation link
That’s it, all up should only take a few minutes and should work with win7 x86 and x64.(I have tested it on x64 win7 with no issues)
Anyway all hope this helps
Hey all,
Just something I found that I thought I would share.
Don’t know if anyone else had tried this before apart from myself, but Teradata was previously not able to auto increment an integer like mysql/oracle, or for those Access kiddies auto_number. As of V2R5 though Teradata have included an auto increment function, not something you would normally need to use regularly but can be handy. Syntax is pretty simple, one caveat though, although it is auto increment doesn’t mean sequential increment so you won’t get 1,2,3,4,5,6, you might get 1, 101,1002,1003,1110 etc.. it uses it’s own method but the values are incrementing and unique.
Here is a sample table create
CREATE volatile TABLE autonum_test
,NO BEFORE JOURNAL
,NO AFTER JOURNAL
,NO FALLBACK
(
ID_COL INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 0 MAXVALUE 100000000 NO CYCLE)
,solution_name VARCHAR(100)
,Expected_date_time TIMESTAMP(0)
,Start_date_time TIMESTAMP(0)
,Completion_status VARCHAR(10)
,Completion_date_time TIMESTAMP(0)
)
UNIQUE PRIMARY INDEX ( ID_COL );
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_1′,’2009-01-02 00:00:00′,’2009-01-02 00:00:00′,’complete ‘,’2009-01-02 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_2′,’2009-01-03 00:00:00′,’2009-01-03 00:00:00′,’started ‘,’2009-01-03 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_3′,’2009-01-04 00:00:00′,’2009-01-04 00:00:00′,’ ‘,’2009-01-04 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_4′,’2009-01-05 00:00:00′,’2009-01-05 00:00:00′,’complete ‘,’2009-01-05 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_5′,’2009-01-06 00:00:00′,’2009-01-06 00:00:00′,’started ‘,’2009-01-06 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_6′,’2009-01-07 00:00:00′,’2009-01-07 00:00:00′,’ ‘,’2009-01-07 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_7′,’2009-01-08 00:00:00′,’2009-01-08 00:00:00′,’complete ‘,’2009-01-08 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_8′,’2009-01-09 00:00:00′,’2009-01-09 00:00:00′,’started ‘,’2009-01-09 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_9′,’2009-01-10 00:00:00′,’2009-01-10 00:00:00′,’ ‘,’2009-01-10 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_10′,’2009-01-11 00:00:00′,’2009-01-11 00:00:00′,’complete ‘,’2009-01-11 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_11′,’2009-01-12 00:00:00′,’2009-01-12 00:00:00′,’started ‘,’2009-01-12 00:00:00′;
INSERT INTO autonum_test(solution_name,Expected_date_time,Start_date_time,Completion_status,Completion_date_time) SELECT ‘item_12′,’2009-01-13 00:00:00′,’2009-01-13 00:00:00′,’ ‘,’2009-01-13 00:00:00′;
select * from autonum_test;
If you run the select statement you will see what I mean about how teradata does the increments, as I mentioned not something we would use everyday, and remember there is some overhead on load, I haven’t tested fastload so not sure if supported in fastload, but could come in very handy for tables with poor unique index to avoid skew or as a versioning assist.
Anywho as I said, just something I found that I didn’t know teradata had started supporting so thought I’d share.
Ok this issue shouldn’t be new to any ATI 58xx owner.
If you don’t know or are new to this issue, when you run an ATI 58xx with a non-eyefinity multiple monitor setup playing any flash video and most normal videos will cause screen flickering/tearing.
There have been alot of half fixes (that didn’t work for me even a little) using overclocking to disable memory/core clock change which was the cause of this issue.
But at last there is a light at the end of the tunnel in which your monitor is playing a flickering video 
well at least if you have a gigabyte ga-5870-ud anyway.
After much waiting Gigabyte have release a new bios F8 which specifically fixes video “Display noise” as they term it when playing a movie. I’am happy to say it works, youtube fine, media player fine, avi’s fine. FInally it works, the 5870 is now perfect.
Got a gigabye 5870 and want to fix it? You need to things
Firstly the bios
http://www.gigabyte.com/products/product-page.aspx?pid=3355#bios
Secondly a program to install it
First link “VGA tools @ bios”
http://www.gigabyte.com/support-downloads/Utility.aspx?cg=3
Remember you do this at your own risk, bios flashing of any PC component can cause your $500 awesome hunk of copper and silicon to just become a hunk of copper and silicon.
Anyway hope this help some other 58xx owner out there
later
Hey all,
Not the normal sort of thing I would post up but considering how much trouble I had finding any information(complete info not just 2 word comments) on this thought I would post up my experience with my shiny new Gigabyte 5870 and tri-screen setup.
Ok most of you would have heard about ATI’s new 58xx series cards and their shiny new party trick “Eyefinity”, when I first read the pre-release info on these I was stoked, I have been running a tri-screen rig for years, and it has never been what you call fun to find compatable hardware to be able to do it. Up till now I have had to use multiple video cards to obtains tri-screen, my latest config was a GTX275 powering a 27″ Acer @ 2148*1152 with a 8400gs powering dual 20″ Viewsonics @ 1400*1050(previous to this had 2* 8800gt oc sli’d and a 8600gt that was fun to setup). Now this rig worked pretty well, but obviously the idea of having a single card running all 3 monitors for the first time was awesome.
Being my normal self I wait for actual release only to hear some disturbing information…….. needed displayport to run tri-screen 
3 monitors not one a displayport, ok then fair enough how much is a displayport monitor (or 2)…. oh that much…. really….your sure….F&&^ you then…. ok so after deciding getting a 58xxx and some new display port monitor was outside my budget let see how else we can get this to work….. This was not a fun research, there are bit and pieces of information on forums, some half arse not clear stuff in AMD help area that all seem to hint at one thing or another, from what I could read you could get away with effinity but only with an active adaptor but couldn’t find anything about using different monitors etc…
After umming and ahhhing around for awhile about if it was worth while to spend $500 on a punt, I finally broke last week and purchased a Gigabyte 5870. To start with I didn’t bother to purchase any adaptors etc… as I didn’t feel like throwing more money away without testing to see if the card was even worth it yet. After getting the card on monday though quickly discovered theHey all,
Not the normal sort of thing I would post up but considering how much trouble I had finding any information(complete info not just 2 word comments) on this thought I would post up my experience with my shiny new Gigabyte 5870 and tri-screen setup.
Ok most of you would have heard about ATI’s new 58xx series cards and their shiny new party trick “Eyefinity”, when I first read the pre-release info on these I was stoked, I have been running a tri-screen rig for years, and it has never been what you call fun to find compatable hardware to be able to do it. Up till now I have had to use multiple video cards to obtains tri-screen, my latest config was a GTX275 powering a 27″ Acer @ 2148*1152 with a 8400gs powering dual 20″ Viewsonics @ 1400*1050(previous to this had 2* 8800gt oc sli’d and a 8600gt that was fun to setup). Now this rig worked pretty well, but obviously the idea of having a single card running all 3 monitors for the first time was awesome.
Being my normal self I wait for actual release only to hear some disturbing information…….. needed displayport to run tri-screen 3 monitors not one a displayport, ok then fair enough how much is a displayport monitor (or 2)…. oh that much…. really….your sure….F&&^ you then…. ok so after deciding getting a 58xxx and some new display port monitor was outside my budget let see how else we can get this to work….. This was not a fun research, there are bit and pieces of information on forums, some half arse not clear stuff in AMD help area that all seem to hint at one thing or another, from what I could read you could get away with effinity but only with an active adaptor but couldn’t find anything about using different monitors etc…
After umming and ahhhing around for awhile about if it was worth while to spend $500 on a punt, I finally broke last week and purchased a Gigabyte 5870. To start with I didn’t bother to purchase any adaptors etc… as I didn’t feel like throwing more money away without testing to see if the card was even worth it yet. After getting the card on monday though quickly discovered that the 5870 was definately worth it, the 5870 had a nice jump in FPS over the gtx275, so first hurdle down.
Budget being my first hurdle I decided, before spending a few hundred on an Active Displayport->DVI adaptor that I would try using a passive displayport->vga adaptor, there where a few comments stating this would work, but I couldn’t find much information on how screen resolution would be affected by using VGA.
I found HP DISPLAYPORT TO VGA ADAPTER on megabuy(http://www.megabuy.com.au/hp-displayport-to-vga-adapter-p137004.html) for $22 which was the cheapest in australia i could find and decided to give it ago.
As I couldn’t find much reliable info on this setup, when I recieved the adaptor I just to decided to plonk in on and see how I went. For my rig I decided to connect the 27″ and 1 of the 20″ via DVI. The other 20″ monitor I connected using the dp->vga adaptor. That’s is, that’s all it took and wam working tri-screen(note tri-screen does not mean eyefinity), both dual 20″ running @ 1400*1050, 27″ running @ 2148*1152 all same gama, same colour, same brightness. All I need to do was to arrange the monitors in Control Centre(left monitor on left, right monitor on right etc..) and working great. Before moving onto eyefinity ran a few gaming tests to see how it went.
Single Display Results
Team Fortress 2 @ 2148*1152, all high/very high – Max – 252fps, Avg – 124fps
Trackmania Nations Forever @ 2148*1152, High/very high – Max – 120fps, Avg 95fps
COD6(mw2) @ 2148*1152, Everything Max. – Max 270fps, Avg 176fps
Just Cause 2 @ 214881152. – max 140fps, avg 95fps
Ok everything is running awesome, let’s tempt fate…..eyefinity time.
Ok first config to see if it works, changed all monitors to the same resolution 1400*1050(yeah i know 4:3 res but my 20″ are 4:3 monitors), went into catalyst and created a new group using all 3 monitors, resolution 4200px*1050px….. DONE! working perfectly well maybe not perfectly because I have two “4:3″ monitors and one “16:9″ monitor the image is looking somewhat stretched but eyefinity is working perfect not only without a native displayport monitor or even a active displayport adaptor, just using a cheap displayport->vga adaptor.
Eyefinity Results
all games @ 4200px*1050px, all setting same as single monitor test
Team Fortress 2 – Max 170fps, avg 98fps
Trackmania – Max 109fps, Avg – 71fps
COD6 – worked but massive stretching made unplayable. Couldn’t run fair comparison.
Just Cause 2 – Failed center monitor would not display image.
For my rig at the moment although eyefinity is a possible it’s not worth while, due to the stretching caused by having to run a 4:3 resolution on a 16:9 image are way to skewed to be used ingame, in so saying though if you had different size monitor that where at least the same ratio I don’t think monitor size would be too much of any issue.
Anyway hope this may help out some people stuck with the same scenario as me.
Trackmania running @ 4200*1050
Just a quick list of lesser known keyboard shortcuts. If you aren’t used to using keyboard shortcuts give them a go, makes navigating around windows and working on files alot quicker.These shortcuts should work on all versions of windows from 95 onwards.
| Shortcut Key(s) | Action |
| General Shortcuts | |
| Ctrl+Z | Undo |
| Ctrl+Y | Redo |
| F2 | Rename |
| Shift+Delete | Delete without sending to recycle bin |
| Ctrl+Shift+Arrow Key | Highlight a section of test. |
| Ctrl+Home | Goto Top of page |
| Ctrl+End | Goto bottom of page |
| Ctrl+A | Select everything |
| Ctrl+Shift+Esc | Open Task Manager |
| F5 | Refresh Active Window (refresh web page also) |
| Windows Explorer | |
| Ctrl+N | New Window |
| Ctrl+W | Close current window |
| Ctrl+Shift+N | Create New folder |
| F11 | Maximise current window |
| Left Arrow key | collapse current folder |
| Right Arrow Key | expand current folder |
| Windows Key shortcuts | |
| WinLogoKey + E | Open Computer |
| WinLogoKey + M | Minimise all windows |
| WinLogoKey + D | Display desktop |
| WinLogoKey + F | Search for file or folder |
| WinLogoKey + L | Lock your computer or switch users |
| WinLogoKey + R | Open Run dialog box |
| WinLogoKey + Left Arrow Key | Maximise window to left half of screen |
| WinLogoKey + Right Arrow Key | Maximise window to right half of screen |
| Web Browser Shortcuts (should work in all browsers) | |
| Alt + Left Arrow | Go back |
| Alt + Right Arrow | Go Forward |
| F5 | Soft Refresh page |
| Shift+F5 | Hard Refresh page (doesn’t use cache) |
| F11 | Full Screen Mode |
| Ctrl+F | Find |
| F3 | Find again |
| Ctrl+B | Open/Close bookmarks/Favourites |
| Ctrl+N | New window |
| Ctrl+T | New Tab |
| Ctrl+Mouse wheel | Zoom in/Zoom out |
| Ctrl+0 | no zoom(return to default) |
| Ctrl+U | View Page Source |
I haven’t included the everyday one such as cut & paste etc…, this is more a list of handy everyday shortcuts that most wouldn’t know exist. Have a go, some you may find handy some not. If you have some other that you use and find handy not listed, post it up in the comments as someone else might also find it handy.
It’s fairly easy.
Start windows live messenger
Click on the status drop down(busy, away etc..) and select options
Click on General then untick “Automatically run windows live messenger when I log on to windows”
Click Accept.
Done.
Some people have reported issues with this method though,