Category: Quick Tips
VirtualBox 0xc0000225 Windows 7 Boot Error
If you take all the default options for a Windows 7 machine in VirtualBox you might hit the following error when booting from install CD/ISO It should be an easy fix and all you need to do is check the following 2 options in settings -> System for the virtual machine Ensure Chipset is set [...]
Start all required Microsoft Exchange Services Powershell
Often our Exchange Server has some issues when it has been rebooted after Windows updates, a seemingly random selection of the Microsoft Exchange Services fails to start and has to be started manually. It’s quite a time consuming process to go through each one but this useful powershell one liner sorts it out. Test-ServiceHealth | [...]
F9 key won’t Send/Receive in Outlook
The F9 key is supposed to perform a send/receive all groups in Microsoft Outlook however it may appear to have no effect when pressed. A customer had this problem where the F9 key also did not function in any other applications, a particular issue as they used IBM Client Access where the F9 key is [...]
How to access the terminal (command prompt) on a chromebook
Accessing the terminal in chrome OS is as simple as pressing Ctrl + Alt + T The terminal opens in a new tab, when you’re finished you can type exit and then close the tab The terminal is also known as the command line or command prompt in other operating systems
Converting List(Of Integer) to comma separated string
This is a one liner you can use to convert a List(Of Integer) into a comma separated string, useful for in a SQL IN clause. In my example my list of integers “lProductIDs” gets converted to string strProductIDs In one line… 1 strProductIDs = String.Join(",", lProductIDs.ConvertAll(Of String)(Function(i As Integer) i.ToString()).ToArray).TrimEnd(",").TrimStart(",") The Explanation There is quite [...]
Drop all tables in Microsoft SQL Server Database T-SQL
There is a useful hidden stored procedure in SQL Server which will run a peice of T-SQL for each command in the database. The “?” symbol will be replaced with the table name EXEC sp_MSforeachtable @command1 = “DROP TABLE ?”
A Simple Shutdown Timer Batch Script for Windows
Ever needed a quick way of asking your computer to shutdown in x minutes? Maybe so it shutsdown after your movie has finished so you don’t have to bother getting out of bed or worrying about power consumption if you fall asleep. You can use the built in shutdown command with a timeout parameter however [...]
How to reset a Motorola Xoom
Is your Motorola XOOM frozen and not responding to button clicks or screen touches? You can soft reset the device by holding down the volume up and power buttons at the same time for at least 3 seconds and then releasing. When you release the XOOM should display the familiar boot logo and you will [...]
Case Insensitive String.Replace vb.NET
As you might be aware the String.Repalce method in .NET is case sensitive without any overloads. You can use a Regex.Replace to get around this 1 Regex.Replace("My favourite pet is a dog", "DoG", "cat", RegexOptions.IgnoreCase)
Don’t auto post wordpress blogs from mail
When you use the email to post functionality in WordPress it automatically publishes the post if it can find a user using the email address you sent from. I personally would rather them stay on hold and then I can tweak them in WordPress before publishing it. This is how I did it… From your WordPress directory [...]
