Calibri and Cambria fonts for Mac

One of my very, very few annoyances when moving to the Mac platform was the lack of Calibri and Cambria font, so I did some research and found them after a lot of digging around. I decided to make them available for all those others who also were looking for them!

Fonts included:






Download Calibri and Cambria Fonts (.zip file, 3.4Mb)

To install, simply download, extract and double-click on each font and then click on the “Install Font” button to install.

Install Font Mac

These are the fonts that come with Microsoft Office.

These fonts are copyrighted to Microsoft, however (I have checked with Microsoft UK on this by telephone on 14th June 2013) you are allowed to have them provided that you own a copy of either:

– Microsoft PowerPoint Viewer (Free), fonts are included

– Microsoft Office (Any version, Windows or Mac)


–Update June 2015: Now downloaded over 122,000 times! The most popular post on my blog!

Now available also to download from here – San Francisco Font (as used on the Apple Watch)


Calibri Font for Mac, Cambria Font for Mac, Consolas Font for Mac, Constantia Font for Mac, Corbel Font for MacCalibri Font for Mac Download, Cambria Font for Mac Download, Consolas Font for Mac Download, Constantia Font for Mac Download, Corbel Font for Mac Download 


PC Pro Podcast 267

On this week’s podcast: we discuss why superfast broadband is proving slow to reach rural areas; BitTorrent looks to turn over a new leaf; Barnes & Noble takes evasive action with its Nook tablets; and Microsoft readies the public preview of Windows 8.1. Finally, hot hardware of the week sees us get tough on Lifeproof’s ruggedised iPhone and iPad cases.

Parallels Plesk Configuration File Error

New files of configuration for Apache web server were not built due to errors in configuration templates: nginx: [emerg] bind() to [2a02:4e8:4:1050::d908:fde2]:80 failed (99: Cannot assign requested address) nginx: configuration file /etc/nginx/nginx.conf test failed . The detailed error message was e-mailed to you, so please check the e-mail, fix the errors, and click here to retry generating broken configuration or click here to retry generating of all configurations.

I have a fantastic webfusion VPS, but suddenly this error appeared. Despite trying to re-create the files automatically, the error persisted.

Thankfully, an amazingly helpful person at Webfusion support called Adam sorted it out. The reason for the error is nothing to do with the VPS, it is caused by an error in the hardware provisioning script. The hardware team can update the script, and hey-presto NGINX works again with the IP v6 address.

Passing a TOP parameter in to a stored procedure to control number of results returned

Its probably been driving you crazy too – how to control the number of results a stored procedure returns. Lets say you want to use a function to call a stored procedure and specify the number of results returned, like the TOP 10, or TOP 100 – there are many reasons why this is useful.

In my case I needed to show the TOP 10 last accessed records on the home page of a system, but having a “Show more” link that then showed more. I have set a default of 10 results, but obviously the system can pass more in to the stored procedure and overwrite this default value.

Here is the solution! Its all about the parenthesis around the parameter!!

CREATE PROCEDURE class_Client_ListTop10LastUpdated
@NumberToShow int = 10
    Top (@NumberToShow)
    LastUpdated DESC

Visual Studio Keyboard Shortcuts

I always struggle to remember particular keyboard shortcuts for Visual Studio – there are just so many!

The most common ones we use are

Ctrl + K + C (Comment)

Ctrl + K + U (Un-Comment)

Ctrl + K + D (Format Document)

There is a complete list of all Visual Studio shortcuts that is really useful on