• Category Archives General
  • I hate slow DBs

    Have you ever called a place that needs to look up your account or other info? ever notice how it takes about a some time for them to get that info?

    I’m the guy on the other side of the line waiting to get that info so I can help fix what ever problem they had called in with, and the longer i work the more i notice that its taking longer and longer to for me to pull up any info about any account. So whats is the deal, why cant a multi billion dollar company fix a database?

    We live in the Age of Information, where almost everything is instant, where people expect info or help to be provided to them that instant. My guess is everyone at my place of employment probably don’t even notice the long waits between DB queries through our ticketing system. So how long is long? well i decided to test this, for a basic customer id I queried takes about 20 seconds, ok thats acceptable but thats only to bring up there info, not there ticket history. So i click on there history, guess what another 30 seconds on the clock, so it starting to get bad, after that you can click on individual tickets, create a new one or use tabs to look at more info. Each tab when clicked on takes 5-25 seconds to open. And these are the fast times, other times i sit 30 secs to about 1 min to get anything useful, and there have been times that I started a query when I left for break , came back and still had 5 mins to wait till it finally showed some results. My querries where presise and dont pull alot of data, but this is getting ridicolous. So how does a database get this slow? traffic? Nope cant be traffic, I work 3 rd shift and have about 15 people who use it , during the day over 100 people use it. What about maitnence? not likely, thats run once a week for about 2 hours or so.

    What else could it be? corrupted database? bad design for a large database? I  have never worked with a large database like that before so I don’t know the challenges of design or maintenance of such a large beast. But I have worked with smaller DBs that had similar slowdowns, but that was caused by too much data being pulled, like querying the entire DB or a few thousand rows. Or could the bandit be the vendor lock on the ticketing system in combo there DB, by the way the ticketing system looks very customized and even has features, custom built by other vendors, like the data being pulled from  an access database or integration into 2 other ticketing systems. My guess is Oracles Seibel, and DB work wonders out of the box and setup correctly even better when you use there system to input the data. I wonder who approved adding more plugins was a great idea?  This kind of bloat is inexcusable in a place where employees are timed. How do you fix something thats going to get screwed anyways, there policy just keep it chugging along, my solution would be to start gettting rid of or migrating 3yr+ old tickets and closed accounts to another DB, at least it would be a start, next would be to start removing the bloat from system, we do not need it to make our coffee and tell us were great. We need something light fast and simple, all we want to do is get the person what they want and move on. What will it take for these so called decision makers to realize that there all in one application dream doesn’t work in reality. Maybe this will become the next epic IT failure? not likely because its behind closed doors and if it failed i doubt that they would even tell the employees. So far i enjoy working for the smaller company, at least your voice is heard unlike here where your the bottom of the barrel.

    Sorry about the long rant but some things at large companies are inexcusable that can throw money at situations. I thought customer service was supposed to be the focus of what we do. When will the people who call the shots going to learn to think logical instead of  using a magic 8 ball and some business lingo to make decisions about technology.


  • Web Site Security- what to do when you get hacked?

    Recently a Client/friend asked me to help him with his site after he found out he was hacked, in a situation like that i would gladly volunteer my time to help assess and fix the issue and prevent it from happening again. All the Guides from the major CMSs or other frameworks all have help guides to helped you when you get hacked. WordPress and Zen cart both have very good guides, but this guide should be a general help guide to getting back on track, you may have better site specific info from the company that developed the framework. Also check the forums as well for other people that have been hacked and how they fixed it and what the cause was.

    Continue reading  Post ID 237


  • Optimizing your social networking updates

    Screenshot
    Most people, now have multiple social networking accounts. so what do you do if you want to update all of them? Most would just log in to there preferred site and just do a status update, I think that this takes to long and i could spend that time coding or writing another post, so i decided to consolidate everything to my blog.
    Now I have been using WP plug called ‘Post to Twitter’. Its very simple you put your login info into it and click test, and its all set to go, simple enough write?
    Next is hooking up myspace to twitter, very easy, click on the link on your home page ‘get synced’ and fill out the form and your connected, next you would test by making a post to your blog, then check your update on myspace, now it should have updated. I didn’t have any issues with it updating my status at all, I cant guarantee that it will work for you, but why not try.
    After that I hooked up my facebook. I tried 2 different apps, the official twitter app and the ‘Selective Twitter Status’. I liked the selective one better because i didn’t have to use my user name and password for twitter, I really don’t like to give social networking password to other social networking apps, Its just add another link that could fail.For the selective app, all you have to do is install the app, allow it to post, on your next post add #fb and it will post it to your status.
    This setup may be useful for Blogs and people who just want to post to one place. This is a one way update, I post to my blog then my WP plugin Posts to Twitter, next Facebook and Myspace get updated, and thats exactly what i wanted this to do.


  • NerdCore


    more than 5 years ago I was introduced to Kompressor, an interesting Musician with some really great songs. One Of the songs featured MC Frontalot…..and for the longest time I had looked for his music through google and other people but didn’t find any, I pretty much gave up thinking it was a person that just wasn’t in the Business any more…..I was wrong…..I was looking through Fidgit.com and stumbled upon the video above and was shocked that He was still making music….Check out his webisite @ http://frontalot.com/index.php/

    I guess I have another CD to buy! and DL all there free songs Here

    The song that Interduced me to MC Frontalot- “Rappers we crush f. MC Frontalot” Kompressor kompressor_-_rappers_we_crush_(f._mc_frontalot)


  • Fun with user agents

    I wanted to share this fun and interesting tool that I use and to test certain aspects of some of my applications, User Agent Switcher Is a Firefox plug in that changes the user agent to the one selected. For those who don’t know, a user agent is the name that the browser gives to the website to make sure it is compatible, another use is for search engine crawlers to identifies them to the site that they visited and added your site.

    My original use for it was to bypass a governments website restriction to IE only so i searched for the best possible way to change my user agent, there are other ways to hack Firefox to have the same out come but takes a little bit of know how, so i found user agent switcher for this purpose, next i turn it on and change my user agent to IE 7, then go to the website with that restriction, and i get through with out a problem, this doesnt always work and may crash your browser so try that at your own risk.

    Now for the fun part, ever wanted to see what some sites show google but not you, So download the ltest list of user agents here, import it and change your user agent to google’s bot and explore to see what sites show google or yahoo, or change your user agent to some ancient browser, like MSIE 3.0; AOL 4.0;, see what sites depend on such things to work, you would be surprised to find that Facebook and MySpace depend on user agents and ask you to upgrade your browser, other sites just say that support for your browser is coming soon, or get back at those people that look at browser statistics from sites and you start seeing profanity driven browsers…

    Another Use i found was for work, there are a few web applications that we use and they dont play well with Firefox, so i load up User Switcher Agent and turn on IE 7 and load the apps up and they start working……..well almost one, worked fine, the other…..the one that I really wanted working Bombed and froze Firefox……..well you can’t win them all but at least I tried.

    So Try out User Agent Switcher and add it to your toolbox.


  • twitter script for linux

    Well let me give you an interesting script i found on Tech Republic………..

    Its how to Tweet from the command line using cURL, its very simple and to the point….just like a script should be
    tweet.sh
    #!/bin/sh
    tweet="${@}"
    user="username"
    pass="sekret"
    if [ $(echo "${tweet}" | wc -c) -gt 140 ]; then
    echo "FATAL: The tweet is longer than 140 characters!"
    exit 1
    fi
    curl -k -u ${user}:${pass} -d status="${tweet}" https://twitter.com/statuses/update.xml >/dev/null 2>&1
    if [ "$?" == "0" ]; then
    echo "Successful tweet!"
    fi

    to us it just type this
    $ ~/bin/tweet "social server rules"
    the only other thing to worry about is you have to escape “?”, “!” -> “?”, “!”


  • Work, The Internet, Your Browsing

    Have you ever had that feeling that someone is standing over your shoulder, while browsing at work?  Or someone sends you a link in your corp mail, you click and you get that wonderful message, “this site has been blocked by <your big brother software> for <some reason that its not related to work>”…… Every time i have gotten a message like that, my brain goes “uh oh” knowing that in some log that it recorded your user name time and the site you were trying to get to!! So you think that this is another mark on your flawless company record…but even worse is it keeps all the sites that you go to regardless if its blocked or not…….So are you getting paranoid now? Well don’t be unless you know what your doing is against company policy like looking at NSFW sites or other social networking sites. But it still bugs me that my Digital Privacy is still being infringed upon……I know that Company’s put in filters and proxy s for extra security to keep out the viruses malware and spam from the internet, But do you really need Draconian laws to help with security? isnt there a better way, maybe Teach your emplyees, good browsing habits, what phising  is  or social engineering, and whats acceptable for work browsing and sample sites…… It may be years before major company realize that there internet policy is failing due to people circumventing there security, which is a Big problem that no one seems to realize, so Let me tell you some interesting ideas to circumvent your employers draconian internet policy……………… There are a few different ways to get by there security, depending on what is in your way. Most company uses a Proxy to allow people to access to the internet which usually have some sort of login, some use a Web filter software added to the proxy to allow you access to a few sites that the company feels you need access to, others use just the filter and some use something called a transparent proxy or gateway that has some sort of filtering software, there may be others ways for security to impede on your web surfing. Now for the Good stuff, how to get around your works web security… Remember I do not Support breaking the law or circumventing critical network security or breaking your company internet usage policy…Basically I take no Responsibility for your actions. Read the Policy and understand it because knowing your rights as an employee is your responsibility not HRs……….This is for informational and educational purposes only!
    Continue reading  Post ID 237


  • HalloweenCenter.net project

    I am Currently working on a Google Maps Integration For another Word Press Blog at Halloweencenter.net and hauntedmaps.com, Its Been a Fun project with some great challenges and a great learning experience,

    hopefully it will be completely finished sometime this week with no other issues at hand, but My personal Goal with this project is an easily integrated map with DB support for markers, directions and a unique way of administrating the inputted markers by the users. My idea for this to work is a Unique Link created when the site or marker was put into the DB, after that the person who created the the marker can now go to that link and update certain parts of the entry, like the description and other non critical Data. later this Week I will Post some of the Code and the Basics of how it works, and Hopeful create some reusable Code for your own project.

    but for right now i will be concentrating on getting my themes and my other WP content setup so it looks as Good as other WP sites

    I have to Give a Shout to Leo, he did give me some great inspiration to start up my own site..