Posts

All the articles I've posted.

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

  Published:Aug 25, 2014 |  at 10:55 AM

  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:Aug 19, 2014 |  at 04: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:Aug 18, 2014 |  at 09: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:Aug 11, 2014 |  at 08: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.