Download Live Website
April 22, 2018
Copying a Live WordPress website onto MAMP

This is a follow-on post from Configuring MAMP (with WordPress) and is a guide on how to download your website and have it run locally on your laptop or PC. This provides a test environment for upcoming changes to your website, or it's a fun task nonetheless even if you don't use it for testing […]

MAMP with WordPress
April 18, 2018
Configuring MAMP (with WordPress)

MAMP is a “one-click solution for setting up your personal webserver”. If you don’t have hosting or a domain name sorted out, you can go ahead and build your WordPress website using this free bit of kit. I promote because it’s really simple to use! This post will come in 5 parts.1. A quick install […]

Kill SQL Server SPIDs
April 17, 2018
Killing SQL Server Processes (SPIDs)

There are many reasons why you’d KILL a SPID in SQL Server. Whether it’s impending disk space doom due to data or log file bloat, or a long running query that’s lost in space... When alerted to this situation I’d run sp_whoisactive in the first instance. When the picture is clear, the kill happens. To […]

Quill and ink image
April 16, 2018
Renaming a computer that hosts SQL Server

When changing the hostname of a computer running SQL Server, system metadata must be updated so that remote connections and applications do not lose connectivity. Those that use @@SERVERNAME or query sys.servers for the hostname that is. Microsoft's documentation pages are a must read as always. Some considerations include; failover clustering, mirroring, replication, SSRS, local authentication […]

Microsoft SQL Server Logo
April 15, 2018
Installing SQL Server 2017

Installing SQL is a straight-forward task… but it’s important that things are in-place from the get-go to prevent having to make changes on a live system. There are a few best practises that can be defined within the installation wizard and many to be applied post install. This is a basic guide on installing SQL […]

Pete's Blog
April 9, 2018
SiteOrigin Custom CSS Load Delay

I’ve used SiteOrigin CSS WordPress Plug-in quite a bit now, although there's one note-able issue that I feel is worth blogging about. This SiteOrigin Plug-in lets you click on an area of your page and customise a ton of options without you typing a single line of code. For some of the changes I’ve made I encountered […]

SQL Server Script Convert
April 9, 2018
Get Estimated Database Restore Time

If you're backing up or restoring a large database, you can run the script below to find out how long it has left to complete. The performance of a backup or restore will depend on many things such as server hardware, chosen backup options or even a user running queries. The estimated time returned by […]