Category Archives: SQL Server

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

If the EOL issue hasn’t yet been pushed towards the top of someone’s To Do list, this article explains why it needs to be tackled now – while time is still on your side and, before the cut off becomes a looming and potentially expensive crisis.

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.

Data Platform consultant Anderson Rangel explores the benefits of Stretch Database, how it works, the gotchas plus a demo!

Organisations today are looking to transform their applications and business process by migrating to Platform as a Service (PaaS). However many are struggling to migrate existing applications including commercial-of-the-shelf (COTS) products to Azure.

At WARDY IT Solutions, we’ve lived and breathed SQL Server for the past 14 years. With more than 100 years of SQL Server experience between them, we asked our Data Platform consultants to share their opinions on the most common causes of performance problems and of course, how to avoid them. Happy performance tuning!