If you forget what you entered as the postgres user password during the install, then this is a guide for you! It's exactly what I did which is the reason for a post. The shameful thing for me is that only a hour had passed since installing PostgreSQL, I was left searching the web to […]
A very simple wizard run-through of a PostgreSQL and Stack Builder installations. Installing PostgreSQL PostgreSQL official downloads can be found here. Also see this link (chapter 16) for installing this on a Linux system. 1. Run set-up exe file. 2. Specify installation directory. 3. Select features. 4. Specify data directory. 5. Enter the superuser (postgres) password. […]
You can quickly check disk space info on a SQL Server host by running the query below. I sometimes find this the quickest way to check available space rather than using PowerShell or the Windows GUI. This SQL Script only work on SQL Server 2008 R2 and above. [crayon-5c7096c1ea3a8201800467/] Results should return within a blink […]
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 install […]
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 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 […]
