Reset Default PostgreSQL User Password
A common scenario working with Postgres is when you have forgotten your default Postgres user password. This is the password you will have entered during your Postgres installation.
How To Install PostgreSQL on Windows
PostgreSQL is a free open-source RDMS that is widely used and forked. Other than PostgreSQL itself, Redshift is the only other forked database I’ve ever touched.
Show Available Disk Space in SQL Server
This blog post is to share a script that you can run in SQL Server (versions 2008 R2 and above) which shows the available disk space for all local volumes on a SQL Server host.
How To Copy A WordPress Website Onto MAMP
This is a follow-on post from Configuring MAMP (with WordPress) and is a guide on how to copy a website onto MAMP.
How to Install WordPress with MAMP on Windows
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.
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…
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.
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.
Get Estimated Database Restore Time
If you’re backing up or restoring a large database in SQL Server, you can run the SQL script in this post to find out how long it has left to complete.
