eBook: An Introduction to Azure Managed Instance

Azure SQL Database Managed Instance is a new flexible way to move your database environment to Azure, currently in public preview. This new option from Microsoft will streamline the migration of SQL Server workloads to a fully managed database service. Azure Managed Instance provides the control of an IaaS environment and the capability of PaaS without […]

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.