Tech Blog – Index
2019
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
2018
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
