Posts

All the articles I've posted.

• Common .htaccess Redirects

  Published: 30 Sep, 2014 |  at  07:11 AM

  A comprehensive guide to common .htaccess redirects, including examples for single pages, entire sites, subfolders, and advanced redirection techniques using mod_rewrite.

• FluentMigrator timeout when adding a new column to a large table

  Published: 27 Aug, 2014 |  at  02:00 PM

  Discusses the challenges and solutions for adding a new column to a large table using FluentMigrator, including handling timeouts and adjusting SQL command timeout settings.

• P vs NP explained

  Published: 26 Aug, 2014 |  at  04:34 PM

  An overview of the P versus NP problem, explaining the difference between the complexity classes P and NP and the significance of determining whether every problem whose solution can be quickly verified can also be quickly solved.

• The story of AllowRowLocks equals false. When indexes go bad.

  Published: 25 Aug, 2014 |  at  12:55 PM

  Discusses the challenges and solutions related to SQL Server indexes with AllowRowLocks set to false, including troubleshooting deadlocks and failed deletes, and provides guidance on enabling row locks.

• Saving Table Space Quick And Dirty

  Published: 19 Aug, 2014 |  at  06:26 AM

  A practical guide on reducing database space usage with a SQL script that identifies tables with high data-per-row ratios, helping to improve database performance.

• Deploying Database Migrations in .NET Using FluentMigrator, TeamCity, and Octopus Deploy

  Published: 18 Aug, 2014 |  at  11:30 AM

  A practical guide to database migrations in .NET using FluentMigrator, covering challenges with existing databases, deployment strategies with Octopus Deploy and TeamCity, and overcoming migration complexities. This post provides insights into automation, version control, and structured schema changes for efficient database management.

• SOLVED - apache2: Could not reliably determine the server's fully qualified domain name

  Published: 11 Aug, 2014 |  at  10:22 AM

  A solution to the Apache2 error "Could not reliably determine the server's fully qualified domain name," including steps to configure ServerName and correct the hosts file on a Digital Ocean VPS with VirtualMin.

• Powershell Power - Moving large amounts of files to the cloud

  Published: 10 Aug, 2014 |  at  08:25 PM

  A detailed guide on using Powershell and .NET to transfer large amounts of files to the cloud, including challenges faced and solutions implemented for efficient file migration and database updates.

• The golden rules of encryption for developers

  Published: 24 Jul, 2014 |  at  12:51 AM

  Essential guidelines for developers on implementing encryption, highlighting common pitfalls and recommending best practices for secure cryptographic methods and algorithms.s for developers on implementing encryption, highlighting common pitfalls and recommending best practices for secure cryptographic methods and algorithms.

• The browser wars illustrated - playground edition

  Published: 26 Jun, 2014 |  at  10:03 AM

  A humorous recount of the browser wars in 2014, highlighting Chrome's dominance, Firefox's struggle, and Internet Explorer's obsolescence, with playful analogies and reflections on the ongoing competition.of the browser wars in 2014, highlighting Chrome's dominance, Firefox's struggle, and Internet Explorer's obsolescence, with playful analogies and reflections on the ongoing competition.