Category Archives: Uncategorized

SQL – DateDiff

How I figured out that the Sharepoint 180 day trial license ran out: Sharepoint started throwing strange errors, one of them being ‘your trial license has expired’ but other things still working, so I thought maybe this is just a known bug (the bug exists and is well known!) but with no way to tell how old the license is through the licensing page in the admin site which is STUPID, I checked the install date then ran this script in a random database to save me counting wrong.

SELECT DATEADD(dd,DATEDIFF(dd,0,’2013-03-27′)+180,0) ‘Expiry date’
select datediff(day,’2013-03-27′,’2013-09-24′) as ‘Days since installation’


Windows machine info – CLI style

I hate “clicking” through random windows when there is a good command to do something. Remembering it when you use it once every now and then is almost as annoying though. But today I found how to get the specs of a windows computer through the command line:

systeminfo – gives you everything.

If you want info without the hotfixes:

systeminfo | find /V /I “hotfix” | find /V “KB”

SQL Server COLLATE Column Issue

Sometimes columns have different character sets, or you get this error “Cannot resolve collation conflict for equal to operation”.

inner join table1 t1 on t1.colname COLLATE DATABASE_DEFAULT = t2.colname COLLATE DATABASE_DEFAULT

Link Database Servers

When you are writing a query addressing tables in another database server and you get some error like ‘cant find server in sys.dbo’ or whatever it is, and you know they should have access to each other, run this:

exec sp_addlinkedserver ‘database-server-name’

Then your database is linked and can see the other.

Setup – SharePoint 2013 & Azure

Steps I took to get SP 2013 running in the Azure cloud:

  • Set up a Virtual on Azure, Server 2008 R1 (most relevant to Prodanet)
  • Downloaded SharePoint 2013 fromĀ
  • Downloaded & installed “Virtual CloneDrive” because the SP installer comes in a .dmg format.
  • Ran the SP Pre-requisite installer.
  • Ran the SP setup file. Once setup is complete, the website is served on port 80 as the default site, and the firewall is configured to run allow the services. So all you need is to hit the IP/DNS address and
  • In Azure, add an endpoint of port 80. This allows access from outside.

RDP rdesktop with file integration

Found a cool way to remote from a Linux platform to a Windows platform with a redirect, so that the windows pc can mount the Linux file system.

Using rdesktop from a terminal:

rdesktop -f -k de -r disk:linux=/home/aaron/Downloads/


So, I have just discovered that there are many RDP front-ends for linux that really are just using rdesktop behind the scenes. I like to use KRDC (KDE Remote Desktop Client). I can edit the properties of the connection, add the parameters:

-r disk:linux=/home/aaron/Downloads/

And I get my linux mount point!

VirtualBox Runs!

Ok, so I only had to ask one of our network guys and he found me a better PC – one with an i7. So I installed OpenSUSE12.2 and then followed these steps to install VirtualBox using Zypper on the konsole as root:

Add VirtualBox repository:
cd /etc/zypp/repos.d


zypper install Virtualbox-4.2

Now install dev tools for compiling the kernel modules:

zypper in -t pattern devel_basis
zypper in kernel-devel kernel-desktop-devel kernel-source kernel-syms

Set it up:
service vboxdrv setup

Heres a good tute: