When is it SQL Server RAM Upgrade Time?
How do you know you need more RAM?
Take a look at your Buffer Cache Hit Ratio, ideally you want to be at 95% plus.
via Less Than Dot - Blog - The SQL Server Memory Leak Confusion.
Sander van Dragt's Notes
-
-
Subversion repository creation rule
Do not use capitals for repository names! Because when checking out a working copy you will have to specify the respository url case sensitive. Failing to provide the correct case sensitive name result in things might appear to work but you might get access forbidden messages for certain users in some point, and other mysterious errors, such as the svn commit error below:
access to '/svn/project/!svn/act/c50e0f11-eec3-154a-9695-20ec222ad7f3' forbidden
-
InstaPlay 1.0
As a hobbyist music producer, I have a lot of samples of sounds. As I have decided to start organising these, I needed a quick way to fire off samples in wav and mp3 format through Windows Explorer.
So I created InstaPlay. This is a simple sound player. To install it simply unzip it in a directory that's in the path, and then associate wav and mp3 files (and whatever else you want to use) with it. It also has a few features:
- Just double click or run a soundfile to hear it play.
- Nice speaker icon in system tray while a sound is playing. Double click it to quit InstaPlay and stop playback.
- Run another sound file to switch playback to that instead.
This program will help you categorize more efficiently as you can move the sound that's being played without pesky 'file in use' prompts.
Download Info Download the latest version (v1.0 - updated 14/oct/2010)
-
Quote of the week
I'd post the other two examples, but I wouldn't want to take all the fun out of reading the manual.
Source: stackoverflow.com
-
Resume RSync until finished
I noticed a backup of ours did not finish and that the temporary file rsync uses was still listed. A quick google search indicated that rsync had lost its connection. Thanks to Ian Young's article on the subject rsync now resumes when cut off and hopefully the backup will complete now.
-
Progressing your life
Lesson of life: Instead of wishing you were at a certain point with your life, think about something manageable today that you can do towards that goal.
-
Windows Integration Authentication Scheduled Web Page
This is a problem I have been trying to solve for some time on and off. Under Windows/IIS I need to periodically run a webpage that uses Windows Integrated Authentication. This rules out most of the VBS scripts and WGet solutions. I got it to work today using a batch file like below. Just add it as a scheduled task.
start /min "C:\Program Files\Internet Explorer\iexplore.exe" <a href="http://domain.com/webpage" target="_blank">http://domain.com/webpage</a><br></br>PING 1.1.1.1 -n 60 -w 60000 > NUL<br></br>taskkill /F /IM iexplore.exeThe two most important parts is starting the application with the 'start' command (windows 2003 server in this case) so that the batch file will continue while the program is running. We then use a trick by pinging every second for 60 seconds (1 minutes) to wait for the webpage to finish what it's doing. Finally we kill off the original program.
-
[Plugin: WP List Files] Fix: links don't work when blog not installed in root of site
Update: This plugin is no longer available.
We’re using a customized version of WordPress as an electronic portfolio for students and we are using WP List Files to make documents available on the ePortfolio. Unfortunately the WordPress support forums seem to hide my topic (possibly because it's an older version) and the author is no longer supporting the plugin.
Due to time constraints, these plugins are no longer supported and will not be updated, ever! Unless you know what you’re doing, I strongly discourage using these on a production blog since they have not been tested since WordPress 2.5.
The plugin didn't work in version 2.0.3 that we are using because the wp_enqueue_script function does not exist in this version (the codex page does not say when this function was added). Anyway after manually adding the JavaScript to the theme's head element the plugin almost worked fine - links didn't take our folder structure into account.
works: joeblogs.com</dir specified in post or page>
doesn't work: allblogs.com/blogs/joebloggs</dir specified in post of page>
Fix it by replacing line 231 to read:
$files .= '
- wpurl').$item['link'].'">'.$itemName.''.
The hyperlink created for the item didn’t have the complete blog URL in it. It assumed the blog was installed in the root of the domain. After this fix the plugin works fine.
-
Amasan's WordPress Tweak Roundup
Made few tweaks to improve the blog in preperation for several drafts I'm currently working on. Here's a quick rundown for everyone that's interested in the wordpress blog platform.
- Related Posts should show up to 5 related posts without too many false positives on single article pages. I like how this plugin scores posts on relativity and that I can set it to show nothing when no posts are related, which keeps the interface clutter to a minimum.
- A single easy recognisable block of Google Adsense adverts has been added to single articles. You won't see it if you have Adblock Plus installed like myself, but it should give helpful suggestions on articles with a single subject and support hosting costs in the process.
- Template tweak: Moved post-meta-information from under the title to the footer (tag/cat info) so that the header is better connected with the body of the post. There's enough clutter on other sites.
- I've visually combined categories and tags underneath articles. Category are used for url purposes and tags to facilitate cross linking of subjects. No need for two lists.
- I added a tagcloud to the site so you can browse the site and discover some other articles. I don't think browsing by time and month is useful to many people so that's been removed from the site. The only concern I have at the moment is that the cloud would grow to too big a list, so in the future I might just show the top 7 tags used. For now that's not a problem.
- PHP Speedy. This is the most important reason why the site is so snippy.
There's more but I'll save them for another time.
-
Wordpress for iPhone Impressions
I'm currently testing the Wordpress iPhone app (WfI). It's great for a free app! However I noticed a few things that need to be polished:
- It didn't retrieve the blogs categories from my blog and the category I added to this post wasn't saved.
- The interface is a bit slow on the frontpage when clicking an option it doesn't turn blue immediately
- There's currently (18th June 2009) no way to edit the blog's details after setting up, or ability to remove it that I have found. I changed my user's password but I cannot change it in WfI! An Edit button on the blog selection screen would definately help in this case. I'll have to remove the application and redownload it - maybe that helps.
Still it's a great way to do some writing while not at a desktop and I appreciate the offline mode for iPod Touch users.