Get Ready for GDPR!

The General Data Protection Regulation (GDPR) takes effect on 25th of May 2018. This introduces considerable new responsibilities on all businesses, large or small. There is a legal responsibility to make sure information is kept securely and with due care, and is restricted to only those who need it. There are heavy penalties for data breaches, and an obligation to …

SQL To Check Space Taken Up By Each Table

This SQL for use with Microsoft SQL Server is a little better than the standard EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?’” SELECT t.NAME AS TableName, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id …

Car and Driving Video on WordPress Example

Car and Driving are a customer we do a large amount of work with. This page is a demo for their clients, to show how to embed a video on a WordPress website (which is what the Rectangle Red website is built in). See Car and Driving's Wiki for more information; this page is done using the embed code shown on ...

O2 Business Fibre Broadband and Non-Standard Routers

We had fun setting up a Draytek 2860 router to talk to O2’s Business Broadband Fibre service today; there is no documentation, and support staff, well meaning though they are, cannot tell the appropriate settings for a router either. This is largely because O2’s Fibre Business Broadband offerings are outsourced to Daisy Internet. The following procedure should work on routers with …

HTTPS fails on IIS7.5 after server restart

If HTTPS fails to start correctly following a server restart, but HTTP does. Try looking at the binding on the website which https is attached to; the act of looking (and clicking ok) will be enough to get https running again temporarily. But if it fails again on reboot, look at the logs, and in particular for the code 0x8009030d in …