Tech Blog – Index (Category, Date)

Switch to Index by Date
Switch to Index of Pages

SQL Server

04-10-2020, Disk Usage by Top Tables Report in SQL Server
22-09-2020, Show Last Backup Times in SQL Server
21-09-2020, Why use WHERE 1=1 in SQL Queries
15-07-2020, Creating a Linked Server with a MySQL Database
14-07-2020, Check & Restart SQL Server Services on Linux
06-05-2020, Forcing Encryption in SQL Server
05-05-2020, Include Execution Trace Messages In SQL Server Error Logs
04-05-2020, Backing up a SQL Server Database with Encryption
04-05-2020, Backing up a SQL Server Certificate
29-04-2020, How to Check What Features are Installed in SQL Server
27-04-2020, Installing SQL Server on Linux
25-04-2020, Enabling TCP Connections in SQL Server
16-11-2019, What’s New in the SQL Server 2019 Installation Wizard
02-10-2019, Running Scheduled Tasks in SQL Server Express
01-10-2019, sqlcmd in SQL Server
30-09-2019, Changing Schemas in SQL Server
18-07-2019, Adding & Removing SQL Features via Command
10-06-2019, Install/Uninstall SQL Server via Command
17-04-2019, “Windows Could Not Start The SQL Server”
15-04-2019, “Index Was Out Of Range” SQL Server Management Studio
10-03-2019, Creating a Linked Server with a Postgres database
04-03-2019, Configuring Linked Servers in SQL Server
23-02-2019, Database Growth Events in SQL Server
21-02-2019, Setting Maximum Database File Sizes in SQL Server
17-02-2019, Moving TempDB Files in SQL Server
24-01-2019, The (SSMS) Import Flat File Feature
22-01-2019, Attaching SQL Databases Without Log Files
20-01-2019, Backup & Restore (WITH FILE)
13-01-2019, Applying Data Retention to a SQL Table
22-10-2018, Using Custom Connection Colours in SSMS
02-10-2018, Exporting SQL Server Query Results to CSV
01-10-2018, Checking Table Sizes in SQL Server
16-09-2018, Backing Up a SQL Server Database
04-09-2018, Restoring a SQL Server Database
30-08-2018, Batch Deletions in SQL Server
09-07-2018, Copying Dates into Excel
08-07-2018, Stack Exchange Data Explorer
01-07-2018, More on SPIDs… and Killing Them
18-06-2018, SQL Server Support
21-05-2018, Logging sp_whoisactive to a table
20-05-2018, Get Database Growth Events in SQL Server
19-05-2018, Geographical Spatial Environmental Mental
16-05-2018, Show Line Numbers in the SSMS Query Window
13-05-2018, Get Disk Space in SQL Server
17-04-2018, Killing SQL Server Processes (SPIDs)
16-04-2018, Renaming a computer that hosts SQL Server
15-04-2018, Installing SQL Server 2017
09-04-2018, Estimated Database Restore Time


Windows

13-11-2020, Install oh-my-posh in Windows
12-11-2020, Install Windows Terminal (WT)
11-11-2020, Install posh-git on Windows
10-11-2020, Install Chocolatey on Windows
28-09-2020, Change Git Remote URL to SSH (from HTTPS)
08-09-2020, Setup SSH Keys in WSL
07-09-2020, “Config Lock Failed Operation not Permitted” – Linux Linked Folders
07-09-2020, Install Git on Windows
06-09-2020, Create a Link Between Local Windows Files and WSL
05-09-2020, Access Local Files from Windows Subsystem for Linux (WSL)
04-09-2020, Reinstall a WSL Distro
03-09-2020, Enable Windows Subsystem for Linux (with Ubuntu 18.04)
15-07-2020, Creating a Linked Server with a MySQL Database
30-05-2020, “Changing The Primary Domain DNS Name Of This Computer Failed” – Server 2008 R2
07-05-2020, Testing Connectivity to Remote Server Ports with PowerShell
06-05-2020, Forcing Encryption in SQL Server
03-05-2020, Running PowerShell Scripts as Scheduled Tasks In Windows
29-04-2020, How to Check What Features are Installed in SQL Server
25-04-2020, Enabling TCP Connections in SQL Server
31-10-2019, Domain Join Sanity Checks
07-10-2019, Delete Windows.old Files
03-10-2019, Installing MySQL 8.0 on Windows
02-10-2019, Running Scheduled Tasks in SQL Server Express
01-10-2019, sqlcmd in SQL Server
30-09-2019, Changing Schemas in SQL Server
18-07-2019, Adding & Removing SQL Features via Command
10-06-2019, Install/Uninstall SQL Server via Command
09-06-2019, Configuring Windows Server Core
08-06-2019, Joining a Windows Host to a Domain
04-06-2019, Installing Active Directory On Windows Server 2016
14-05-2019, Installing Windows Server 2016 With Hyper-V
17-04-2019, “Windows Could Not Start The SQL Server”
11-04-2019, “Content From The Website Listed Below Is Being Blocked.” Windows Server


PowerShell

13-11-2020, Install oh-my-posh in Windows
12-11-2020, Install Windows Terminal (WT)
11-11-2020, Install posh-git on Windows
10-11-2020, Install Chocolatey on Windows
06-09-2020, Create a Link Between Local Windows Files and WSL
05-09-2020, Access Local Files from Windows Subsystem for Linux (WSL)
04-09-2020, Reinstall a WSL Distro
03-09-2020, Enable Windows Subsystem for Linux (with Ubuntu 18.04)
30-07-2020, Remove Quotes from a CSV File with PowerShell
16-07-2020, “..ps1 cannot be loaded because running scripts is disabled on this system”
07-05-2020, Testing Connectivity to Remote Server Ports with PowerShell
06-05-2020, Forcing Encryption in SQL Server
03-05-2020, Running PowerShell Scripts as Scheduled Tasks In Windows
29-04-2020, How to Check What Features are Installed in SQL Server
25-04-2020, Enabling TCP Connections in SQL Server
18-07-2019, Adding & Removing SQL Features via Command
10-06-2019, Install/Uninstall SQL Server via Command
09-06-2019, Configuring Windows Server Core
19-02-2019, Updating Help Documentation in PowerShell
09-10-2018, Count rows within CSV files using PowerShell


Linux

28-09-2020, Change Git Remote URL to SSH (from HTTPS)
08-09-2020, Setup SSH Keys in WSL
07-09-2020, “Config Lock Failed Operation not Permitted” – Linux Linked Folders
06-09-2020, Create a Link Between Local Windows Files and WSL
05-09-2020, Access Local Files from Windows Subsystem for Linux (WSL)
04-09-2020, Reinstall a WSL Distro
03-09-2020, Enable Windows Subsystem for Linux (with Ubuntu 18.04)
14-07-2020, Check & Restart SQL Server Services on Linux
27-04-2020, Installing SQL Server on Linux
27-04-2020, Installing Firewalld on Linux
08-10-2019, Creating MySQL Databases & Tables (with tips)


Postgres

27-09-2020, List all Schemas/Tables/Columns in RedShift & Postgres
21-09-2020, Why use WHERE 1=1 in SQL Queries
10-03-2019, Creating a Linked Server with a Postgres database
15-05-2018, Reset postgres user password
14-05-2018, Installing PostgreSQL 10 & Stack Builder on Windows


MySQL

21-09-2020, Why use WHERE 1=1 in SQL Queries
15-07-2020, Creating a Linked Server with a MySQL Database
08-10-2019, Creating MySQL Databases & Tables (with tips)
03-10-2019, Installing MySQL 8.0 on Windows


RedShift

27-09-2020, List all Schemas/Tables/Columns in RedShift & Postgres
26-09-2020, Create a Superuser in RedShift
25-09-2020, Create a Test AWS RedShift Cluster
21-09-2020, Why use WHERE 1=1 in SQL Queries


WordPress

13-04-2019, How To Exclude A Category From Blog Page In WordPress
30-06-2018, Change Highlighted Colour of Text in WordPress
22-04-2018, Copying a Live WordPress website onto MAMP
18-04-2018, Configuring MAMP (with WordPress)
09-04-2018, SiteOrigin Custom CSS Load Delay