Posts
All the articles I've posted.

SQL Format
Updated:We've all got SQL that needs tidying up. https://poorsql.com/ or https://sqlformat.org/ or http://sqlformat.darold.net/ It wont fix your syntax but it will

Gitlab: When an Upgrade Goes Bad!
Updated:Today is not a lot of fun. I've been seeing some issues with apt not being able to upgrade Gitlab due to a proxy error. This morning I fixed it and the upg

MySQL CSV Import
Updated:A little while ago I wrote a php routine to import CSV files that contain a lot of data into a MySQL table. It works, but it takes it's time doing so. I wa

VSCode rest-client
Now Postman is awesome, but I came across this really good rest-client plugin for VSCode. What makes it so good is that I can save the .rest or .http files
![[unixODBC][Driver Manager]Can’t open lib : file not found](/blog-media/2016/10/mssql-mark-thumb.webp)
[unixODBC][Driver Manager]Can’t open lib : file not found
Updated:I have no idea how we came up against this issue on one of the development images. I'd prepared it all up to the point of delivering php. After following m

Building a Debian Development Server
Updated:When I setup a development system there are a few steps I follow to get everything working together. The aim is to get everything installed to provide php

Wired 802.1X on Linux
Updated:For a while I've been meaning to fix my workstation. When it comes to remote accessing it from home I find I can't because I've followed the green guidance

PHP 7.1 and MSSQL Compile Issue
When trying to get PHP v7.1 running on a Debian Buster development box I ran into an issue where pecl would compile the sqlsrv.so and pdo_sqlsrv.so files f

PHP7.0, Microsoft SQL Driver & Debian (stretch)
Updated:To get the MS SQL ODBC driver working even in Jessie appears to be a challenge. I Stretch I almost surrendered. It is working, but I do think it's a bit of a hack as I've had to install an older libssl1.0.0 and enable the locale en_US.UTF-8.

I Want to Kill the Proxy
Updated:Working behind a non-transparent corporate proxy and firewall is enough to make you psychotic! You'll find enough post on here about setting up environment variables and handling proxies, but there's always room for one more.