Articles

SEO contest for phrase "used stationary bikes"

Shawn Hyde — Tue, 10 Aug 2010 20:01:00 GMT

The information is here:

used-stationary-bikes

delay function

Shawn Hyde — Mon, 02 Aug 2010 02:47:00 GMT

Example, delay change for onmouseout event,

onmouseout="eventOff=setTimeout(function(){document.getElementById('the-element-id').style.display='';},800);"

Last Resort MS SQL 2005/2008 Database Repair

Shawn Hyde — Thu, 22 Jul 2010 08:37:00 GMT

NOTICE!! BACKUP DATABASE FILES BEFORE DOING THIS, DO IT AT YOUR OWN RISK!

I don't want anyone sending me hate mail because this did not work, however it does work (most of the time).

If you are getting these errors:

cannot be opened due to inaccessible files or insufficient memory or disk space
the log cannot be rebuilt because there were open transactions/users when the database was shutdown
unable to open the physical file
the system cannot find the file specified
error 5120
huge ldf file, restore from backup hangs at 100%
HDD IO maxed out on ldf file during restore from .bak file
how to restore just the mdf

If your getting errors like the above and have tried all other solutions, you can try the following. Be sure to make a backup of your .mdf / .bak file.

In my case I had a database that for some reason created a 600GB ldf file and corrupted itself. While attempting to restore from a backup it would say 100% completed but would continue to run for hours/days. If I stopped the process it would kill the database and not allow me to use it. Here is what needs to be done:

First restore from your .bak file if you have one. example code:

RESTORE

DATABASE [dbname] FROM DISK = N'DRIVE:\BACKUPDIR\BACKUPFILE.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS =10

in most cases this will fix your database, IF this backup hangs at 100% for too long you can do the following:

now using the resource monitor verify that the mdf file is done writing (VERY IMPORTANT) select disk sort by file, check to see that the disk is only read/write to the .ldf file and not the .mdf file. Once the system has stopped writing to the .mdf file do the following.

stop mssql service
go into the DATA folder and rename the dbname.mdf file to dbname.mdfx
start the mssql service
delete the database (IMPORTANT, UNCHECK option to delete backups)
create new database with the same name and give proper user owner access
stop the mssql service
delete the dbname.mdf & dbname.ldf files
rename the dbname.mdfx to dbname.mdf
start the mssql service and wait a minute for the service to fully start before issuing the following command

ALTER DATABASE dbname SET EMERGENCY;

ALTER

DATABASE dbname SET single_user WITH ROLLBACK IMMEDIATE;

DBCC

checkdb ('dbname', repair_allow_data_loss);

.pdf files hosted on IIS 7.5 lock up when downloading in firefox

Shawn Hyde — Fri, 09 Jul 2010 19:53:00 GMT

This issue now has a hotfix however, if you don't want to take a performance hit that this hotfix causes then you can simply do the following to solve the problem with pdf files and IIS 7.5

Open "IIS Manager" on your server
Select your service instace
Select "MIME Types" under IIS
Select ".pdf" then click "edit"
Chenge the MIME type from "application/pdf" to "application/octet-stream"

This will cause the web server to treat the file as a download instead of a pdf application. From IE8 pdf files will open as normal, in firefox it will first download the file in full then open it.

Cannot access IP on windows 2008 R2 server from external network

Shawn Hyde — Fri, 25 Jun 2010 01:23:00 GMT

This problem can occur two way, one is cause by the server not updateing your gateway routers arp tables. You can solve this problem by logging into your router and clearing the arp tables. for instace, on a cisco router your would do the following:

using serial or hyperterminal if available

connect to your router
password: (enter password)
router> enable
password: (enter password)
router# clear arp
router# write mem
router# exit

done.

The other problem is caused when using Network Load Balancing (NLB) on windows 2008 / 2008 R2 Server

For more information on this issue use these links:

http://support.microsoft.com/kb/960916

http://blogs.technet.com/b/networking/archive/2009/01/15/unable-to-connect-to-windows-server-2008-nlb-virtual-ip-address-from-hosts-in-different-subnets-when-nlb-is-in-multicast-mode.aspx

plus symbol "+" no longer works in IIS 7 / 7.5

Shawn Hyde — Mon, 21 Jun 2010 20:29:00 GMT

solution:

add the following to you web.config file:

<system.webServer>

<security>

<requestFiltering allowDoubleEscaping="true" />

</security>

</system.webServer>

Proper iis 7.5 configuration

Shawn Hyde — Sat, 29 May 2010 22:21:00 GMT

App Pool setting:

LoadUserProfile = true

File permissions:

use "IIS AppPool\DefaultAppPool"

Remote Desktop from Windows 7 to CentOS using Xrdp

Shawn Hyde — Thu, 15 Apr 2010 07:58:00 GMT

Install Xrdp on CentOS 5.4

yum install make.x86_64
yum install gcc.x86_64
yum install pam-devel.x86_64
yum install openssl-devel.x86_64
Download Xrdp
- xrdp-0.4.1
Install Xrdp
- go to /xrdp directory in terminal
- make
- make install
Start Service
- cd /usr/local/xrdp
- ./xrdp_control.sh start

Install the old version of Microsoft RDP on a windows XP system or just search and copy from any pre SP3 windows xp install these two files and place them in a folder.

mstsc.exe
mstscax.dll

launch mstsc.exe and connect to your Xrdp server.

Errors installing SQL Server 2008 on Windows Server 2008 RC2, Solution

Shawn Hyde — Sun, 24 Jan 2010 22:27:00 GMT

There seems to be a problem when installing SQL server 2008 on a windows 2008 RC2 platform. Generally it will get stuck, hangs at "Install_sql_is_Cpu65_Action:Write_NativeImage_64" or another place about 3/4 the way through the install process. In some cases this may be a permissions issue and others media read/write issue.

Best solution for this is to copy the entire contents of the install media directly to the HDD and run the installer directly from the hard drive as the administrator directly from console and not from RDP. This seems to solve the problem in all cases so far.

A Solution to the BOT Problems in Most MMO's

Shawn Hyde — Wed, 26 Mar 2008 02:36:00 GMT

Solution to in game botting for many MMO's:

Players suspected of botting may be right clicked and then "report as botter". Next time the player loots an item they will be asked to type in a CAPTCHA code to verify they are not a botter. If the player fails to do this within 60 seconds or logs out they will be forced to a "Gladiator Ring" where if they logout the character will remain on an auto pilot for 30 minutes and in a baron mode where item drops double for every death. At any time while they are in this ring as long as they did not disconnect they may enter the CAPTCHA code and then allowed to exit the ring. Each time they are sent to the ring they will have +1 "Gladiator Count" added to their account for every 1 point they stay in the ring for 10 minutes before the system will let them logout or exit the ring. The bot accounts would be provented from picking up items while in this mode.

Gladiator Count Resets could be purchased from a cash shop for those that decide that botting is a bad idea and they will not be doing it any longer.

Normal players could buy Gladiator passes that will allow them to enter the ring in a non baron mode where bot accounts are and will be free to loot anything that drops from those accounts.

At this time this idea is Copyrighted and you must ask to use this idea in a game design.

Comments?

Driving Traffic to your Business Site

Shawn Hyde — Sun, 06 May 2007 01:59:00 GMT

I've recently put together a Minnesota small business community site where small business owners can write articles that feature their own business, communicate with other business owners in Minnesota and develop long lasting partnerships. My goal for this site is to help Minnesota businesses grow and strive in todays economy because a healthy Minnesota business economy is good for everyone.

Here's a list of a few benefits this site offers to business owners and their businesses.

Put your business in the spotlight with media articles for sales, new products, new services, employee changes, management change, grand opening, new look, special events, company meetings or just about anything that highlights your company because the more links and news featuring your business and site the more clients will be driven to you.
Communication with other business owners in Minnesota will help you to forge long lasting and profitable relationships with other businesses. Working with other business owners will provide you and them with increased customer traffic over your competition.
Drive traffic to your site by creating articles and posts on this community site, every link from another site is like a vote for your site to the search engines and the more votes the higher your site is valued. Google calls this "Page Rank" and is the first search engine to implement this sort of rating system.
An image is worth a thousand words and so is your business. What I mean by this is posting a few photos of you business, staff and products in the gallery section can go a long ways in showing what you do. You can even do things like post coupons and fliers in the downloads section.

Eventually I'll be adding other things to this site like a free classifieds section, community calendar and more. Right now the site already features some pretty cool stuff like local news, open discussion forums for all of Minnesota, free personal galleries to upload photos for your business, free file uploads for the community, and your own personal blog/news section.

To get going with http://downtown.mn all you need to do is click the "join" link at the http://downtown.mn site.

Good luck with your business ventures and remember good communication is the key to success.

The Two vote system, or shared presidency!

Shawn Hyde — Sat, 05 May 2007 16:52:00 GMT

As America seems to be falling into more and more political mess every year I've come to the conclusion that the way we are currently running our government is not working. The presidential position is not working so I've come up with what I think may be the perfect solution.

If we as Americans change to a two vote system, where every American has two votes. This way people can vote for who they really want and another vote for who they think they need to vote for in order to keep the other person out of office as thats what it seems like most of the voting Americans have done these past few elections. I hear many people saying how they would vote for ____ but don't because they want to make sure ____ doesn't win. So we have our two votes, tally all the votes at the end. Who ever has the highest is president and who ever has the next highest is vise president. It could be as simple as that.

or

Another solution that I thought may also work to place some independent parties in office is to take the top three and make them all work as equals where every decision they make is a 2 out of three and make them share the over $600k/year that a single president would be paid for the rest of their life.