Tech Blog – Index

---

2019

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

---