Category Archives: SQL Server

Virtual DBA Service Q3 Roadmap

Virtual DBA Service Q3 Roadmap

We developed SQL Beacon™ and MyVirtualDBA™ to underpin our world-class team of DBAs who work on shift, 27x7x365 to support our clients. SQL Beacon™ is an agentless monitoring and alerting engine that polls your infrastructure and SQL Servers to generate notifications for events before they become issues. The data captured by SQL Beacon™ is also […]

Want to upgrade to a modern database environment? Don’t let legacy applications hold you back

Want to upgrade to a modern database environment? Don’t let legacy applications hold you back

With SQL Server 2008 and 2008 R2 approaching end-of-life, upgrading your organisation’s database environment is front of mind for many IT leaders right now. It’s not just the end-of-support for SQL Server 2008 driving the upgrades either. Many organisations want to modernise their database environment to improve performance, be more cost-efficient, and to have all […]

Mistake free planning for SQL Server end of life

Mistake free planning for SQL Server end of life

You would be aware from Microsoft’s communications that SQL Server 2008 and 2008 R2 are reaching end of life (EOL), with extended support terminating just months away in July 2019. Are you responsible for managing the impact this could have on your organisation’s processes and applications? Do you have an application vendor holding you back? […]

eBook: An Introduction to Azure Managed Instance

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 […]

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.