Kingpin Tech Technology ideas from the front lines

18Aug/100

Preparing for Graduate School

Posted by: David

So, you're thinking about graduate school...

Some of you might find yourself about to graduate with your bachelor degree and you are thinking what is next, are you really ready for the world?  Others might be thinking it is time to get the extra education they might need to advance from their current position.  An even less likely option is that you are still in your early years of college, or just searching the internet looking up graduate school as a high school student.

Things to consider

First of all, you need to know when to apply for graduate school.  With some schools it can be as early as Jan. 1 for the Fall semester or as late as August for the Fall semester.  If you already have a school in mind, check their deadline for applications and make sure you haven't already missed it.  It is best to start working on your graduate preparation in your first semester of your last year in undergraduate if you are going straight to graduate school.  If you plan on working first, wait until after you graduate to begin preparing, you really don't need to rush anyway but since you will be taking a test it will be important you are still sharp from school.

When looking for a graduate school the most important thing you can possibly look for is that the school offers a program you want to take.  Take your time when looking at schools, don't just browse what programs are offered by the schools, but really look deep.  Look at the classes required by a program you are interested at a school, this can differentiate two similar programs.

The next thing to look for is either cost or location.  It depends on what you want more, or if location is important or not.  If you are looking for a school that is close, it might be worth paying more for.  Also, with more graduate programs offering online programs location is becoming less of an issue.  If you are taking your graduate degree online, it will be okay to find a school further away but keep it in a few hours driving distance because you never know when you might need to make an emergency trip to classes, or for paperwork.

You will also want to look at the admissions requirements for the school you are looking at.  This will be a great way to determine how your chances will be with enrolling at the school.  The best way to get accepted into graduate school is to have great undergraduate grades. For most schools, there is a minimum score required to enter.  This score is typically based off a calculation where your undergrad GPA and your GRE test scores are given a multiplier and then added (250x + y = acceptance score, for example).  If you have a 4.0 undergrad GPA you are going to be 25% closer to being accepted than someone who only has a 3.0 undergrad GPA.

Other things to consider...

  • Admission Requirements - These are often looking for specific courses and degrees.  If you don't meet these you might be required to take introductory courses.
  • Professors - ratemyprofessor.com
  • Administration (if you are familiar with them)
  • Scholarships and grants - look for available scholarships or grants before applying
  • Search for reviews of the program, or seek out people for their opinion on the school
  • Course settings - Will you be required to attend classes or will they be offered online?
  • Thesis or Project - While this isn't necessary to worry about at first, consider what you would be willing to do.  Most schools offer the ability to do a group project or write a thesis in order to graduate.

Now what do I do to apply?

  1. Continue working on your undergraduate degree - don't start thinking ahead!  Or don't put your work aside if you are already a full time worker.
  2. I suggest that you get a study book for whatever test you need to take about a month before you are scheduled to take your test.  The Princeton Review typically has good study material.  These books don't just give you an idea of the material that will be covered but will also give you hints and tips on how to take the tests, such as methods to save time and score higher!
  3. Schedule your GRE, or other required graduate admissions test such as the GMAT for at least 2-3 months before your application deadline.  Give yourself more time if you think you might need to take more than one test in order to be accepted.
  4. Fill out your FAFSA if you will need financial aid!  This is crucial!  Do not use sights like FAFSA.COM that charge money.  MAKE SURE TO USE HTTP://WWW.FAFSA.GOV !!!!!
  5. Make sure and study for your test!  These tests are not easy.  Use the study book you bought, or at least use online resources to study.  It is important you do this plenty for the couple of weeks leading up to your test.
  6. Get a great sleep the night before your test.  Eat your breakfast and arrive about an hour early for your test with your study material.  Study just a bit more before you go in - it could only help.  Also if you get lost finding your testing place the extra hour will come in very handy.
  7. You will receive your scores in about a few weeks.  As soon as you receive your scores you can start applying to schools based on what schools your scores and grades will allow you too.  Not many schools would be willing to take someone who has scores or grades below their minimums.  Do not hesitate to apply, it is plenty OK to apply to graduate school several months in advance of the application deadline.
  8. Once you submit your application you should immediately gather other materials that might be required by the school for your application such as your undergraduate transcript, your letters of recommendation, career plan or even your portfolio.
  9. Now it is time to wait to be accepted.  If you don't hear anything before July 15th for the Fall semester you really should call the schools that you applied to and check your application status.

My next post will be on what to do once you've been accepted.

10Aug/100

Dameware host actively refusing connection fix

Posted by: David

The issue?

You can't connect to a client using dameware because it is actively refusing your request.

Resolution

Go into the device manager and delete the dameware mirror driver which is listed with the display drivers.

If that does not work consult dameware support to make sure you don't have a network issue causing the issue.

23Jul/100

When to pull out of dying technology?

Posted by: David

When is it appropriate to give up on a technology that is still being used?

The answer obviously can vary, but it is important to choose a certain way to look at things in this situation.  For this writing I will consider looking at when to stop dealing with a technology from the consumer standpoint.  It is pretty simple for Company's to decide to change their technology (Not enough ROI? Ok, lets do something else).

What is there that will replace what you have?

You don't necessarily need to be an early adopter to recognize a new technology that will surely catch fire.  Pay attention to websites that pride themselves on being the first on addressing new technology.  (Gizmodo and Engadget are fairly adept at this).  You will never be certain what technology will catch fire next and become the new standard, but being aware of it could certainly help.  Staying up to date with the latest in technology news will allow to be aware of any new ways of doing what you currently do.

Ok, so you've seen something that can replace something you already own in the future - how do you know when to quit investing in your current setup and move into the newest technology.  Here are a few keys to consider.

  • Make sure the new thing offers considerable benefits - there is no reason to move horizontally with your technology
  • Make sure the new thing will work as intended - you don't want to invest in a new technology that isn't polished enough to work to where it does the functions it was intended to.
  • Make sure the new thing will become a standard - ever bought an HD DVD player?  If you have I bet you feel rather foolish.

There is no way to tell if a new technology will catch on and last for a while, because newer technology is already being worked on to replace it.  Let's take an example.

Example: Blu-ray media

Blu-ray media offers the ability to offer High Def movies in a physical format.  Many, but not all people will consider HD quality a substantial benefit, and it also has already proven to work as intended, and also it has beaten out HD DVD to become the standard high capacity portable disc media for movies.  So, why would we consider dumping blu-ray already?  I mean I just bought my first PS3 last year, I can't afford to buy more equipment to watch my movies!

Well, there are already efforts to develop more advanced lasers to store more media on a disc than even a blu-ray.  These new media discs could possibly contain an entire collection of movies in HD.  Well, if that is the case you would probably be tempted to go ahead and buy this new laser disc reader/player as soon as possible right?  Well, no.  You should definitely wait until that technology becomes a standard for the industry.

Things are different in today's world though.  You don't have to choose between CD, or cassette.  Now you can choose to listen to your music in a variety of ways digitally, and we are just stepping into the world of streaming movies.  While this isn't directly in line with the past progression of technology of playing movies (VHS->DVD->Blu-ray on physical media), it takes a step to the side and will start a new progression of technology.

Part of knowing when to quit using a technology is to know when it is becoming obsolete.  Blu-ray is by no means obsolete yet, but very well could become replaced by most homes with streaming movies soon.  With such improved bandwidth availability to most homes, it will become easier and easier to view your movies using a completely different technology.

Personally, I think in 3 years most people will be watching HD quality movies through streaming services such as Netflix.  Blu-ray will still be a great choice for watching movies on the go, such as our current portable DVD players.  As cell phone coverage and capability increases though and data becomes more available wirelessly there will be less and less a need for physical media.  Eventually we will all be able to watch our movie collection from anywhere in the world.

24May/100

Video: Share files between Windows 7 and your virtual Windows PC

Posted by: David

What you are trying to accomplish

Share a file from your Windows 7 computer to your Windows XP virtual machine (or other computer).

2May/100

Windows 7 Awesome Tip : Preview Pane

Posted by: David

Enable your preview pane

With Windows 7, you probably aren't used to all of the changes.  Perhaps one of the best things you can find in Windows 7 would be the preview pane.

While you are in the file explorer going through your long list of files whether it be images, code, word docs, or even videos hit ALT+P on your keyboard.  Now, next to your list of files or icons for files you can see a preview of the file you have selected in the file explorer.

Not all file types will allow you to see a preview, but the video preview will even allow you to watch the video in the preview pane.

24Apr/100

Another great Firefox add on: Extra Bookmark Rows

Posted by: David

So, you want more rows for your bookmarks?

There is an add on for that if you are a firefox user (and why wouldn't you be?).  This add on when installed will automatically create another row for your bookmarks whenever you run out of room on your current bookmark row.  This comes in handy when you don't want to fool with organizing your bookmarks in the bookmarks drop down menu.

If your lazy, like most people - this add on is for you.

If you want to keep your complex organizational system for your bookmarks in the drop down menu, don't worry about it.

How do you get it?

Go to https://addons.mozilla.org/en-US/firefox/addon/6937

From there just click on + Add to Firefox, and it will download and install for you.

When it is done installing it will ask for you to restart Firefox, go ahead and do that so you can start using your now extended bookmark rows!

23Apr/100

How to use 404 errors to make a URL shortener

Posted by: David

404 errors can be used for more than appologies

A project I created and implemented about 6 months ago was a simple URL shortener.  I didn't go looking on how to make a URL shortener, I thought of this on my own, and while others might have done this before I was able to create and master this system.

How you can do it

  1. Make sure you know a little about PHP and MySQL, these two things are crucial.
  2. First, design a database that can hold a list of url's that people will enter, and also give each one an id.  In the most simplistic setup you should only one table in your database with this information.
  3. Now, set up your site to allow a custom PHP page for the 404 error page.
  4. Write the PHP for your 404 page to get only the filename, or the part after the last forwardslash / on the url, for example it would be "touoik" if the URL someone entered was http://www.fake.foo/bar/touoik.
  5. Now after you can put the file name into a string variable, use this to search your database for the id of the url.  Since this should be set up as a auto incrementing primary key you will be having numbers as the file name, and they should correlate with the id of a certain URL.  Return a URL, or error with your query, then use some HTML to forward to the URL your query returned.
  6. The last bit is to create a form that will allow people to enter their URL to submit it to the database.  The best thing to do with this form is to make sure that it delivers you a valid URL.  Google some ways to find valid URLs with PHP.

It's that simple, but you can do so much more

Some simple ideas that I used in my URL shortener I made with 404.

  • Limit an IP address to only making a certain number of short URLs a day.  Do this by adding another column to your URL table in the database and editing your 404 query to check the count for a particular day.
  • Another option I gave users was the ability to enable a preview of the URL someone was being forwarded to.  To do this I added a bit of code when someone submitted a URL to check for the title of the webpage that the URL was for, then stored that in the URL database.  Then on the 404 page I set up a check for the query to see if it was enabled for previews, if so I would put a delay in the HTML forward and display the page URL and give the person viewing the 404 the option to go back.
  • Click tracking was another feature that I had enabled.  For this I created another database table with the short URL primary ID as the foreign key and set up columns for the click ID as the primary key and the date clicked, and IP from as the unique attributes for the click.  This was a little more complex but I added another section onto the site that allowed someone to input the short URL, or file name and they could see the history of the short URL click.
  • Private and secure forwarding was provided by setting up the 404 page to check to see if passwords were enabled for the short URL.  If so, I would have the 404 site show a form to submit the password.  When submitted it would check for the password and URL ID.  If both matched, you would be forwarded.  I also set up the click history section to allow someone to make their URL history private.
  • Limited redundant URLs to save space in the database.  I used the submit form to check the database to see if a public short version of this URL already existed and if so I just gave that person the same short URL that was already in the database without creating another entry.
  • Created lots more entries by using a higher base counting system and converted the URL ID's into these higher base numbers to provide shorter short URLs.  For example, 10 would be "A" and 11 would be "B", which is similar to other base systems, but I used a base system that extended all the way to using all digits and capital and lower case letters.
15Apr/100

Adding a shortcut to file explorer when opening or browsing to select files in Windows 7

Posted by: David

What are you trying to do?

You are trying to get a network location on your file explorer as a button that you only have to click on once to find the location.  This area is known as my places in Windows XP ( also Favorites in Windows 7) and is very good for creating shortcuts to network drive locations where you might need to browse through several folders every time other wise.

Just look, this is how you do it

  1. Find the location of the folder you want to link.
  2. Drag and drop the folder into the left bar into the favorites area.

Now your folder is linked in the favorites or my places area on your file browser whenever you want to select a file with any program!

14Apr/100

Video: Show the developer tab in Office 07 (Word and Excel)

Posted by: David

How to show the developer tab in Office 07.

  1. Click on the Office button
  2. Click on Word/Excel Options
  3. Check the Show Developer tab in ribbon option
  4. Hit OK to apply

What is the developer tab

The developer tab is seldom used by casual users of Office products which is why it was removed from the toolbar by default.  However those familiar with macros and security options with Office files are very familiar with the options provided by the developer tab.

1Apr/100

Using spiceworks to see old comments from a particular person and or from a particular day

Posted by: David

Possible problems that might have you thinking about finding old tickets

  • Someone is trying to see if they worked on a particular day
  • You are trying to see what anyone said on a particular day
  • You are trying to find out what someone has been saying
  • You want to know what Public or Private comments someone has been using in tickets

Solution:

  1. In spiceworks click on the reporting tab
  2. Click on New Report
  3. Make sure "Build this report using SQL" is checked
  4. Type in the following code....

To find comments from someone on a particular day

SELECT tickets.id as Ticket, comments.body as Note, strftime('%Y-%m-%d %H:%m', comments.created_at) as Day FROM users, comments, tickets
WHERE tickets.id = comments.ticket_id
AND tickets.created_by = users.id
AND comments.created_by = '12'
AND strftime('%Y-%m-%d', comments.created_at) = '2009-09-09'
ORDER BY tickets.id DESC
LIMIT 0, 500

The code above will find ticket comments by (users.id='12'), that were created on 9-9-09 (strftime('%Y-%m-%d', comments.created_at) = '2009-09-09'), and they will be displayed in descending order by the ticket number an limited to a number of 500 results.  To find the comments made by a particular person you will have to find their user id in the database.

To find comments from anyone on a particular day

SELECT tickets.id as Ticket, comments.body as Note, strftime('%Y-%m-%d %H:%m', comments.created_at) as Day FROM users, comments, tickets
WHERE tickets.id = comments.ticket_id
AND tickets.created_by = users.id
AND strftime('%Y-%m-%d', comments.created_at) = '2009-09-09'
ORDER BY tickets.id DESC
LIMIT 0, 500

If you notice, this is the exact same code as before, but without the users.id='12'.  The code above will find all comments dated 9-9-09.

To find only private comments by someone on a particular day

SELECT tickets.id as Ticket, comments.body as Note, strftime('%Y-%m-%d %H:%m', comments.created_at) as Day FROM users, comments, tickets
WHERE tickets.id = comments.ticket_id
AND tickets.created_by = users.id
AND comments.created_by = '12'
AND comments.is_public = 'f'
AND strftime('%Y-%m-%d', comments.created_at) = '2009-09-09'
ORDER BY tickets.id DESC
LIMIT 0, 500

The code above is the same as the first code but with the addition of AND comments.is_public = 'f'. This means you will have all ticket comments by a particular person (12) on a particular day (9-9-09) that were false as to being public (aka private).

To find only public comments by someone on a particular day

SELECT tickets.id as Ticket, comments.body as Note, strftime('%Y-%m-%d %H:%m', comments.created_at) as Day FROM users, comments, tickets
WHERE tickets.id = comments.ticket_id
AND tickets.created_by = users.id
AND comments.created_by = '12'
AND comments.is_public = 't'
AND strftime('%Y-%m-%d', comments.created_at) = '2009-09-09'
ORDER BY tickets.id DESC
LIMIT 0, 500

To find the public comments just change the comments.is_public = 'f' to = 't'.

Tip for success

Don't limit yourself to the code that I have above to find the information you are looking for.  Open up SQLlite and try playing around with it and adding different parameters to the query's.

Also, if you want to find your users ids easier than manually opening up your database just make an SQL report with the following code.

Select * from users

This will list all of your users with all of their information.  Find the one you want to use and insert their user id into the code I provided above.