Monday, November 7, 2011

[Tips]

Who'd have thought... Toothpaste to clean oxidization from your headlights? It works!

Thursday, October 27, 2011

[Tech] Holy SQL Failure, Batman or... SQL Identity Value Change

I had literally one of the most stressful group of hours as an admin... I made an update to a production table that was required and two hours later it magically decides to start inserting duplicate numbers in the identity field (which happens to be the primary key as well, as that would naturally prevent duplicates since SQL generates the number and knows not to duplicate numbers, right?!)... Well, that was not the case today.

Today I got the dreaded "Violation of PRIMARY KEY constraint (contraint_name). Cannot insert duplicate key in object (table_name). The statement has been terminated" when trying to insert a new record into the table.

Of course, there was nothing that I changed in the table that should have created this problem... but here we were. So as I scoured the internet for solutions I noticed that there were absolutely no actual solutions readily available, so I stepped into Sleuth Mode and started pounding my head against my palms to figure out a solution to a problem that I hadn't identified yet.

Well, I knew that all of the other data that was being entered was not duplicate (because I had randomly entered it) and the only thing that could be causing a conflict would be the identity.

My first deduction was to identify what the value of the identity field should have been. A quick query against the table with a descending order of the id field solved that problem quickly: 119139.

Now I had to figure out what the current identity SQL was trying to use was. At first I hadn't any idea of how to do this off the top of my head (software dev first, database admin second), so I started digging. I found a very helpful command courtesy of MS: ident_current(). So there I was, sitting at the query window and I typed in my command... select ident_current('tablename') as currentid. Bingo... It said the current id being used was 119086. Wait... what? How could that even be? Why would it think that it was ok to roll back a number and begin trying to insert duplicates? I still don't know to this very moment why it did that. Remember, I hadn't changed anything about the primary key nor the identity. I had merely added a few more fields to the table.

So this is where the panic set it: This is a live solution. A database that the production software was using to store call logs, client data, anything and everything that made us money... and it was refusing to coincide to what it was supposed to be doing.

So then the Googling started again. I started simple: Why would SQL start duplicating identity fields. Guess how many valuable results that came up with. If you guessed ZERO then you are absolutely right.

After my first failure at finding a potential solution, I slapped myself mentally and asked myself why I hadn't just thought of how to change the seed. Well, I knew one way... and had tried it an hour ago. Guess what, it locks up the DB for a substantial amount of time and times out. Can't have that. So then I start looking for commands and I come across this nice fellow: dbcc checkident('tablename', reseed, newseedid). Simply replace the term tablename with your table's name (leave the single quotes in the command) and change newseedid to the new number you'd like the id seed to be and bingo, you have a new seed. Problem solved and crisis averted.

I hope this helps out some of you poor souls who may run into this issue in the future. It's far from an end-all-be-all solution, and it should be done only if you understand what it is you are doing (please look up the commands on MSKB before you implement them), and of course you are doing any of these things at your own risk... but it fixed my problem, and that is why I decided to share the experience.

Peace,
B

Friday, September 16, 2011

[Food] Penne Rustica

I've been making this pasta for about three years now. It is honestly my favorite. I actually use chicken & shimp for my meats in this and it does really well... Women beg me for this recipe. ;)



Gratinata Sauce
3 tablespoons butter
2 tablespoons minced garlic
3 tablespoons marsala wine
2 cups heavy cream
1 cup grated Parmesan cheese
1/2 cup milk
1/2 cup chicken broth
1 tablespoon cornstarch
1 tablespoon Grey Poupon Dijon mustard
2 teaspoons minced fresh rosemary
1/2 teaspoon salt
1/2 teaspoon minced fresh thyme
1/4 teaspoon ground cayenne pepper
1 pound penne rigate pasta, cooked
12 medium shrimp, peeled and deveined
2 skinless chicken breast fillets
1/2 cup (about 2 ounces) thick-sliced smoked prosciutto, chopped

Topping 3 tablespoons grated Parmesan cheese
1 1/2 teaspoons paprika

Garnish  12 sliced pimentos< 4 sprigs rosemary



Instructions

1. Preheat barbecue grill to high.

2. Prepare gratinata sauce by melting 3 tablespoons of butter in a medium saucepan over medium/low heat. Add garlic and sweat it for about 5 minutes. Be sure the garlic doesn't brown. Add the marsala wine and cook for another 5 minutes. Add the remaining ingredients for the sauce and whisk well until smooth. Bring mixture to a simmer and keep it there for 10 minutes or until it's thick. Cover sauce and remove it from the heat.

3. Cook pasta following directions on the package (7 to 9 minutes in boiling water). You want the pasta tender, but not mushy (al dente). Strain pasta and set it aside when it's done.

4. Pound the thick end of your chicken breasts a bit with a kitchen mallet to make them a uniform thickness. Rub chicken with olive oil, then sprinkle on a bit of salt and pepper. Spear the shrimp on skewers (6 per skewer should work fine), then rub them with oil, and sprinkle with salt and pepper.

5. Grill chicken for 5 to 6 minutes per side. Grill shrimp for 2 minutes per side. When chicken is done, slice each breast into strips.

6. Preheat oven to 500 degrees F. Build each dish in a large, shallow baking dish. Or you can use a 9-inch glass or ceramic pie plate. Load 3 cups of pasta into each baking dish. Add one-quarter of the chicken, 3 shrimp and 2 tablespoons of prosciutto onto each serving. Spoon 3/4 of a cup of gratinata sauce on each serving and toss to coat. Combine 3 tablespoons of grated Parmesan cheese with 1 1/2 teaspoons paprika, then sprinkle about 1 tablespoon of this mixture over the top of each serving. Bake the dishes for 10 to 12 minutes, or until tops begin to brown. Arrange three pimentos on the top of each serving, then jab a sprig of rosemary into the center and serve.
Makes 4 servings.


Thanks to the great Todd Wilbur who released this one years ago. I watched it the day it came out and I fell in love.

Tuesday, August 23, 2011

[Survival] Edible Plants Test

Here is some information (with some notations) regarding survivability in the wilderness. Apparently the pared down (without my notations) version is available as the new test in the USAF ejector seat manuals. Wanted to document it, so I wrote it up and am going to post it here.

------------------------

Plant Edibility Test
Rules of Eight

Your Senses Can Identify an Unknown Plant's Edibility

SIGHT
1. First look for plant parts that contain high energy
a. Fruit
b. Seeds, grains or nuts
c. Roots, bulbs or tubers

2. Never Test:
a. Fungi (mushrooms, mold, etc.)
b. Seeds in Pods (beans, peas, etc.)
c. Plants with umbrella shaped flowers (dill, hemlock, etc.)
d. Plants with milky sap (poinsettia, poison oak, etc.)
e. Shiny/glossy leaf plants (many tropical house plants, poison oak, etc.)

SMELL
1. Stop the test if:
a. unpleasant odor is present
b. plant is moldy or musty
c. unusual odor is present
2. If there is an almond scent, STOP TESTING.

SKIN
1. Place the juice of the plant on the outer lip for 8 minutes.
(This is the fleshy part of the lip just outside the dark part of your lip or lip ridge. It has sensitive skin and is far enough away that the juice won't reach your mouth)
2. If reaction occurs, STOP TESTING.
3. If no reaction occurs, move onto the next test.

TASTE
1. Taste a small amount of the plant juice.
2. Chew a small pinch of the plant and leave it in your mouth for 8 minutes.
3. If an unpleasant taste or reaction occurs, STOP TESTING.
4. If no reaction occurs, swallow.

DIGESTIVE SYSTEM
1. After swallowing, wait 8 hours.
2. If no reaction occurs, then:
3. Chew a handful of the plant, swallow, and wait 8 hours.
4. If no reaction occurs, consider the plant part edible.

-------------------------

Remember that this is no substitution for actual plant knowledge and just and additional tool to use in survival situations! :)

-----------------------------------------------------------------------------------------------

And an update for those couple of you that follow me and haven't heard from me in ages :
I flew out two months after Morgan went back from her trip here to visit me and we drove across the country together in a pretty awesome experience. She now lives with me and we are ecstatically happy. Life is very awesome right now. :)

Thursday, April 28, 2011

[Love] Morgan's Second Blog Post

I took a chance flying across many states just to meet someone, however, I rationalized that meeting any new person involves risks and besides, I could get on the plane home as quickly as I came, but honestly, I didn’t think it would happen that way, and it didn’t. Brandon picked me up from the airport, got out of his car and walked toward me with a grin on his face. I gave him the biggest hug and kiss. We spent the rest of the afternoon in Seattle, going to the aquarium and eating messy seafood, and even though I was confident I knew Brandon well, his mannerisms, confidence and charm made him all the more attractive to me. And I was a worried, however slightly, that our dynamic interaction online, and through texting and talking would somehow not translate in real life, but as we spent time together, and had our same dynamic conversations, that worry quickly vanished. Brandon had taken some vacation time for my visit and we spent our time watching movies, taking walks, making meals, eating at restaurants, and yes, touristy things like visiting the nearby Belgium-themed town littered with gift shops, and touring his hometown. I also got to meet some of his family and we all even went out eating, playing arcade games, and bowled on the last night I was there. The whole time by his side felt like I belonged there and he made it very clear that he felt that way, too. Our time together was challenged by the fact there were some problems at his work that he had to go and fix, but I knew that he had to fix what he needed to fix and patiently waited for him to come back home, and even got some studying done in the meantime. After my visit, I realized that I had to be with him, but there was school and a job to consider. After uprooting my whole life the past couple of years to go back to school, the move just doesn’t seem to be that disastrous. I mean, there are retail or childcare jobs and colleges in Washington that are every bit as good as the colleges here. If I am uprooted here, certainly I can be uprooted there and be somewhere where I want to grow and cultivate a life- my adult life. So I have made the decision that I will be moving me and only my necessities to be with the man I fell in love with. It’s extraordinary, but really, the whole thing is.

Friday, April 1, 2011

[Love] Morgan's Visit - The Arrival

So when I headed over to Seattle to pick Morgan up at SeaTac I was a bit early... The weather hadn't been very great and I was worried about getting stopped on the pass (as in, it being closed), so I headed over early and had a couple of hours to spare once I got over.

I headed out to Bellevue to visit my buddy Hugo and see his mother (his mother had gotten very sick at the end of last year and Hugo's wife stayed at my house in the spare room for two months while she was in the hospital over here). I spent the better part of an hour with Hugo and had him get me back to my car by 2:30 to give me enough time to get up to SeaTac to wait for Morgan to arrive...

I underestimated the habit of Seattlites to leave early on Fridays and ended up getting there about 10 minutes late! (I know, can you believe that?!)

The moment I sped into the terminal, I called Morgan and let her know that I would be looking for her... She told me she was under the Alaska Air sign, so I started looking. Hmmm... There are four of them amidst a sea of airline logos and several doors to match. I ask her which door number she's at... She says 20. I see 18, so I keep driving a bit. I then notice that I'm going down in numbers. I HAD PASSED HER! Damnit, I said over the phone and pulled into the door marked 16. She says on the phone, "I see you."

I get out of my car to rush to unlock the two doors for her and her luggage (as I always do for women). Just as I'm about to unlock the back door, I glance to my right and see her. I had finally seen my love in the flesh, and it was more than I could have imagined. I quickly took her into my arms and she hugged me very tightly as though she didn't wish to let go.

After an embrace of a couple of minutes, I gently kissed her on her lips (which surprised her, since I am kind of a "rough and tumble" looking guy I guess) and told her we needed to get out of the terminal. Her face, neck and chest were the color of a Dr. Pepper can and the smile on her face told me all I needed to know. She was as elated as I was. Life was good.

I opened the doors for her and her luggage and loaded her bags into the back seat. As she sat down in the passenger seat I looked down at her with a smile and closed the door behind her.

As I pulled out of the terminal, I could sense the intense eyes stealing glances at me between looking out at Seattle and placing her hand on my leg. As we drove out of the airport I finally undertsood what it was to say and feel "completeness." I had finally discovered what it felt like to not be so unique... not be so alone in the world.

That's all for now, but I'll post more at a later time. I hope you enjoyed reading it as much as I enjoyed living it.

Take care,
B

Tuesday, March 29, 2011

[Love] The awaited Morgan Blog Post

And here it is... compliments of Morgan :) :

"It all started on a tiny forum. Topics great and small were discussed. After getting acquainted with the regular members, I decided to add them as friends on facebook. One man in particular interested me, the guy a few years older than me whose profile picture was him wearing his headphones. At first I had chatted periodically with Brandon as I chat with other acquaintances, but very quickly I learned that he "was the male version of me." I admired him and enjoyed chatting with him about anything and everything, from the trivial to the transcendent. Chatting on Facebook turned to texting and turned to talking. The stuff he was saying matched what I do, what I say, and what I think exactly, and vice-versa. . . to the point of being mind-blowing. There were also strange coincidences: we would wake up within minutes of each other, say the same thing at the same time, or bring up a subject the other had on their mind. One day we were even eating the same thing while talking on the phone. . . It was all very strange. We talked on the phone every day for three hours or more. I slowly began to realize I wouldn’t be able to go through with my life never meeting Brandon face-to-face. So we arranged for me to visit during my spring break. . ."

Thursday, March 17, 2011

[Life] The Beginning

Tonight, St. Patrick's Day of 2011 is the night before my life is to change drastically... Tomorrow, my dear love Morgan arrives and I have to say I don't think I've been as excited as this in a very long time, if ever. The inner peace I found on my path of self-induced celebacy has come in the form of my match. A woman who is so in tune with my own being that I needn't worry about what is said or not said, because all is known without a single spoken syllable.

I asked her to write me a paragraph about a month ago (shortly after my last post). She agreed to write it. I have yet to see it... Of course, that's because she's just as bad of a procrastinator as I am. :) Hell, I had to basically force myself to come write THIS. lol

Anyways, I'm off to finish preparations for her arrival and the subsequent drive tomorrow to pick her up. Perhaps as the week goes on we will drop in from time to time.

Take care,
B

Thursday, February 24, 2011

[Life, Love] Questions Answered

I was asked the following question, and instead of replying in a comment I figured I'd answer right here... Since I'm bound to be very wordy and will take up plenty of space. :)

The question(s):
"with a love like this, do you feel like i do, that you just want to jump in with both feet? somehow you just know it will work, that it's meant to be? what IS that feeling?! do you believe in soulmates?"

The answer(s):
Honestly, I have never felt so... RIGHT... So IN THE RIGHT PLACE... as I do right now. Someone who actually understands me and my quirks... who actually GETS that I'm not perfect and accepts that and doesn't expect me to be any other way. Someone who is as fiercely loyal and loving as I am has fallen into my lap almost magically (though we don't believe in magic).

We have had many discussions on topics that other people in similar timelines wouldn't be capable of and both have agreed that this is it... That this is the "will work no matter what" option that we've both been looking for, and that while there may be rough times that as long as we can communicate with each other that we'll get through anything we have in our way.

Do I believe in "soulmates"? Well, I don't think either of us do. Or rather, I don't think either of us DID before this. We don't use that word because we don't believe in superstition or the like; however, the only explanation I can give (to kind of put it into words) is related to the quantum theory of entanglement... And it's like all of our quantum elements are entangled with one-another. It's really quite amazing... We actually played a nice little game yesterday of "guess what"... She guessed what I ate for lunch in two guesses. The first guess was a place we'd talked about before, the second guess was a place we'd never spoken of... I had her elaborate on what I had on my sandwich. She missed only one item. ;) (She added jalepenos, but I forego jalepenos on my sandwiches for peppercinis and chipolte sauce :) ).

She then thought it would be fun to turn it around... And as soon as I started focusing, I started literally tasting cocoa powder... Like the kind you get in the little pouches. I ignored that, because obviously she couldn't be eating that stuff. I narrow it down to an option of a chocolate candybar and hot chocolate. I guess the hot chocolate. She says "Close." And I follow up with "Well, then I'm going to guess a mocha latte." Ding, ding.

Now, this under normal circumstances would be interesting alone... But the fact that we're thousands of miles away and have yet to touch each other. It's just... phenomenal.

We are certainly a team of 2.

I hope that answers your question thoroughly. Always happy to answer questions... I guess I'm a glutton for motivation (I AM, after all, a hell of a procrastinator... I think Morgan and I will be fighting for that title amongst each other for a long time to come).

Take care,
B

Tuesday, February 22, 2011

[Life, Love, Happiness] The Way the World Twists and Turns

It's been far, far too long since I posted something here, and I know of a certain someone who may be interested in hearing news from this ol' dog...

The last six months have been pretty crazy. After getting over the whole "losing the baby and losing my lover" thing last year, I branced out on a search for someone... something that would put me to ease. Anyone or anything that would appease my need.

After a dating a couple of girls, a "hanging out with a friend turned clingy girl" and a "love interest from the past turned crazy chick" I decided to forego endulging in my favorite pasttime and start to focus on myself... To develop personal growth within and to recenter myself... I had truly gotten too far away from who I was.

Well, enter Morgan... Now, Morgan at first glance looks like a fun, beautiful girl who has lots of brains and is gentle... In truth, she is all of those things. :D Anyways, as we began to speak some really strange things began to occur. We started talking about ourselves and our lives, our likes and our dislikes and a variety of other things that newly formed "couples" speak about. The strange thing is that the majority of what we experienced in life was similar (eerily so) and our opinions, likes and dislikes were also eerily similar... I would be thinking about something and she would ask me about it... I would ask her a question and she'd be looking at something that pertained to the question I was asking her. We would wake within minutes of each other... say the same things (specific words) at the same time with the same inflection... Soon the game became more of "finding what was different" than the normal couple's "finding common ground." All of the things that tend to shred a relationship are non-issue... Why? Because we agree on them. She would share a personal hope/dream that she always had and it would be so in line with mine that I'd tease her about having an implant in my brain.

Now, most of the time I would default all of these to coincidence... that is if it didn't happen so damned often (10-15 times a day at least). Neither of us likes to talk on the phone, but we'll spend hours talking on the phone to each other... Not realizing the time has passed until I happen to glance at the time (she never looks at the time... how sweet of her).

Anyways, this has been an amazing adventure over the last 5 weeks. So much so that we have spoken of writing a blog to document everything and tell our story as it unfolds...

Love those around you for who they are today, not who they were yesterday or who they could be tomorrow but for who they are right now... the moment you hold them in your arms... If the world could do this, there would be a hell of a lot less hate.

Take care and spread the love,
B