OT: Technology and Geek Stuff Thread

[nhwbrooklyn]

Coop is right.

DL walwarebytes here.

It's free.

Make sure you update it before running the scan.

[ame="http://download.cnet.com/Malwarebytes-Anti-Malware/3000-8022_4-10804572.html"]http://download.cnet.com/Malwarebytes-Anti-Malware/3000-8022_4-10804572.html[/ame]

[Newbomb Turk]

a paper phone ?

http://www.dailymail.co.uk/sciencetech/article-1383903/PaperPhone-The-smartphone-paper-shape-pocket.html

[Panoptes]

Coop is right.

DL w Malwarebytes here.

It's free.

Make sure you update it before running the scan.

http://download.cnet.com/Malwarebyte...-10804572.html

FIFY

[froot loops]

I had to use that the other day. I have no clue where this malware came from but it deleted my desktop, took away the wallpaper, made every program file hidden and read only. It also ran a program in the background that took all the memory and kept on crashing the computer. Malwarebytes cleaned it up. The only lasting damge seems to be that it permanently removed icons in the program folder on the start bar.

[Coop]

one tip - you can further protect against viruses and Malware if your user account doesn't have admin rights.

[Cody_Russell]

Saw this for the 1st time while watching the OKC vs Dallas basketball game. CAN't WAIT!
[ame="http://www.youtube.com/watch?v=C_7_dYWMsL0"]YouTube - Call of Duty: Modern Warfare 3 - America Teaser[/ame]

[DanO]

I'm sure my son will be asking me for that.

GO LIONS "11" !

[Marko69]

I wish my 17 year old sons friend Jamie would get good at Call of Duty. Every time it's on, I hear, "Jamie, Jamie, watch yer back Jamie, aw for Gods sake Jamie,....., right Jamie, move, 5 kill streak, don't ruin it, go Jamie...., Aw for Gods Sake Jamie."
Sometimes I feel like grabbing the headset off his head and shouting, "Jamie, FFS pal, start practicing."

[Kansas]

I need some SQL help. Basically I have a cron that runs every 5 minutes. No matter when it runs, I want to query records that were inserted going back to the top of the hour. So it would be something like:

select * from table where InsertTime >= 'yyyy-mm-dd hh:00:00'

Where yyyy-mm-dd is the current date and hh is the current hour. How the hell do I do that o wise ones? THANKS!

[Malto Marko]

Man, you are getting wayyyyyy too into the hard porn updates.

[Kansas]

Holy crap, I think I just figured it out unless there's an easier way.

select dateadd(second, -60 * datepart(mi, getdate()) - datepart(second, getdate()), getdate())

[Darl McrBride]

If that works it works. You could also try (untested, of course):

dateadd(hh,0, datediff(hh,0,getdate()))

[LionsFanInJapan]

This looks cool, but I'm sure it'll be crazy expensive at first:

http://www.pcmag.com/article2/0,2817,2387554,00.asp

[Panoptes]

Yeah, read about the LYTRO tech a couple of days ago.

I am highly interested in it.

[Malto Marko]

Si!