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 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 […]
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 […]
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 […]
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 […]
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 […]
If you’re restoring a large database, you can get an estimate of how long it’s going to take by running this script below. [crayon-5c47f1aaafd85816831841/] As a quick alternative, you can also use sp_whoisactive to gain a rough idea of progress by viewing the percent_complete column.