Author Archives: Stephen

Find all MSSQL Instances running, Connect and show Version

Posted on January 1, 2012 by Stephen

The diagram below, shows how you can use SQL Management Studio to connect to all instances of SQLServer running on your computer (as indicated in the Services list) and run a simple query to find out the exact version and … Continue reading →

Posted in IT | Tagged | Comments Off on Find all MSSQL Instances running, Connect and show Version

Limit Memory Usage of store.exe – Microsoft Exchange

Posted on January 1, 2012 by Stephen

On the SBS 2011 Server, Microsoft Exchange isn’t used at all, yet store.exe uses over 700MB of memory (via Processes in Task Manager). It doesn’t look simple/possible to remove Exchange as part of a SBS Server. Instead, below shows how … Continue reading →

Posted in IT | Tagged , | Comments Off on Limit Memory Usage of store.exe – Microsoft Exchange

SQL Activity Monitor – Debug high CPU Usage for SQL Server

Posted on January 1, 2012 by Stephen

START -> All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Management Studio Connect as normal and right-click on the SQL Server (top left) and go “Activity Monitor”. The Activity Monitor will show the queries been run, the … Continue reading →

Posted in IT | Tagged | Comments Off on SQL Activity Monitor – Debug high CPU Usage for SQL Server

SEO tweaks using mod_rewrite to prevent duplicate content being crawled

Posted on November 14, 2011 by Stephen

Over the past few years, with the rise in popularity of using no-www there have been some issues where content is getting crawled by a search engines twice, and in some cases getting a negative scoring due to duplicated content. I.E. … Continue reading →

Posted in IT, Web Design, Web Development | Tagged , , | Comments Off on SEO tweaks using mod_rewrite to prevent duplicate content being crawled

Remove a Preferred Network from the Dell Wireless Utility

Posted on November 3, 2011 by Stephen

An information sheet on how to remove a Preferred Network from a computer with a Dell Wireless Utility on Windows XP. Link to Document

Posted in Broadband, IT | Tagged , | Comments Off on Remove a Preferred Network from the Dell Wireless Utility