Blog HomeIndexCheat SheetsNotes

Recent Posts

28-09-20, Change Git Remote URL to SSH (from HTTPS)
27-09-20, List all Schemas/Tables/Columns in RedShift & Postgres
26-09-20, Create a Superuser in RedShift
25-09-20, Create a Test AWS RedShift Cluster
22-09-20, Show Last Backup Times in SQL Server
21-09-20, Why use WHERE 1=1 in SQL Queries
08-09-20, Setup SSH Keys in WSL
07-09-20, “Config Lock Failed Operation not Permitted” – Linux Linked Folders
07-09-20, Install Git on Windows
06-09-20, Create a Link Between Local Windows Files and WSL
05-09-20, Access Local Files from Windows Subsystem for Linux (WSL)
04-09-20, Reinstall a WSL Distro
03-09-20, Enable Windows Subsystem for Linux (with Ubuntu 18.04)
30-07-20, Remove Quotes from a CSV File with PowerShell
16-07-20, “..ps1 cannot be loaded because running scripts is disabled on this system”
15-07-20, Creating a Linked Server with a MySQL Database
14-07-20, Check & Restart SQL Server Services on Linux
30-05-20, “Changing The Primary Domain DNS Name Of This Computer Failed” – Server 2008 R2
07-05-20, Testing Connectivity to Remote Server Ports with PowerShell
06-05-20, Forcing Encryption in SQL Server
05-05-20, Include Execution Trace Messages In SQL Server Error Logs
04-05-20, Backing up a SQL Server Database with Encryption
04-05-20, Backing up a SQL Server Certificate
03-05-20, Running PowerShell Scripts as Scheduled Tasks In Windows
29-04-20, How to Check What Features are Installed in SQL Server



Linux, MySQL, PostgreSQL, PowerShell, SQL Server, RedShift, Windows, WordPress



Certificates & Encryption, CSV Files, Database Admin, Database Backups, Data Types, Deleting Data, Error Messages, Exporting Data, Importing Data, Installing SQL Server, Linked Servers, Linux Admin, Logging & Monitoring, Measuring Databases, Restoring Databases, SQL Server Agent, SQL Server Management Studio, SQL Server Processes, Windows Admin, WordPress Technical Issues, WordPress Tutorials, WSL

Hi, I’m Pete

Hello and welcome to my website, which is a place for me to store all my notes as I blog away as a software enthusiast.

My area of interest very much revolves around Database Administration (DBA), so there will be a lot of RDMS related posts on here, particularly SQL Server.

It’s been an amazing journey working away at this blog which I started in January 2017. Like anything, practise makes perfect. My hope is to continue to improve my writing and all the other skills required to run a blog. It’s been a long and fun journey so far… and I feel like I’m just getting started!

I hope you enjoy, and feel free to comment on posts or write me a line any time. I’d apprecaite any critique or feedback you may have.