In Task Manager I noticed that sqlservr.exe is using a lot of RAM. Here's how to restrict it.

First you will need to figure out which instance of SQL is the problem. In Task Manager, go to View > Select Columns, and tick PID. Now you can see the PID (Process Identifier) for the SQL instance we are interested in. In my case the PID was 2388.

You can use tasklist /svc to get more information about what these processes are. If you pipe it through the "find" command you will quickly see which SQL instance has the PID we found earlier:

tasklist /svc | find "2388"

In my case it was MSSQL$SBSMONITORING

Now we use the following commands to restrict the amount of memory this instance can use.

osql -E -S YOURSERVERNAME\sbsmonitoring  [hit enter]
sp_configure 'show advanced options',1 [hit enter]
reconfigure with override  [hit enter]]
go  [hit enter]
sp_configure 'max server memory', 100 [hit enter]
reconfigure with override  [hit enter]
go  [hit enter]

Check the Task Manager again, the memory should be dropping.

How do you restart the terminal services service? In MMC, it is greyed out.

The official word from Microsoft is: "The Terminal Services service is an integrated part of the core OS in Windows, that's why it can't be stopped or restarted as most other services (it is grayed out)."

But try this, it sometimes works...

1. Open a command prompt
2. Type in: tasklist /svc /fi "imagename eq svchost.exe"
3. This will list the different instances of svchost.exe and the associated service and PID
4. Locate TermService and note the PID for it
5. Open Task Manager and go to the Processes tab. Then click View > Select Columns and check PID, then click OK
6. Locate the svchost.exe process with the PID noted in step 4, right click it, select End Process
7. Open services.msc
8. Start the Terminal Services service

I created a sitemap for my Joomla website using Xmap and submitted it using Google Webmaster Tools... After giving Google some time to crawl the site, I checked back, and found that it had recorded a 404 not found error for ALL of my pages. When I clicked on the links for each article, they opened up just fine.

So I did some searching and found that a lot of people who use sh404sef have problems with submitting sitemaps to Google, especially when using Xmap. Their sitemap was being generated using non-SEF URLs, but as soon as Google tried to access that page it would redirect to the SEF URL. I opened up my sitemap and confirmed it was not the case - there were only SEF URLs in my XML sitemap.

I found an external sitemap tool at auditmypc.com which gave me some more info and allowed me to do some testing in real-time. When I generated the sitemap, the first 10 pages loaded with no error, and the rest gave a 403 forbidden.

I thought, "this sounds like a connection limit" - and was about to ask my web host if they had a connection limit - when I remembered that sh404sef has some security options. I opened up the extension's configuration page and found a "flood protection" setting.

1. Click on Components > sh404sef > Control Panel
2. Click on the Security Configuration icon
3. Open the Anti-flood configuration
4. You can either select "No" on the "Activate anti-flood" option, or change the "Max number of requests" setting

I just disabled the anti-flood protection and checked back a few days later, fixed!

When you create a shortcut in Windows it adds an annoying suffix, for example if you added a shortcut to the "My Documents" folder, the shortcut would be named "My Documents - Shortcut". You can turn off this default behaviour by making the following change in the registry.

1. Open the Registry Editor. Click the Start button, type regedit, and press Enter.
2. If a User Account Control dialog box appears, click "Yes".
3. Navigate to the following key: HKEY_CURRENT_USER \ Software \ Microsoft \ Windows \ CurrentVersion \ Explorer
4. Double-click the name "link", changing its value to 00 00 00 00.
   Changing the name "link" to remove shortcut text in Windows 7
5. Close the Registry Editor.
6. Save all open files and reboot your machine. Logging off and back on does not seem to work.

Now when you create new shortcuts (this does not affect existing shortcuts), the suffix " - Shortcut" should disappear.

A profile is a special script file which is run when PowerShell starts up. You can use these script files to store functions and variables that will be persistent.

You can see whether the various profile files exist by issuing the following command:

$profile | gm *Host* | % { $_.Name } | % { $p = @{}; $p.Name = $_ ;$p.Path = $profile.$_; $p.Exists=(Test-Path $profile.$_); New-Object PSObject -Property $p } | Format-Table –AutoSize

More info: Setting up a PowerShell Profile

You can use Xmap to create a map of your entire Joomla website. At first, I found that it was only mapping the menu items, not going deeper to map all of the pages.

This is because Xmap expands all the menu items that it can expand. If you have a menu item pointing to a Content Section or Content Category and Xmap is not expanding it, then check the following:

1. You have the "Expand Section" and "Expand Category" options enabled in the options for the Content Extension in Xmap
2. Your menu item is not a link to a SEF url, eg. "/contact-us". In other words, Xmap won't recognize static URLs if they are in a SEF format

• Setting password on CISCO routers
• CISCO password recovery
• How to save a CISCO config file

Basic Commands

When typing any command, you can press <?> to show help information. This can show available commands, and also syntax for specific commands. You can also use <TAB> to complete commands.

• Clear the NAT translation tables: clear ip nat translation *
• Go to beginning of line: CTRL+A, to end of line: CTRL+E 
• Delete the startup config (will show setup mode after reload): erase startup-config
• Show host table: show hosts (temp = cached lookup, perm = host added with "ip host")
• Disable console logging: no logging console
• Turn off all debugging: undebug all or un all
  

Reload the Router

Show the Running Config

• Turn off the annoying MORE behaviour: terminal length 0 (term len 0)
• Show the configuration: show running-config (show run)
• Show the startup config: show startup-config (show start)
• Revert changes from startup config: copy startup-config running-config (copy start run) - or just reboot the router
• Commit changes to startup config: copy running-config startup-config (copy run start)
• Another method (does the same thing): wr
• Start displaying config at specific line containing <word>: show run | begin <word>
• Display all lines with given <word>: show run | include <word>
• show run | section <word>

Routing

• Show routes: show ip route

Interfaces

• List interfaces: show ip int brief
• Show particular interface: show run interface Dialer0

Insert ACLs using Line Numbers

I wanted to change the logo at the top of my WHMCS client facing pages. The image doesn't seem to be hosted locally... I hacked the template like this:

vim templates/default/header.tpl

change the following line:

<img src="/templates/{$template}/header.jpg" width="730" height="118" alt="" />

to

<div align="center"><img src="http://mundyhosting.com/members/images/logo.jpg" alt="" /></div>