All posts by Jason Geiger

I'm a guy. I'm an awesome web developer, database administrator and project manager. I have used MySQL, Oracle and PHP in the past but actually prefer Microsoft products. (Please don't kill me LAMP lovers!) They just seem more simple. Also you get them for free if you just show up to the product launch!!! :) This is just a casual blog where I can put random stuff along with bugs that I had hard times resolving.

Remove URL from wordpress excerpt

If you have URLs showing up in your excerpt simply add the following somewhere in the top of your theme’s index.php file.

function RemoveURL($string)
  return preg_replace(‘/\b(https?|ftp|file):\/\/[-A-Z0-9+&@#\/%?=~_|$!:,.;]*[A-Z0-9+&@#\/%=~_|$]/i’, ”, $string);
add_filter(‘the_excerpt’, ‘RemoveURL’);

This will remove 99% of the URLs in your excerpts.

SQL Server extremely slow to restore

I recently had an issue where restoring a SQL Server database would take forever just to load the restore window.  Right clicking a database, going to Tasks –> Restore –> Database would take MINUTES just to load on a good day.

While I have upgraded and patched the server it has been running since 2008. (You have to love VM Ware allowing you to update hardware and not reinstall).

SQL Server logs all backups/restores to MSDB.  You can query all the information from the following system views.


In my case because we have been running so many databases for so long I had over 1,000,000 records in msdb.dbo.backupset.  Any time that I used SQL Management Studio to restore a database, or if you deleted a database and instructed it to delete the backup history too, it would take FOREVER.

I created a simple job that deletes backups history over 90 days.  Just change “90” to however many days you want to delete and BLAMO everything is good again.

SELECT @CutOff = DATEADD(day, -90, GETDATE())

Luxor Hotel Deals

Luxor Las Vegas
The Luxor in Las Vegas is a great mid-tier hotel in one of the most perfect locations.

…or you can click here to skip the reasons and go straight to the 30% off Luxor link.
(exp. 6/8/14)

There’s a great pool, spa, salon etc…  Have poolside drinks next too a humongous pyramid or get a manicure and massage at a top rated salon.  There are enough ways to be pampered inside so you don’t have to wander out unless you choose to.

I consider gambling at Luxor to be mid-tier.  It’s not too expensive and not too low brow.  However Luxor is in the perfect spot if you want to go high or limit.  To one side of Luxor is Excalibur which is on the low end with plenty of $5 tables and penny slots while still managing to be nice.  To the other side of Luxor is Mandalay Bay which is very high end but still extremely friendly.

Between Luxor and Mandalay Bay is a great shopping center filled with specialty shops, restaurants and bars.  Perfect for splurging a little bit if you happen to win a little (or a lot) of money.  You never even have to go out in the blazing sun as this fun shopping corridor is all inside and climate controlled.

There are too many shows to list here in Luxor and the 2 connected hotels.  New York New York is very close as well and extremely walk-able in even the highest of high heels.  Everything else on the strip is a 5 minute cab ride.

You will love your stay!  One of the few places that you can overlook the entire casino from the hallway outside your room.  Great restaurants, shows, gambling and comforts await.

 Click here for a 30% off Luxor Coupon

Kinps iPhone Backup Battery

Kinps iPhone 5s Backup BatteryThe KINPS iPhone Backup Battery is pretty good for the money.…  It functions exactly as advertised.…  Unfortunately for this device, unlike those from UNU and Mophie is just that, only a “Backup Battery”.…  This is not a stylish case that will always keep on your phone.…  The KINPS backup battery is a basic, rough case that perilously attaches to your iPhone and iPhone 5s.

We might be coaxed into keeping it on our iPhone, the inner fashionista in me just can’t do it do the general look.…  Also the haphazard way the case barely holds the phone definitely will prevent you from keeping this in your pocket and will ABSOLUTELY make you think twice before taking this lumpy mess through airport security.

While we usually like our reviews to be more uplifting, know that if you only have $25 to spend and desperately need more juice in your phone this will get you through in the short term.…  However UNU and Mophie might be a better idea after this one prematurely breaks and you don’t have the phone charge to call their support line.

We are currently putting out calls to UNU and Mophie to show you what a good looking iPhone case with battery extender looks like.…  Hopefully we will hear from them soon and have a more indepth review for one of those two products up here for our faithful readers shortly.

Browser Link Error

Instead of you chasing ghosts down the road I thought I’d share this.

I recently installed Visual Studio 2013.

While debugging my very first app I got some weird errors in VS2013 that cause browser freezes and slowness in all browsers.  Firefox was nice enough to tell me that some script was causing an error and had something to do with "browserLink:37". 

browserLink Error


Long story short, in VS 2013 a thing called “Browser Link” is enabled. I believe this allows for more in depth debugging however it caused my forms to be behave very badly. You can disable this as shown in the screenshot below.

Browser Link Error

Fix iOS Weather in Notification Center

iOS 7 Weather I love iOS 7 but I’m left feeling like a dog who’s had his water dish moved.  While most of the changes are great and some will be great after I’ve gotten used to them, there is just one tiny little issue that is affecting me.


Normally my day starts with my iPhone alarm going off.  At that time I pick up the phone, turn off the alarm and swipe down to see how the weather is going to be that day.  To my surprise it was not there at all in iOS 7.

While not everybody is having the same problem of “No Weather”, everybody else seems ticked that it now shows less information than before.  No extended forecast, no happy smiling little sun.Dear Apple, please change this “WeatherGate” type scenario.

iOS 7 Weather Notification9:34am UPDATE: I just now had iOS 7 decide to put the simple weather blurb back into notification center.  I fixed it by doing the following…


iOS decided to do this all on its own.  I have one of the very first 4s iPhones so maybe mine is just hitting a wall and it’s time to upgrade.

While I hate advising people to just “Wait” and have the weather automatically return to the notification center, this may be the only way until Apple decides to put a weather widget back into the Notification Center.

How to Background Check Online Dates for Free

Before I show you some tips and tricks to finding more information about somebody online, you are accepting by reading this article that you will only use these tricks for good ethical reasons.  Nobody should ever use these tricks to stalk, harass or invade people’s privacy.  These tips are also not foolproof but odds are more likely than not that they can work for you.

Whether it’s, eHarmony, okCupid, JDate, Christian Mingle, Plenty of Fish or any newer or older sites there comes a time when you want to know more about the “Real Person” behind their online profile.  With sites like okCupid or Match that allow you to put fake names, things get a little harder because you first have to find out their first name, however as long as you aren’t in a giant city all that you may need is…

  • First Name
  • Age
  • City

You then take this information and type the following into Google. intitle:jason intitle:"buffalo, NY" 35

Depending on how common the name is, you may or may not get a lot different names.  We don’t care about the actual pages on  We only care about the first/last name combination. 

At this point you have a few or several last names to work with.  You then will want to type each one into Facebook or into Google Images and see if a photo pops up of the same person in the profile.  Doing a Google Image Search for “Jason Geiger Buffalo, NY” pops up with my Google Plus Photo seen here.


You can now search Facebook, Pinterest, Google Plus and the internet in general looking for unlocked profiles.  My favorite is to see if a potential date has mutual Facebook or Google+ friends and check their references.


Searching with only a Photo

Now let’s say that all that the above method did not work.  Well there’s a small chance that if all you have is a photo of a person, Google can still help you out by doing an image search.  Here’s the steps.

  1. If you don’t have Google Chrome, get it.
  2. Launch Chrome and get the Image Search Plugin.
  3. Right click a photo from the person’s profile and click “Search Google with this image”.
    1. image

With any luck you will be able to find information about the person and their acquaintances (and public criminal record) with this method.

No value exists with that name

As we roll out Windows 7 at work we have an application that initializes new computers.  It is installed and runs every time at startup until it runs successfully.  Then it deletes itself from the registry at (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run).

It worked fine on our old Windows XP machines but failed but would never delete the key on our Windows 7 installs.  Every time I ran I would get an error stating “No value exists with that name”.  Searching the internet for that term came back with next to nothing.

I was racking my brain just assuming that it must be User Access Control (UAC) interfering with me.  While that might be the case for many programs, the real issue was that the program was running in x86 mode.

Platform Target

Change the “Platform target” to “Any CPU” and the key then deleted fine.

How To Typing

How To Typing

Ever since I launched Keyboard Bumps I have had a need to explain to some people how to type or how to type better.  So I have launched How to Typing!

How To Typing is a How-to site devoted to typing.  It has no ads and gives tips and overview on how to get better at typing.  How to Typing will go over beginner typing, advanced typing and even typing on tablets and smartphones.

Screen typing is going to be a huge part of the world going forward as people switch from expensive laptops and desktops to less expensive tablets.  Typing on virtual screens is the future.

Check out How to Typing and I bet you will get a typing tip that will let you focus more on typing with less mistakes.

Typing isn’t going away any time soon.  So catch up on typing lessons that you may have forgotten.

Random Typing Facts

  • While typing, your left hand  56% of all the work.
  • The longest words you can type with just one hand in the proper position are “stewardesses” and “reverberated”.  These are typed with the left hand and are both 12 characters.
  • The longest words you can type with the right hand are “lollipop” and “monopoly”.
  • Ironically the only 10 letter word you can type using the top row is the word “typewriter”.
  • The world’s fastest typer can type more than 200 words per minute.
  • “Touch Typing” is recommended for people with no hand problems.   For disabled people, other typing methods include “Hunt and Peck”, “Buffering” and “Thumbing”.