Avoiding the Autoclose and Autoshrink Options

Q
In the Microsoft SQL Server 2000 Resource Kit, I read about a procedure that checks all databases for options that you should avoid using. I understand why I should avoid using options such as offline, DBO-use only, statistics off, truncate log on checkpoint, and so on. However, the inclusion of two of the options—autoclose and autoshrink—puzzles me.

Autoclose. Closing a file when it is not in use sounds like a prudent thing to do. Yet I see files opening and closing all the time in the error log in SQL Server, even though I know that I never use the database except for viewing in Enterprise Manager. Does viewing a list of databases in Enterprise Manager make the files open? It makes sense to me to use autoclose on databases that I use only occasionally as import staging areas, and which I access for only a fraction of the time my online transaction processing (OLTP) database is in use. SQL Server Books Online says that the autoclose option is automatically set to YES for the SQL Server Personal Edition and to NO for all other editions. Has this option been included only for the Personal Edition?

Autoshrink. The autoshrink option also sounds helpful. However, would using autoshrink on my import staging areas, where I bring in quantities of data for short periods of time, keep these areas small for backups?

A
Autoclose is available in all editions of SQL Server 2000. The amount of memory you save by using this option is relatively small but might be important on memory-constrained systems running the Personal Edition. However, enabling autoclose for the other editions isn’t a good idea, because every time you try to access the database, the query will be slowed by the amount of load time it takes to mount the database. As for the question about your files opening and closing, yes, when you enumerate a database in Enterprise Manager, you access the database, which opens the files.

Leaving autoshrink on for production systems also isn’t a good practice (unless you really need to), because autoshrink might start when your system is otherwise busy with production work, and slow down the system. However, enabling this option is a good idea for desktop or remote systems that don’t get a lot of DBA attention and whose databases could grow out of control before you detect the problem.

VPN

(Pronounced as separate letters) Short for virtual private network, a network that is constructed by using public wires to connect nodes. For example, there are a number of systems that enable you to create networks using the Internet as the medium for transporting data. These systems use encryption and other security mechanisms to ensure that only authorized users can access the network and that the data cannot be intercepted.

Changing Motherboards

This is not mine so I cannot take credit but Andy-S in the Hardware and Drive Support forum passed this one on to me – a must know tweak.

Before you swap out the current motherboard go to device manager and select the IDE ATA/ATAPI Controller and select your current storage controller. Right click, select update driver and select install from a list or specific location. Click don’t search I will choose the driver to install and select the standard dual channel IDE controller.

This will prevent the inaccessable boot device blue screen. I have done this multiple times on different platforms with no problems.

Also I found that booting the first time with the new motherboard is best done in the Safe mode where XP will install the drivers it needs and at the same time you can install the new motherboard drivers from its CD.

This saved me doing a repair or a reinstall of XP. My whole system came right up and worked great and very stable.

Fighting Unknown Problems

Hardware problems are quite difficult to tackle, worse if under Windows. There was once when installing a software, I accidentally inserted the Audio hardware diskette. Thinking it was harmless, I went on, thinking I can always “undo” everything again. How wrong was I. The next moment I restarted Windows, I got the blue screen of death. Yeah, Windows is very nasty when it comes to hardware.

Find The Culprit
Always calm down. Try to solve the problem yourself before resolving to formatting or sending to your computer dealer. First, know what’s happening and the cause of it. In my case, the installation must have overwrite my old setting and replaced the wrong file. There must be a reason why Windows is acting improperly.

Logging Back On
First, try to log back on. If you can’t log into Windows, don’t panic. Restart the computer. When the text “Starting Windows 98…” appears, press F8. A menu will appear. Choose “Safe Mode” to continue. Safe mode will take some time to load. When you are in Windows, go to Control Panel, System. Click on the Device Manager tab. Find the faulty hardware driver and delete it. Open autoexec.bat and config.sys (both are hidden files in your root directory) with notepad. If the hardware is a CD-ROM or sound card, it will probably write add some lines. Check whether there are backup file (autoexec.bak, autoexec.b~k e.g.) since most installation will back up the 2 important files. If there is, simply replace them with the backup files. If there isn’t, put “REM ” in front of every line that loads the hardware.

Repairing
When you restart, your computer is probably ok, since you have deleted all instances of the hardware drivers. But the hardware isn’t functioning. re-install the hardware drivers, restart and you’re done! If the problem persists, your probably have a system conflict go to the next page for more.

A Quick Solution to Protect Your Blog From Spam Harvesters

Are you tired of getting a ton of spam everyday? I am too but unfortunately there is no solution to eliminate it 100% but there are smart ways to avoid and reduce spam. The method I’m going to talk about is aimed at bloggers and how they can easily implement a preventative measure to reduce the amount and chances of spam being sent to them.

With the popularity and ease of setting up a blog, the number of people blogging increases daily. This is great but one main problem is most of these people aren’t usually educated in proper techniques such as spam prevention.

Did you know that putting your email address anywhere on your blog or website is an open invitation for new spam? Yes, you heard me right. Little do you know that trying to be nice and provide a method for your readers to contact you only causes you more harm than good.

Let me give you an example. The usual way to include your email address on your blog is to use the mailto: tag. This is the case if you use Blogger and any other blogging platform. Unfortunately for you, spam harvesters use “web spiders” to troll the internet and look for email address links on websites and blogs. When they come across your site they will look at the html code and grab your address.

Prevent Spam Harvesters From Getting Your Email Address

The best way to beat spam bots as well as giving your readers a way to contact you is to use a contact submission form. That way your email address is never displayed and a script handles the entire mailing process. This is a great option if you use WordPress but for people using Blogger, it’s not an option.

You don’t know how many Blogger blogs I’ve come across and just rolled my eyes. There it is…their email address listed right on their site. Look out spam, here it comes! So my quick solution to protect all blogs (especially Blogger users) from spam bots is to replace your email address with an image.

There are several sites out there that can create free email icon images for you but I like using this email icon generator site because it provides several cool options. My favorite is the branded email image based on your email host provider.

Here are some examples of email images I created in a few seconds:

As you can see, it supports all the popular email domain addresses as well as an option to create your own custom email address. It even hosts the image for you if you don’t want to copy and upload it to your own server. I recommend uploading it to your Blogger site so you’ve always got it available regardless.

Make sure after you use these images you do NOT turn them into a mailto link. If your email address is anywhere in the html code, spam harvesters will find it. I had a friend that I shared this trick with and he replaced his email address with this image but didn’t remove the mailto link! He might as well of not even used the image.

Damage Control – Where is My Email Address Today?

Ever wonder if your email address is publicly available today? A good test to see what sites publicly list your email address is to just Google it. If your email address is sjobs@mac.com then you’ll see that there are over 500 results in Google which is obviously a bad sign (I hope Steve Jobs has one heck of a good spam filter). There should be zero listings of your email address when you do a search. If not, you should go down the list of sites and ask them to kindly remove your email address because they are just feeding it to spam harvesters!

I usually Google my personal email address a few times a year just as a safety check. Just last year as I was doing my check, I noticed there was one site listing it! I was so mad and immediately contacted the site owner to take it down. It was an article submission site and they were carelessly publicly listing all their users email addresses. That’s just bad business. Eventually they took it down and I told them they should do the same for everyone else in their system.

Conclusion

If there’s one thing to take away from this article it’s to remember to never ever ever list your raw email address on your blog. It’s a guaranteed way to get spam faster than you can say “spam me please”. If you don’t believe me try setting up a new temporary email address and don’t use it for anything except this test. Now paste it on your blog and see how long it takes before you start getting junk email.

I hope the end of spam comes in the near future because just like you, I’m tired of wasting time in my day filtering and deleting junk email. Google or someone, please come up with a solution soon!

If you like this post then please consider subscribing to our eBlog Templates RSS feed. You can also subscribe by email and have new templates and articles sent directly to your inbox