Today I learned that in Exchange 2007 you cannot (by default) set a user to send email as a user who is in the Domain Administrators group. You have to apply a workaround or remove that user from the group.

http://support.microsoft.com/kb/907434/en-us

4/11/2011 4:32:17 PM

switching to draft view makes adding and removing section breaks a lot easier in word

4/11/2011 7:54:29 PM

I learned geo-distance searching using the Haversine formula

http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL

Helped me to find the closest locations by exact distance with SQL since we already store latitude and longitude.

4/15/2011 2:37:39 PM

On a BSD based distro,

/dev/rdisk is better to use for cloning a drive than /dev/disk .

“r” is for “raw"

[Edited on April 23, 2011 at 4:11 PM. Reason : ]

4/23/2011 4:11:03 PM

or 'wanting to learn'

does anyone know of any certifications or more formal training that exists for mobile development? With smartphones getting more prolific in the workplace (and tablets), I was just wandering if such things were coming out yet....

4/24/2011 12:33:35 PM

AFAIK there's no certifications specific to mobile development



but a smart thing to do would be to learn the JS libraries/frameworks out there available such as Sencha Touch and jQuery Mobile

4/24/2011 12:48:04 PM

pressing F4 in excel while having a cell selected can toggle A1 to $A1 to $A$1 and so on.. also double clicking the drag down handle can fill a whole column for you if the column next to it is filled.. so you don't have to drag down the handle like a 100 rows

4/24/2011 12:50:22 PM

^SHUDDUP. I approve this f4 thing. That can be useful

4/24/2011 12:53:57 PM

psr.exe

6/13/2011 8:10:59 AM

^^^ ctrl+shift+arrow also will select all cells that are filled.

For example if you're in A1 and hit ctrl+shift+down it will select all the cells in that column that are filled. If you get to a blank cell just hit the down arrow again to jump to the next filled cell and keep going.

[Edited on June 13, 2011 at 5:14 PM. Reason : ^]

6/13/2011 5:13:51 PM

The last DC power grid was only shut down in 2007


[Edited on June 21, 2011 at 12:20 PM. Reason : .]

6/21/2011 12:18:53 PM

^ since only the last bit deals with that, i googled it and found this:
http://cityroom.blogs.nytimes.com/2007/11/14/off-goes-the-power-current-started-by-thomas-edison/

6/21/2011 12:25:59 PM

you could have clicked on the link below the embed and got the same thing.

6/21/2011 2:02:38 PM

rbrthwrd is a perfect illustration of this thread: /message_topic.aspx?topic=376822

6/21/2011 7:49:54 PM

the link wasn't there when i watched the video and googled

6/21/2011 8:00:23 PM

Yesterday I learned enabling kiosk mode in IE pisses everyone off. I like it.

6/22/2011 10:49:15 AM

Today I learned about Untangle.

http://www.untangle.com/

I've heard that it's slow as balls and not meant for medium-large user bases (600+) But I'm going to test it out since configuring Squid has completely beaten my ass raw.

6/22/2011 1:26:24 PM

Today, I learned that SQL Server 2005 doesn't allow remote connections by default.

1/11/2012 9:34:59 AM

no idea phil katz died of alcoholism

2/2/2012 10:40:52 PM

^^dang that untangle would be rough for a small business (for us anyway.) A $1200 Cisco appliance for our ~20 computers is about a year of Untangle. It does look awesome though

2/2/2012 11:57:07 PM

I use http://www.pfsense.com

2/3/2012 8:00:38 AM

Quote :

"Today, I learned that SQL Server 2005 doesn't allow remote connections by default."

god, I would hope no database server would allow remote connections by default


a couple of days ago I learned that postgresql-server doesn't allow local connections by default

2/4/2012 5:41:30 PM

SQL Server 2008 doesn't allow SQL authentication, local or otherwise, by default.

That was a fun day of troubleshooting.

2/4/2012 6:28:43 PM

Yeah, servers allowing remote connections sure sounds like a bad idea.

2/5/2012 12:05:23 AM

When I first started using SQL server, I didn't have admin rights to enable remote connections and whenever I wanted to work remotely, I had to set up a ssh tunnel, which took me weeks to figure out how to do it in a way that SSMS would actually let me connect (you had to connect to 127.0.0.1,2433. localhost didn't work and you had to specify the port with a comma instead of a colon) I felt so once I got it all working

2/5/2012 9:50:15 AM

You're so l33t, it hurts.

2/5/2012 3:08:48 PM

well, i just learned i don't understand clustered sql indexes anywhere close to as well as i thought i did, which wasn't all that much to begin with.

2/7/2012 1:46:01 AM

What is there to understand? I thought a clustered index just stored the records sorted on disk. Is there something else going on?

2/7/2012 9:54:23 PM

Quote :

"clustered index just stored the records sorted on disk"

that was the extent of my understanding, but what i didn't understand is that because it's very important to avoid fragmentation with clustered indexes, it leads to more stringent criteria on when to make a clustered index on a non-primary key column. for more details...

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Ever-increasing-clustering-key-the-Clustered-Index-Debateagain!.aspx
http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-Continues.aspx


what i learned today - you can show hidden devices in Windows Device Manager. which is helpful when you transfer a hard drive from one laptop to another and want to get rid of unused driver files.

2/10/2012 12:19:51 AM

The military provides a super-secure Linux distribution for Web browsing: http://www.spi.dod.mil/lipose.htm

2/10/2012 12:30:06 AM

This may be incorrect reason why, and if so, please correct me.

I've noticed in a lot of programs (ie: games, videos) I get better framerates if the program is fullscreen rather than in window mode. I would have never guessed this. I suppose it has something to do with windows having to refresh the content of every other window and background in addition to the program being utilized, where-as in fullscreen mode everything else is disabled and only the program is refreshed.

2/12/2012 5:35:06 AM

Pretty much how I understood it to work. There's extra shit to do, even though you may be running a lower resolution in windowed mode.

2/12/2012 12:31:48 PM

TIL that Adobe doesn't rush out a security and stability update for every single bug out there, even bugs that seriously inconvenience a large portion of the userbase, like the inability to print PDFs while connected to shared printers on Windows; instead sometimes little hotfixes are issued and it's not obvious to figure out where or even whether to get them because the auto-updater never mentions them: http://kb2.adobe.com/cps/928/cpsid_92870.html

3/9/2012 8:38:02 PM

the correct term for a hard drive to resync during a rebuild of a RAID is called resilvering. Did not know this. Now I do.

3/10/2012 4:12:04 AM

I've been doing this for a while now, but thought I'd share.

1. Pull up youtube video.
2. type "endless" in front of youtube in the url (ie: http://www.endlessyoutube.com/watch?v=oHg5SJYRHA0 )

3. Loop your video/song
4. ...
5. Profit!

3/13/2012 6:48:22 AM

Oh nice that might save me from having to alt tab all the time while playing a game or something.

3/13/2012 8:51:26 AM

TIL that you should never call Enum.Parse or any of its derivatives in performance critical code.

6/12/2012 8:36:10 PM

In Zen Cart, it is impossible to reliably call the global object $db from function scope; this is probably a good thing.

6/13/2012 2:13:36 AM

TIL you can install a driver for an ATI 2400 XT graphic accelerator on a machine with a 2400 PRO and it will run perfectly for years until the user tries to run a certain Excel add-in. Then it will mysteriously BSOD repeatedly and make you look like a fool for chasing your own tail reinstalling software because that was the only thing that was changed in the last week. Argh!

6/13/2012 2:31:09 PM

That seems like a very odd confluence of programs . . .

6/13/2012 4:05:30 PM

TIL that you get a Low ID on the ed2k network if your IP address ends in 0: http://forum.emule-project.net/index.php?showtopic=85127

I also learned that ScarAngel is superior to the stock eMule: http://sourceforge.net/projects/scarangel/

6/30/2012 6:11:14 PM

people still use eDonkey?

7/1/2012 4:33:04 PM

I've never used ye olde eDonkey2000

just eMule

and more recently the ScarAngel mod

it's great for finding mathematical eBooks, especially in DJVU format

7/2/2012 4:23:55 AM

TIL that there is a difference between in the following MySQL queries:

SELECT DISTINCT type, count(name) ...

and

SELECT type, count (DISTINCT name) ...

I guess I have never run into a situation where it mattered before.

7/3/2012 3:16:11 PM

not trying to be a d-bag, but that is a pretty big difference there

7/5/2012 1:25:56 PM

usually when I need to do counts, i'm doing ids (something that is unique). Yesterday I was trying to count types of users. It's never come up.

d-bag

7/5/2012 4:41:00 PM

you can ctrl/shift+select chrome tabs to drag multiple tabs to a new window

[Edited on July 10, 2012 at 8:50 PM. Reason : how many times could i have used that]

7/10/2012 8:49:36 PM

TIL you can compress a bunch of excel files into a .pdf collection

The person who receives this file will then be prompted to install adobe version 9 or higher, unless they have the full version of acrobat 9 installed, in which case it will prompt them to install flash player (also already installed)

The one thing it will not give them is a way to access those files.

And before anyone asks, I don't know why anyone chose to do this instead of putting them in a .zip folder.

7/12/2012 4:19:04 PM

you can prettify minified js directly in chrome dev tools

7/13/2012 10:22:05 AM

Today I learned that if you have a home security system connected in your house and have DSL, even if the system isn't active it can cut your internet speed in half. My parents have been getting shitty internet speed since they got DSL, turns out the non-functional security system was causing it. Disconnected that and it's where it should be.

7/13/2012 1:41:35 PM