Tech Blog – Index


October 8, Creating MySQL Databases & Tables (with tips)

October 7, Delete Windows.old Files

October 3, Installing MySQL 8.0 on Windows

October 2, Running Scheduled Tasks in SQL Server

October 1, sqlcmd in SQL Server

September 30, Changing Schemas in SQL Server

July 18, Adding & Removing SQL Features via Command

June 10, Install/Uninstall SQL Server via Command

June 9, Configuring Windows Server Core

June 8, Joining a Windows Host to a Domain

June 4, Installing Active Directory On Windows Server 2016

May 14, Installing Windows Server 2016 With Hyper-V

April 17, “Windows Could Not Start The SQL Server”

April 15, “Index Was Out Of Range” SQL Server Management Studio

April 13, How To Exclude A Category From Blog Page In WordPress

April 11, “Content From The Website Listed Below Is Being Blocked.” Windows Server

March 10, Creating a Linked Server with a Postgres database

March 4, Configuring Linked Servers in SQL Server

February 23, Database Growth Events in SQL Server

February 21, Setting Maximum Database File Sizes in SQL Server

February 19, Updating Help Documentation in PowerShell

February 17, Moving TempDB Files in SQL Server

January 24, The (SSMS) Import Flat File Feature

January 22, Attaching SQL Databases Without Log Files

January 20, Backup & Restore (WITH FILE)

January 13, Applying Data Retention to a SQL Table


October 22, Using Custom Connection Colours in SSMS

October 9, Count rows within CSV files using PowerShell

October 2, Exporting SQL Server Query Results to CSV

October 1, Checking Table Sizes in SQL Server

September 16, Backing Up a SQL Server Database

September 4, Restoring a SQL Server Database

August 30, Batch Deletions in SQL Server

July 9, Copying Dates into Excel

July 8, Stack Exchange Data Explorer

July 1, More on SPIDs… and Killing Them

June 30, Change Highlighted Colour of Text in WordPress

June 18, SQL Server Support

May 21, Logging sp_whoisactive to a table

May 20, Get Database Growth Events in SQL Server

May 19, Geographical Spatial Environmental Mental

May 16, Show Line Numbers in the SSMS Query Window

May 15, Reset postgres user password

May 14, Installing PostgreSQL 10 & Stack Builder on Windows

May 13, Get Disk Space in SQL Server

April 22, Copying a Live WordPress website onto MAMP

April 18, Configuring MAMP (with WordPress)

April 17, Killing SQL Server Processes (SPIDs)

April 16, Renaming a computer that hosts SQL Server

April 15, Installing SQL Server 2017

April 9, SiteOrigin Custom CSS Load Delay

April 9, Estimated Database Restore Time