6 Signs You’re in Need of a SQL Server Database Healthcheck

SQL Server Healthcheck

Undertaking a health check is never a bad idea but in reality, how often do you get the time to carry out a thorough inspection of your SQL Server environment? With a never-ending list of priorities, whether it be moving to Azure or fighting to get a database back online, a health check rarely makes […]

Understanding Virtual Log Files (VLF)

Virtual Log Files

Unmanaged Virtual Log Files are one of the most frequent issues I find on my client’s environments and since there is a lot of misconceptions around this topic, my intention with this article is to create an understanding about how and why VLFs get created, simulate a VLF count growth and demonstrate how we can monitor it and more importantly how can we fix it.