SQL Server: The index “[IndexName]” on table “[TableName]” cannot be reorganized because page level locking is disabled.
If you’ve managed production database servers for any amount of time, you may have run into this error message in your maintenance plan logs. “The index “[IndexName]” on table “[TableName]” cannot be reorganized because page level locking is disabled.” This will cause your Index Reorganize step to fail. Fortunately, it’s pretty easy to fix. First, a […]
General election 2010
Here in the UK we have just been through (and, at the time of writing, are still enduring) a general election. This presents us with some fantastic datasets. The first place I turn to is the Guardian Data Store, and they provided this, which allowed me to create Election results dashboard below. Overview (blog) Powered […]
Remove Duplicates in Outlook
Those of you who use Outlook out there and leave your messages on the server, you will have probably had to deal with duplicate messages downloading either after you replaced your computer or Outlook had an issue and crashed. I have tried several tools for this but most had a limit to the number of […]
Why start another Tableau blog?
Those who know me from the Tableau forums or Twitter, or the UK Tableau User Group know that I love Tableau.Those that don’t know me: well, I work at the University of Oxford, and have been using Tableau since December 2007. Since then, I have been raving about it, Ancient Mariner style, to anyone who catches my eye. It’s […]
What does availability/uptime mean in the real world?
Service Level Agreements from companies usually explains that the product they are supporting will be up or available for X% of the time. 90% is good, 99% is even better, and some go on up to 99.99% or higher, but what does that mean for a business in plain terms? Availability % Downtime per year Downtime […]
The Only Twitter Tools Your Business Needs
If you’re reading this blog, it’s probably because you’ve given up on sifting through the hundreds of Twitter tools available on the web. Frankly, you just want somebody to tell you what the best tools are and why, and not give you a list of tools whose functions overlap, right? Well, you’re in luck, because […]
Supercharge Your Drupal Views with the Views Custom Field Module
There have been several occasions when I’ve been working on a Drupal view and needed some conditional logic when re-writing the output of a field. It would be nice if there were some kind of built-in IF or SWITCH statement, but there’s not. On my latest project, I decided to consult Google for some Drupal […]
Getting the most out of your SonicWall – Network Monitoring through SNMP (Part 1 of 2)
A way that we assist clients who have SonicWall appliances is by enabling SNMP (Simple Network Management Protocol) on the WAN for our company. This allows us to have additional information that we can use in the future. One piece of that information is the ability to be able to monitor network bandwidth, which helps […]
What Will People Find Out About Me on the Web?
Whether you are a high school princess worried about online jerks or a Fortune 500 corporation dealing with loud and disgruntled reviewers, the general answer is the same: Use everything at your disposal to manage your online reputation. So What Does That Mean, Online Reputation Management? In short, you want to do everything you can […]
Computer will not turn on after mainboard replacement.
More often than not this issue is caused by the mainboard grounding on the case of the computer. Common Mistakes Using the wrong screws – Make sure to use the screws that came with the case, and make sure they are specifically for mounting the mainboard to the case. Screwing the mainboard screws too tight […]
