Creating MySQL Databases & Tables (with added tips)
This is a post on creating databases/tables in MySQL on both Windows and Linux, with added tips to help with general usage.
Creating a Linked Server with a Postgres Database
In my previous post, I created a Link Server to another SQL Server instance This time, it’s a link to a Postgres database!
Applying Data Retention to a SQL Table
There are many reasons why you’d need to delete old data from a table within a database, some of which include;
Count rows within CSV files using PowerShell
This post is a quick run-through of using a PowerShell script to count rows within many CSV files, with a quick check of the data afterwards.
sp_who, sp_who2 & sp_whoisactive
Sp_whatnow? sp_who, sp_who2 and sp_whoisactive are stored procedures that allow you to view current users, sessions, and processes within a SQL Server instance.
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.