2009
10.21

If you happen to encounter this issue (in my case it’s Windows 7) while unit-testing a program with a third-party DLL (like something from CodeProject), just right click on the “offending” DLL, then under “General” tab, there is a Security option in the bottom that reads “This file came from another computer and might be blocked…”. Just click on the “Unblock” button and the problem will go away.

2009
10.05

Dropbox

To me, thumbdrives have become obsolete since the advent of one of the greatest software that’s been created in recent history: Dropbox. It’s true that what they’re offering isn’t exactly new; a lot of companies already offer “cloud storage” before Dropbox was even conceptualized. But Dropbox does it lightyears better; they have super-fast and elegant integration with Windows and Mac and recently they introduced an iPhone application as well.

One feature of Dropbox that is not found in most cloud storage solutions is the built-in “version control” system; you can revert to an older version of a file stored in Dropbox in an event it gets corrupted. I have used this extensively since I started saving my mRemote config file on Dropbox. If you’ve been a long-time user of this venerable application (the last version before they merged with VisionApp), you know that from time to time, mRemote “forgets” your configuration, and if you have about 20+ connections saved on the config file, finding out one day that it’s all been deleted could be nerve-wrecking. So with Dropbox’s version control, I can just revert to an older version of my mRemote config file if I launch mRemote without my existing connections.

Speaking of cloud storage. I am keeping an eye of this “P2P cloud storage” code-named “Tahoe.” I think it’s interesting in the sense that it could potentially compete/replace BitTorrent.

2009
09.03

I’ve been having this issue for quite a while now, and i just solved it recently.

Basically, I have database A with service broker queues, and hosts an activation sproc. The sproc in A dynamically creates an insert TSQL and runs it on Database B.

Both databases are owned by the same username, which has super-user db privileges. A.sproc fails inserting records to B with the error. I tried a lot of magic and several flavors of EXECUTE AS statement to no avail. Upon seeing this KB article, it turns out that all i need to do is:

ALTER DATABASE A SET TRUSTWORTHY ON

And Voila! problem gone.

Very annoying to say the least…but it kind of makes sense. I just wished that the error messages (just like all Microsoft error messages for that matter) could be less cryptic.

2009
08.16

Boycott Digsby

I wrote about Digsby’s recent trainwreck here. If you’re still using this app as your IM client, maybe it’s time to switch.

2009
08.11

Pet Peeve #2879

One thing that’s starting to irk me lately is people who sign off with the initial letter of their first name. e.g., if the guy’s name is John, he signs off as:

j

WOW. how self-centered. You think your name is the only one starts with “J”? and you want me to automatically acknowledge that if i see an email with that sign off, that it’s you?

NO.

Sign with your nickname, your mom’s name…or…you know what? i’m easy to please: I’d settle for a first syllable. Please don’t be a prick.

2009
08.03

If for some reason you need to reference the Powershell assemblies in your .NET projects, the DLLs can be found here:

C:\Program Files\Reference Assemblies\Microsoft\WindowsPowerShell\v1.0

You’re welcome.

2009
07.30

Log Parser

I dare you come up with a more complicated Log Parser query. I DARE YA! :-)
select
EXTRACT_TOKEN(text, 3, '::') as UserID,
EXTRACT_TOKEN(EXTRACT_TOKEN(text, 0, '><'), 2, '|') as RequestDate,
ClientVersion,
CASE ClientVersion
when NULL then 0
else 1
END as UsesFeedManager,
EXTRACT_VALUE(RequestUrlParam,'idList') as IDList,
EXTRACT_VALUE(RequestUrlParam,'idListType') as IDListType,
RequestUrl,
RequestUrlParam
using
EXTRACT_TOKEN(text, 5, '::') as RequestUrl,
EXTRACT_TOKEN(RequestUrl, 1, '?') as RequestUrlParam,
CASE RequestUrlParam
when NULL then '1.6'
else EXTRACT_VALUE(RequestUrlParam,'clientVersion')
END as ClientVersion
from
'%logfile%'
where
text like '%DoneRequest::%' and
STRLEN(UserID) > 0 and
UserId not like '%AP.Distro.Feed%'
order by
UserID, RequestDate desc

What does it do? Hell if I know.

2009
07.23

A Sad Day

Today, the world has lost another icon: the Taco Bell dog died.

2009
07.18

As you notice, the site is looking a bit better…thanks to the WP Automatic Upgrade plugin, WP upgrade has been seamless.

2009
07.18

I’ve had this problem for a long while now and ignored it until recently, when the problem didn’t go away upon upgrading to the latest WordPress.  After googling and reading this thread, I’ve found that I wasn’t alone, and a solution is at hand (read the post by “Today”).

It’s quite unnerving though that some hax0r got into my site and was able to mess with it.