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:

Calibri

Cambria

Consolas

Constantia

Corbel

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 

 

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
AS
BEGIN
SET NOCOUNT ON;
SELECT
    Top (@NumberToShow)
    *
FROM
    Clients
ORDER BY
    LastUpdated DESC
END

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 http://www.shortcutworld.com/en/win/Visual-Studio_2010.html