BASH Friday!!!!!!!

http://www.bash.org/?806380
http://www.bash.org/?806849
http://www.bash.org/?806855
http://www.bash.org/?808311
http://www.bash.org/?808383
http://www.bash.org/?808682
http://www.bash.org/?809027
http://www.bash.org/?809181
http://www.bash.org/?809302
http://www.bash.org/?12500
http://www.bash.org/?7194
http://www.bash.org/?9670
http://www.bash.org/?17334
http://www.bash.org/?51313
http://www.bash.org/?56258
http://www.bash.org/?71442
http://www.bash.org/?73081
http://www.bash.org/?146822
http://www.bash.org/?221090
http://www.bash.org/?454094
http://www.bash.org/?458436
http://www.bash.org/?485105

UPDATE: Blast from the past

SQL Server 2005 sucks so far.

I finally had to take the plunge into SQL Server 2005 since HostMySite only offers 2005 and not 2000 on their VPS plans. Needless to say I’ve heard nothing good about 2005. I’ve talked to countless DBAs telling me that it’s dog slow and EXTREMELY clunky to use. Well I’ve come to the conclusion that they are right.

Mind you I’m just now getting into it, but already I found 2 gotcha.

First off the Script Generator sucks. The interface is so horrible, I feel like I’m programming in Visual Basic with the way you have to choose your options. Not to mention that thing is SLOOOOOOW. It took 3 times as long to generate scripts for my database as Enterprise Manager did. The big kick in the nuts is that it doesn’t write the script correctly! The old 2000 script generator would write the scripts for the tables first and then the scripts for all your views next. Not 2005′s, it intermingled the tables and views scripts so if a view has a table in it that hasn’t been created yet… it FAILS!!! Is that fucking stupid or what!?! The only way around this is to generate and run the scripts for your tables first and then generate and run the scripts for your views. Great, so not only do I have to wait longer, I have to do double the work as well. Thanks Bill!

Second thing I found was another speed issue. I don’t know how many of you have ever used the import / export wizard in Enterprise Manager; I use to use it all the time and it was a life saver. Well needless to say now in 2005 the import / export process takes a loooooooooooooong time…… I’m talking long like the Nile, like line at Domino’s in a fat camp, long like John Holmes! I couldn’t believe something that use to take 30 seconds before took 10 minutes. Thank God I only have to do that once in a while.

My other gripe is the Management Studio in general. Why Microsoft now feels that everything should look like Visual Studio is beyond me. Enterprise Manager (though ugly as hell) was very clean and uncluttered, compare to Management Studio which looks really slick but a total mess when it come to finding things.

I guess I just need sometime to figure everything out. I’m sure I’ll find other quirky things along the way in my journey and if I do I’ll post them.

UPDATE: I was about to rip Angus (see comments below) a new one when it kinda dawned on me that I never checked what service level SQL Server 2005 was on. I guess I just assumed that it would be at the latest level since it’s a VPS and HostMySite applies the upgrades to the VPS. Well let me fall on my sword by saying that I checked late last night and I was wrong. SQL Server was at SP1 not SP2. I tried installing SP2 and it wouldn’t let me, so now I have a ticket opened with HostMySite to see if I can get it updated to SP2. I’ll post something about my new experience with SQL Server 2005 once SP2 is installed.

ColdFusion Verity: Can’t find a specific document based on title or filename? Setup the metadata!

UPDATE: Thanks to Ben Nadel for pointing out the metadata project at RIAForge. Steve, this should help you in your quest.

I just had a problem where a user was searching our document library for our official letterhead document and the document wasn’t coming up. Basically all they were doing is entering “letterhead” into the search.

My first thought was that maybe the document didn’t get index by Verity, so I re-ran the scheduletask that performs the index, which ran without a hitch. I tried doing the search again and nothing.

Now I forget to mention that I’m using “natural” as the type of search, so I tried to add “url<contains>#keywords#” to do the search. This basically tells Verity to look at the url field in the index (which is the filepath) for the keyword. Again nothing; now anger sets in since it should of worked.

I do another search and decide to dump the query that is being returned to see if something comes to light and it did! I noticed that the titles that verity is giving the documents is coming from the document metadata. Since this particular file was a Word document, it was pretty easy to set the title to whatever I needed it to be to get Verity to pick up on the keyword. I set the title in the metadata to “BSO LetterHead” and performed the search again and bingo, the doucument was found.

So how did I do it? Well in *most* programs when you create a document you can alter the metadata by doing this (I’m going to use word as the example here since most people have it on their machines):

Open up the document and click FILE -> PROPERTIES and then click the SUMMARY tab. You should have a pop-up window that look like the one below.

From here you can set the metadata to whatever you want for the document. Not only is setting the metadata for a document great for Verity, but it’s also helpful for other indexing programs like Spotlight on the MAC, Search within Windows and even the Google Desktop search!

So in closing, if you’re having a hard time trying to get Verity (or any other index and search program for that matter) to pick up a document when performing a search, take the time to setup the metadata within the document itself.

My tips for keeping weight off.

Bottom line, I was a fat bastard. At one point about 5 years ago, I weighed in at a staggering 210 lbs! Now I know that some will say that that isn’t heavy, but when you’re only 5″3′, yeah… it shows

You’ve all heard me say that I lost all the weight doing yoga on numerous blog posts, but the fact that I’ve kept the weight off for the last 5 years is a very big accomplishment for me. Really the only thing I need to do is to get my yoga body back and I’ll be set.

So the real question is, how the hell have I not put back on the 60 lbs I lost over the last 5 years? Well, here are my tips to losing weight and keeping it off. They aren’t ground breaking or anything like that and I’m sure you’re heard them before, but here they are none the less.

1) Eat smaller meals.

There was a time when I would eat 6 slices of pizza in a sitting. Today I can hardly put down 2 without yooking. Basically what I did was shrink my stomach. The easy way to do this to eat smaller portions and eat them often, at first, so you don’t feel the urge to over eat. A great way to do this is to cut your meals in half. Instead of two scoops of mashed potatoes, eat one. Instead of 4 slices of pizza eat two. The biggest hurdle that most people have though is when they go out to eat. They feel that they need to eat everything on there plate. Hey, I know this feeling, I still have it. But there is a way to satisfy that mental block and still eat less. The trick is to get a to-go container at the beginning of your meal or when your meal comes to the table. Just take half of your meal and place it in the to-go container. Then put the container in the bag and place it under the table, out of sight, out of mind. Best part is, you have lunch for the next day!

2) Eat slowly.

A chef friend of mine once told me, “Dude, enjoy your food.” Why we all feel that we need to wolf down our meals is beyond me, but 75% of the population doesn’t it. A great way to slow down your eating to strike up a conversation; be social with the other people at the table. During the conversation, make sure you’re not talking with food in your mouth and put down your fork and knife. Give yourself these little breaks to allow the food that you’ve been ingesting time to digest. Because you’re doing this, you’ll feel fuller faster and on less food!

3) Drink while eating

Ever get full from just drinking water or soda? I’m sure you have. Basically by putting liquids into your body during your meal, you’ll eat less since the liquids and the food will fill you stomach faster. Also make sure that the liquid you’re drinking is either water, or diet something. There’s no sense in replacing the food calories with calories from soda or alcohol. I usually have my famous drink: cranberry and club soda. A very refreshing and low calorie drink. And on that point:

4) Cut out the non-diet soda and alcohol

Learn to like water. Why in the world would you want to drink a coke that has almost 200 calories in a single 16 oz can, when 16 ounces of water has no calories. If you really are a soda drinker, drink the diet stuff so you can still enjoy the soda but eliminate the calories. I know that a lot of people hate the taste of diet soda, so luckily today there are other substitutes for your favorites drink: coke has coke zero you know. Cranberry and club soda (or any fruit juice with club soda) is a great substitute for an alcoholic beverage. Not only doesn’t taste great, but everyone at the party will think your drinking a mixed drink like vodka and cranberry!

Now this doesn’t mean I’m one of those people who doesn’t drink (LORD knows I can put them down when I want), but I’m not the kind of person that drinks everyday. Usually I drink about 4 times month, if that. Yeah I like to have a couple of cocktails when I go out, it just means I don’t come home from work and start hitting the sauce. Also, one last thing about the cranberry and club soda: it’s an excellent way to get sober or prevent yourself from getting drunk. Just have one cranberry and club soda for every drink you have and it will prevent you from getting dehydrated. Not to mention that the cranberry juice make you piss like a race horse, so the alcohol doesn’t linger in your body.

5) Avoid the dairy

Nothing has more fat per serving then diary products. I’m not talking about yogurt and cottage cheese, I’m talking regular cheese, sour cream, creams and what not. Sure a lot of them have the non-fat and low fat version, but less face it, they taste like shit. So why even bother to eat something that will taste like shit, just avoid it all together. Trust me on this, your heart will thank you.

6) Put your napkin on you plate when you feel you’ve had enough.

This sound dumb as hell, but works for me. I don’t know how people can take a rolled up napkin and put it on there plate and continue to eat off it; it grosses me out. Whenever I feel slightly full, I throw my napkin over my plate. The thinking is, I’m not going to pick my napkin up and start eating again, no way in hell. By doing this, I basically stop eating all together and it tells my mind that I’m done eating.

Like I said, they’re not the latest breaking secrets in the world of trying to eat less and I’m sure you’ve heard them before. But how many of you actually do any of the things mentioned above. I could bet not many.

WTF this has been a sh*t week.

I think someone put a curse on me.

Here is what has transpired over the last 5 days:

Monday: It’s my 2nd year anniversary. I take the day off to be with my wife and have a fun filled day of just being with her and doing couples stuff (if you know what I mean). That all goes to hell as termites start to invade my condo again, in my kitchen all places that I spent $30,000 dollars remodeling. Needless to say all anniversary plans for the day were off as I flipped out and tried to make appointments to get the the termite guys out there sometime this week. I finally am able to get an appointment with Terminix for Thursday for them to come out and treat the place.

Thursday: Termites guys are coming out around noon. I wake at 8:00 am since I’m suppose to meet the maintainence guy so he can take off the roof vents around the outside of my unit so the termite guys can spray in that area. Needless to say the bastard never shows, so around 9:30 am I have no choice but to do it myself. I spend the next hour and a half taking these friggin things off while trying not to damage any portion of the over-hang. After taking the vents off I have to race to home depot to get replacement vents since I had no choice but to damage them as they were so old I couldn’t get them off without doing so.

Termite guys come over and start spraying the place. During the course of the treatment, they manage to spray the spice plants my wife has been diligently growing for the past month. Of course this means that I now have to throw them out and beyond that, you know my wife is going to be pissed. Also in the mist of all that is going on, I get sprayed in the face (not good and which was my own fault) with the termite chemical and race to the sink to wash the crap off.

Once Terminix leaves, I spend the next 2 hours trying to get the replacement vents to fit into the existing holes; which I had to bang and “sculpt” into place. All things considered, I think I did a pretty decent job.

After taking a shower and cleaning up, I go to check all the email I’ve missed during the day and Comcast has decided to go down and remain down until 8:00 pm.

At 9:30 pm, wife comes home. I spend a couple of hours with her and then decide to turn. Lucky me… tonight is one of her more active nights where she talks in her sleep and decides to use me as a punching and kicking bag. I finally get to bed around 5 am this morning when she wears herself out.

Friday: I’m not feeling at all good. My stomach is killing me and I can only think it was from the chemical being sprayed in my face yesterday. Along with a stomach ache comes other things that I won’t mention. To try to calm down my stomach, I have a pumpernickel bagel. While eating the bagel, I bite down on a rye seed (how that got in there is anyone’s guess) and crack my back molar.

So now I have a dentist appointment at 3:00 pm to get my tooth repaired. If you don’t hear from me in a couple of days, it’s because I got into a car accident on the way to the dentist and died. With the way this week is going, I wouldn’t put it pass the forces of nature.

UPDATE: We’ll I lived. So as I’m driving to the dentist, I-95 is all the way backed up to Ft.Lauderdale and I have to go to Boca Raton. Seems that a fucking plane crashed landed on I-95 south bound and the north bound onlooker traffic was backed up to FT. Lauderdale. Can you believe that?!?!? A fucking plane.

As a result, I was 45 minutes late for my appointment, so I have to go back on Monday to get the work done.

That’s it, I’m getting going out and getting drunk. See ya all Monday!

BASH Friday!!!!!

Resident Evil bitches!!!!!

http://www.bash.org/?803904
http://www.bash.org/?803854
http://www.bash.org/?803851
http://www.bash.org/?803577
http://www.bash.org/?803557
http://www.bash.org/?803323
http://www.bash.org/?10434
http://www.bash.org/?10908
http://www.bash.org/?12261
http://www.bash.org/?15825
http://www.bash.org/?22183
http://www.bash.org/?33941
http://www.bash.org/?34001
http://www.bash.org/?56554
http://www.bash.org/?57047

How poeple are finding my blog. 621 views a new record!

I think it was Ben Nadel who was shocked as to how people were finding his blog through the searches they performed.

Since my blog had a new all time record for page views for the day, I thought that I would look to see what people search for to find my blog. Needless to say I was a little surprised.

jquery cheat sheet	9
cffile accept jpg	4
jquery rating	3
a friend	3
cfdocument	3
funny ferrets	3
FERRET	2
did tony die	2
cfdocument date time	2
mortgage industry jokes	2
Zombie Last Supper	2
swapit jquery	2
coldfusion sql get colum names	2

Seems I got a WIIIIIDE spread here…. lots of jQuery and ColdFusion stuff; but mortgage information and ferrets! I feel honored and for such and honor; the picture that started it all:

ColdFusion is not Java. UPDATE.

Yeah, that didn’t go over to well, however, I expected that. I knew I was going to get burned at the stake the second the post went live. I’ve been avoiding reading or replying back to any of the comments until now. Mainly because I didn’t want to get into a pissing contest with anyone over an opinion I had.

Alas, there are some people who feel I should defend my opinion and to that, I have this to say to them:

I Love You Linda!!!! – 2 years and counting

I’ve been married 2 years today!!!

I can’t believe it’s been 2 years since my wedding. Damn time flies!!! Who ever said marriage isn’t hard better get their head out of their ass. Believe me it’s tough, I’m not the easiest person to be married to and I have to commend my wife for putting up with me this long. Hopefully she’ll be around for a long time.

Anywho, the real reason for this post is this: my wife got me an XBOX 360 Elite, Guitar Hero 2 and DDR Universe as an anniversary present!!!! Is she not awesome or what! Needless to say that blog posts will be non-existent while I cure my Guitar Hero and DDR addiction finally.

<sappiness>Now for the reason for this post…. I love you Linny!!! Thank you for being my wife and best friend. </sappiness>

Installing Verity on HMS VPS

Just a quick note.

When you sign up for a HostMySite VPS plan, for some odd reason the Verity Search Service isn’t installed by default. To install the service, simply open Windows Explorer and browse to your C:\ColdFusion8\verity directory. Once there double click the verity-install.bat file and away you go.

You don’t have to waste your time trying the download the install from Adobe since frankly, the downloader is timing out and you can’t do it aways .