What?
Really not work related but if you know your sharepoint site:

Custom Error
http://<My_SharePoint_Site>/_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks.


Installer?

What?
I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't.

The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the others. Once it's in your Outlook, you can copy over events. The calendar is separate to your own and to other Exchange ones.

Eeek!

Applies to

• Microsoft Office Sharepoint 2007

What?
I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg. I:\myFile.doc)but what if other users haven't mapped the same drive letter to the path? Then they won't be able to use the link.

Why?
As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our Sharepoint 2007 portal.

How?

Applies To:

• MS SQL Server 2008 R2
• MS Windows 7 Enterprise (Client)
• MS Excel 2010

What?
A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time.

Why?
I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands to the width of the word "Academic".

What I have:

Academic Week    Monday      Tuesday     Wednesday   Thursday    Friday
---------------- ----------- ----------- ----------- ----------- -----------
1                14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014
2                21-Jul-2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014
...

What I want:

Academic 
Week      Monday      Tuesday     Wednesday   Thursday    Friday
--------- ----------- ----------- ----------- ----------- -----------
1         14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014
2         21-Jul-2014 22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014
...

How?
To do this in a select query resultset, you insert the special character references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to do this in the name of the column heading, the answer is a much simpler one,

Download Connectors from dev.MySQL.com

MySQL Connector/Net

Type: .NET Framework Class Library
Usage: MySql.Data.MySqlClient.MySqlConnection
Manufacturer: MySQL

Standard

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Default port is 3306.

Specifying port

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Why?
So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can.

What?
Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while.

How?

What?
I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to use a common local directory for all workstations so configuration files would not need to be modified.

So?
Once installed, my BIDS install would continuously check-out files and store these in the home directory. I tried the general settings (Tools > Options) but to no avail.

How?

What?
A quick article to get an Apple Trackpad working with an MS Windows 11 Pro (Intel 64) workstation.

Why?
I forgot my work Macbook at home and rather than drive the commute back and forth again, I took my previous biscuit box out (a Dell MFF Optiplex 7070) and spent 30 minutes connecting monitors and the logitech receiver for my keyboard (which was a Logitech keyboard for Windows - keys switched for the Mac but reverted for the biscuit box). Running MS Windows 11 pro already. Wifi was ok to connect and my Microsoft Office apps, well it's a Windows box so no issues there either... Webcam and headset previously connected to my docking station weren't too much of an issue either as MS Windows detected these without needing software.

Long rant to justify why I didn't want to drive home (~20 to 40 minutes commute) and pick up my laptop.

How?
The work and research for this was all in one YouTube video by LinxHype (https://www.youtube.com/watch?v=J_z9-rE_6zI) so I don't want to take credit for it. There were other videos using the GitHub repo: GitHub / imbushuo / mac-precision-touchpad but those instructions seemed only for those on an AMD or ARM processor. The process demo'd by LinxHype is the one that worked for me.