general
- Lean and waste in IT
- Server archaeology
- 5 years
- Remembering old technical books, part 2
- Hello CCAMLR!
- Remembering old technical books, part 1
- Tales from the trenches, part 2
- Tales from the trenches, part 1
- My work values
- How I use 'Inbox Zero' ('Inbox 20'?)
- Why I chose the Firefox browser in 2019
- My day job (2017)
- Ingress and AR gaming in the real world
- Starting with Jekyll
development
- Connecting to a SQL Server database from R Markdown (part 1)
- Troubleshooting caching in R Markdown and Shiny server
- Master/detail with dynamic hiding & showing in R Markdown
- QR codes in R Markdown
- Using a .env file to manage secrets in R Markdown
- Debouncing input in R Markdown
- Use Google Font in R Markdown web page
- Reload parameters without page reload in R Markdown
- Set keyboard focus to a control in R Markdown & Shiny
- Displaying loading messages in DataTables in R Markdown
- Toggling dark mode in R Markdown
- Dark mode in R Markdown using prefers-color-scheme: dark
- Passing a query string value to R Markdown
- Recreating my basic Antarctic Leaflet map in R (tiles, shapes, graticules, labels)
- Leaflet production considerations (part 4)
- Displaying text labels instead of markers from GeoJSON on a Leaflet Antarctic map (part 3)
- Loading shapefiles into Leaflet Antarctic map (part 2)
- Loading a layer from a GeoJSON file into Leaflet Antarctic map (part 1a)
- Easy set up of Leaflet 1.8 (May 2022) for making an open source Antarctic map (part 1)
- Notes to self: Calculating an SRI hash for javascript and CSS files
- Using Terser to minify and compress Express javascript code for deployment
- Levelling up an Express API, Part 3
- Notes to self: installing PM2 on Windows, as a service
- Levelling up an Express API, Part 2
- Levelling up an Express API, Part 1
- Notes to self: SignalR on IIS, behind a load balancer
- RigorousSearch MediaWiki extension updated for MediaWiki 1.28
- Why you shouldn't use Bootstrap
- Nancy - Minifying HTML with WebMarkupMin
- Stylelint is FxCop/Web Essentials/JSHint for your CSS stylesheets
- My .gitignore template
- Useful Chrome browser plugins, April 2016
sqlserver
- SSIS database error logging query
- E-mail blocking & blocked processes to a DBA using sp_WhoIsActive, a SQL Agent job and an alert
- Quickly automate SQL Server database documentation to Markdown
- Notes to self: E-mail DBA on objects created in the master system database
- Notes to self: E-mail DBA on new database creation (and restore)
- Delete non-built-in roles, schemas, and users from a SQL Server database
- Clear msdb system database history
- Commissioning a SQL Server (a checklist)
- Automated DBA monitoring for SQL Server: a primer, part 3
- Automated DBA monitoring for SQL Server: a primer, part 2
- Automated DBA monitoring for SQL Server: a primer, part 1
- Using sp_WhoIsActive to record & query activity on SQL Server
- Notes to self: Attempting to reliably find SQL Server stored procedure usage history
- SQL Server Agent 'Include step output in history' and msdb system database size
- Notes to self: e-mailing a DBA on long-running SQL Agent jobs
- Notes to self: e-mailing a DBA if there's SQL Server database backups run during business hours
- Create and test Oracle linked server on SQL Server 2012
R
- Connecting to a SQL Server database from R Markdown (part 1)
- Troubleshooting caching in R Markdown and Shiny server
- Master/detail with dynamic hiding & showing in R Markdown
- QR codes in R Markdown
- Using a .env file to manage secrets in R Markdown
- Debouncing input in R Markdown
- Use Google Font in R Markdown web page
- Reload parameters without page reload in R Markdown
- Set keyboard focus to a control in R Markdown & Shiny
- Displaying loading messages in DataTables in R Markdown
- Toggling dark mode in R Markdown
- Dark mode in R Markdown using prefers-color-scheme: dark
- Passing a query string value to R Markdown
- Recreating my basic Antarctic Leaflet map in R (tiles, shapes, graticules, labels)