Sep 18

95%

Posted in:Personal | 2 Comments »

Back when I used to work at Irresistible Ink during my first yearly review my boss referred to me as 95%.  He told me that I can do any project and fly up to 95% and afterwards wait until the last minute.  I sometimes feel like this is true about my life lots.  I can climb to near the top at almost anything I do.  Be it djing, working within the car club, or work.  It seems like it comes with relative ease as if I prove to myself I can be the best, then slouch off.  I wish I could explain why I do it, or where it came from.  I know that when I push myself, I climb over the wall but there have been few times I’ve done that.  I really don’t know where all of this is coming from either.  I should be in relatively high spirits.  I’ve been working a bunch of hours but beyond that, I’m on track for a very successful year in my life.  I love my job, Brandon starts work there next week.  My dj crew is growing more and more and we’re throwing 3 shows in the next few months which will put us at the 4 shows I wanted to reach in the beginning of the year.

For those that don’t know, I also signed up for a gym and I’ve already lost 6lbs in the last 2 weeks which puts me just a hair over the 2.5lbs / week goal I set for myself.  Yet at the end of the day, I feel dead.  I haven’t felt like going out for quite some time now and even playing out isn’t a priority.  I really think I need a vacation and may opt to take one in October.  I’m really considering just getting in the jeep and driving.  Where I end up, it really doesn’t matter as long as it’s away.  Of course, that means getting away from work, probably everyone I know as well.  I really enjoyed being away with an entirely new feeling.  Driving in downtown Nashville, not knowing what I was going to find was exciting.  Granted this would probably be a better plan if it was summer but maybe I’ll just go that far south.  Who knows, not me that’s for sure.


Sep 17

Yes, I’m am a gear geek now

Posted in:General | No Comments »

I always thought the iPod was a cool device but I never really got into it. It’s funny the world we live in these days. It’s so convenient. I’m watching the movie Shooter in HD as it downloads from XBox Live right now. Meanwhile sitting on my couch with the laptop wirelessly. Speaking of wirelesss, I purchased another bluetooth headset last week. Thanks to Steve Jobs deciding that everyone that purchased an iPhone is entitled to $100 in in-store credit, a new Jawbone Headset only ran me $32. The employee in the store rang me up and even emailed me the receipt rather than printing it from his handheld point of sale system. As a jeep owner, one of the biggest problems I have is wind noise. I had originally purchased Apple’s iPhone Bluetooth Headset.  Now this is a cool product.  It comes with a dock and a mobile USB cable so I can leave at one at work and take one home.  It’s absolutely tiny, and when I charge my iPhone, the headset charges in the dock along with it.  The downside is that it seems to pickup wind noise like nobody’s business.  So with my new credit, I purchased the Jawbone Bluetooth Headset.  Now it’s a bit bigger than the Apple headset (read: much) but it actually possesses adaptive noise shielding.  By doing this, it does an excellent job of filtering out background noise wherever  I am.   Now driving the jeep with the top flapping away or the window open at highway speeds doesn’t mean I can’t use my phone.  I’m still happy I have the Apple headset though as I intend to use it once I put the hard top on the jeep.  Until then though, I’ll talk with relative zero background noise from the Jawbone.


Sep 5

It’s time for more life changes!

Posted in:Personal | 1 Comment »

Well I decided to make a life change today and it’s a pretty big one.  It’s actually one that will have a huge impact on my life.  I really don’t keep too many secrets, so as an experiment, I’ve told one person of the change.  It’s something that if it goes well, will affect me for the rest of my life.  Have any guesses?  Anyways, it’s one of those things that’s for the better.  I’ve considered creating a separate category that’s private where I can write about it and then once I’ve decided to, I’ll open it up for others to see.  Here’s to my new endeavor!


Aug 22

No, I haven’t forgotten

Posted in:Personal | 1 Comment »

My life has been pretty nuts lately.  I’ve been employed for almost 2 months with the new job and I still wake up in the morning excited to go to work.  I feel like they really appreciate me, and I keep getting to do new things.  Right now, I’m spending alot of our time reverse engineering the previous programmer’s work.  He wasn’t very good at keeping things organized.  There are no comments, and its like untangling a big mess of cords to figure out where things are.  Thus far I’ve been using the Zend Framework in favor of Cups or Code Igniter.  I made this decision based on a few things.  While I hate to say it, ZF is made by the creators of PHP.   Because of this, I expect the best support out of it as well as community.  Some parts of Code Igniter feel cryptic and the community around seems small.  Working with ZF and hanging out in the irc channel for it reminds me much of when I started learning PHP.  As far as where I’m at with our re-write at work, we’ve been doing a lot of planning on the show management side which will lead us into the call center manager’s portion of work nicely.  In a way it feels exactly where we should start so I think we get bonus points for that.

I’ve also written a search engine of sorts to search or data tables easily.  The existing setup is fairly clunky (which I’m sure is hard to  believe based on previous statements) so I rewrote it the way I think it should be done.  It’s not 100% but it’s definitely an improvement over our exisiting one.  I plan on posting the basics of the code here once I get a bit further along with it to share.

Beyond that, I purchased Bioshock today for Xbox 360.  It’s purely insane.  The graphics are unmatched and it’s the first game to scare me and make me jump in years.  Plus its a fun single player FPS.  It’s been a while since I’ve found that.    Anyways it’s near one oclock and I have another long day at work tomorrow so I’m crashing.


Aug 6

Apple is changing my life

Posted in:General | 1 Comment »

So I’ve decided that the iPhone is a device that will change my life. Sure I haven’t even had it a week, but now that the initial “I have an iPhone!” buzz has worn off I think I can make an accurate assessment. now before people start telling me “well my blackberry can do that”, keep in mind up until this point, I’ve avoided the blackberries, the t-mobile dash, treos, etc for the most part. I’m looked at them a bit but I’ve always been turned off by their inability to browse the web easily. So I’ve put together a list of pros and cons for why I love my iPhone.

Pros

Interface
The interface on the iPhone is slick. I can bounce from program to program showing someone my phone swiftly, and it looks cool as well, watching things slide off the screen like deleted emails, or rotating the phone to show someone my albums in the iPod portion of the phone. Browsing uses a real browser, sure I don’t have flash yet, but that’ll come eventually. I can login to my wordpress panel, myspace, or search weather.com fairly quick. The keyboard is also pretty quick once you get going on it. I’m by no means typing like I do on a keyboard, but faster than on any other phone I’ve had.

Google Maps
Living in Minneapolis, I get to deal with traffic during my commute. Now the current traffic status is just 3 clicks away while I’m on the road. Best of all it’s been very accurate thus far. Sure lack of GPS kind of sucks but I know how to read a map. If I want to find something, I type the zip code and what I’m looking for. For example “55416 go karts” and it shows me all of the go karting places on the map. Tap on one shows the address and phone number, 1 more tap and I’m calling them.

Syncing is easy
It took me about 5 minutes to move my contacts from my Motorola RIZR to the iPhone and that included installing the Motorola Phone tools. I synced to the Windows Contacts, then synced those to the iPhone and I was done. This was a bigger pain in the ass when I went from my RZR to my RIZR. On top of this you get the standard fairly reliable syncing you have with the iPhone. Your pictures directory syncs fine, just like videos, music, and podcasts.

The Calendar rocks
The calendar on my previous phones sucked. With the iPhone I can list a radio show, then edit each one individually. It’s a simple feature lots of phones miss out on. I just wish they had an option pre-installed to text or email the calendar date somewhere else. THat was as I book someone for something, I can email them a reminder right from the phone.

Cons

Lack of multimedia MMS support
Why can’t I send or receive pictures easily via MMS? I’m able to email pictures. For that matter where is my video support?

Where is iChat or a similar IM client
Sure, I can use something like meebo, or there’s TinyBuddy IM which was written by a aol programmer for the iPhone, but I can’t leave my phone on. I honestly can’t wait until 3rd party applications have hit. Things like Pownce or Twitter will truely take off. Can you imagine a world where you can send an mp3 via Pownce on your phone? Then access it the same on your pc or mac?

Ringtones?
There are a bunch of rumors going around that Apple is going to charge $0.99 for a ringtone to put on your phone. Sure it’s cheap compared to others, but seriously, why would you bill me for it? My theory is that Apple will let you create a ringtone from any mp3 you own, or from the iTunes store for $0.99.

These are just a few things that are the tip of the iceberg, but I really haven’t seen many other people talk about. The iPhone doesn’t have 1 awesome feature, it has several and in the end, all the cons can be fixed via software. (except lack of GPS) If this is a first gen model, I can’t wait for the second or third.

I also picked up the Apple Bluetooth headset and was impressed by that. The headset comes with a dual dock that allows you to charge your phone and headset at the same time and while charging, the headset’s battery status is displayed on the phone’s screen. The wind resistance in the jeep isn’t really cut down at all and I can’t be heard at all so I’m deciding if I want to exchange it for a jawbone, or perhaps keep the Apple headset and buy a jawbone for the jeep.

The crazy thing is the iPhone is almost enough to make me an Apple fan boy, in fact I started wondering about picking up an older mac laptop. I’ll cover that up by using it to know the most I can about the IT market, but after owning an iPhone, I’d be lying if I said I wasn’t intrigued at what Apple does with an entire OS.


Aug 3

at least I didn’t cave

Posted in:General | 1 Comment »

Its been a bit since I posted. Since there aren’t many comments though I assume not many people visit anymore. I’m currently sitting in the theatre at the Mall of America waiting for the Borne Ultimatum to start. Do to the wonderful company known as Apple I can do this from my new iPhone. I managed to convince work to purchase one for me.
thu
Thus far Im pretty impressed with it but I can’t go into too much detail since the movie is about to start. Rest assizes I’ll get to that soon. Well the previews are starting, until next time…


Jul 29

Fun with SQL and in line queries

So I’ve grown to not like the coding style of the guy before me at all. Some of his methods are quite, recursive and hellish when it comes to SQL. Several times, the easy way was taken rather than the correct way. To give you a bit of background, the main application I support controls at outbound call center. Agents log into the system and dial out with it. In order to track what a current agent is doing there is a table called actions. Everything from logging in, logging out, and more is logged here. Over the past 2 years, this has led to over 7 million records in the table. If you’re not a tech person, it’s about to get deep.

In order to determine if a user is logged in, the previous programmer would do the following. Query the database for all users with a type of 2 (call center agent). After that for each user in the database of type 2 (call center agents, currently ~120 agents exist), he would query the actions table for the users last action, whether it’s action type 1 (login) or 2 (logout). If the first returned row is of action type 1, the user is logged in. Lastly, the code queries the actions table to see what the last campaign a user logged into. (action type 20). After throwing in some basic code to track the queries and time of this (and thanking John Davis along the way for teaching the importance of big O notation) I learned that an average check of who’s logged in totaled around 150-200 queries along with taking 45 seconds to a minute. So this was one of my goals in Nashville last week, to write one massive query I could use to get the results I’m looking for. To assist me in the insanity, I called master of all that is shoes, Brian Schumacher. We worked together back at Irresistible Ink as data developers and since he’s gone on to be a DBA in Klamath Falls, Oregon. Well he quit last week but that’s his story not mine.

So after about 45 minutes of being on the phone and utilizing the greatness that is pastebin, we worked out a viable solution. I present to you, possibly the most complicated query I’ve written to date.

SELECT
loggedIn.lastname, loggedIn.firstname, campaigns.cpnname, DATEDIFF(ss,[actions_4].[actionwhen],getdate()) AS LoggedIn, DATEDIFF(ss,[actions_3].[actionwhen],getdate()) AS CampaignLogin
FROM
(
SELECT
employees.unqempid, employees.lastname, employees.firstname, ActionIDLoggedIn.actionID
FROM
(
SELECT
unqempid, MAX(actionid) AS actionID
FROM
actions
WHERE
(actiontypeid = '1')
GROUP BY unqempid
) AS ActionIDLoggedIn
INNER JOIN
(
SELECT
unqempid, MAX(actionid) AS actionID
FROM
actions AS actions_2
WHERE
(actiontypeid = '2')
GROUP BY
unqempid
) AS ActionIDLoggedOut
ON
ActionIDLoggedIn.unqempid = ActionIDLoggedOut.unqempid AND
ActionIDLoggedIn.actionID > ActionIDLoggedOut.actionID
INNER JOIN
employees ON employees.unqempid = ActionIDLoggedIn.unqempid
WHERE (employees.type = 2)
) AS loggedIn
INNER JOIN
(
SELECT
unqempid, MAX(actionid) AS actionID
FROM
actions AS actions_1
WHERE
(actiontypeid = '20')
GROUP BY
unqempid
) AS maxCampaign
ON maxCampaign.unqempid = loggedIn.unqempid
INNER JOIN
actions AS actions_3 ON maxCampaign.actionID = actions_3.actionid
INNER JOIN
campaigns ON actions_3.actioninfo = campaigns.cpnid
INNER JOIN
actions AS actions_4 ON loggedIn.actionID = actions_4.actionid
ORDER BY
loggedIn.lastname, loggedIn.firstname

The end result, we’ve shortened this down to 1 query that takes 2-3 seconds. Hopefully this post can only serve as help to some programmer stumbling along a similar problem as mine.


Jul 25

Hell, turn right

Posted in:Personal | 1 Comment »

DSC00332

So I’ve now spent 2 days in Nashville and I’ve learned quite a few things. The first of which is if you’re ever IT and going to an area to be told their problems, you’re fresh meat. I’ve spent alot of time being told the seventeen thousand things the previous programmer of the application I now manage screwed up. I still like the job, in fact since I know how much of a difference it will make I’m pretty pumped to get started. However I have decided to re-write the application the way it should have been written so it doesn’t resemble a plate of spaghetti. I actually just got home from a joyous 10 hour day. I made a few tweaks to the system to improve it overall.

I did take an hour long break however to run to the bookstore. I ended up leaving with 3 things I think will help my career. The first being the heavily work related book, MS SQL Server 2005 Unleashed. One of the things I wasn’t told is that I’ll be fulfilling the role of database administrator, and my MS SQL is a bit weak compared to MySQL. Thus I picked up the book so I can brush up where need be. Secondly, an issue of HOW magazine, which is much like Cre@te magazine, a designer magazine I used to read. Lastly, and my favorite purchase in iWoz, the autobiography of Steve Wozniak. For those of you that aren’t familiar with Woz, he’s solely credited for the creation of the personal computer, and co-founder of Apple. Hopefully by reading this, somehow I can watch my desire for the iPhone subside.


Jul 23

Nashville?

Posted in:Personal | 1 Comment »

DSC00197

Well I’ve had an excellent few days off. Played a few great dj gigs. I also splurged a little and picked up a digital camera. After doing a bit of research (i.e. calling my Uncle Mike) I decided it was time for me to own a digital camera finally. For a point and shoot, it seems to do fairly well with a bit of tweaking. Because of this, I also setup a Flickr account to host my pictures. They make it so easy, it seems to make more sense than setting up Coppermine or Gallery. Sometime this week I’ll probably setup a Flickr plugin with WordPress to share my pictures with everyone.

I’m flying out to Nashville tonight for work. It’s my first time actually being sent anywhere for work so I’m excited, and of course I’m going to take lots of pictures. Work has been going great although I feel a bit overwhelmed with everything they want to do. Everything has to be done yesterday it seems. The past 5 day weekend has been the recharge I’ve needed.


Jul 16

Hacking at work for fun and a paycheck

Posted in:Tech | 1 Comment »

So at the new job we have a few offices in different locations of country.  For example, next week I’m heading to Tennessee to experience the call center application I’m working on first hand.   I had just relocated one of our databases from the Michigan office to our sql server here in Minnesota and a report that a user from Michigan runs broke in the process.  The user called in to report the report had to be run but she wasn’t at her system.  I was told that remote desktop was disabled on these systems but the passwords I was given weren’t working properly.

After some failed attempts at remotely starting remote desktop, I started looking into ways to get into VNC.  They weren’t running the older vulnerable version of so that was out of the question.  After doing a bit of google searching I came across a utility called vncpwdump which allows you to dump the existing password from the registry.  Unfortunately the program was only giving me a portion of the password.  Instead I decided I was approaching this the wrong way.   I went ahead and changed my VNC password to a temporary password and then exported the registry key.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\RealVNC\WinVNC4]
“Password”=hex:aa,aa,aa,aa,aa,aa,aa,aa
“SecurityTypes”=”VncAuth”
“ReverseSecurityTypes”=”None”
“QueryConnect”=dword:00000000
“dummy”=”"

Then using Connect Network Registry option in the registry editor, I imported my registry file to the remote system.  Voila!  


HEY! Did you eat my pickle... or did I?
-Kyle Berg

  • Josh
  • Nothing to Say
  • Plastic Metal
  • Shoe False Fiction