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 […]
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.
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!
With the changes that occurred on the 23rd of January 2017 in the Licensing Oracle Software in the Cloud Computing Environment, Oracle has effectively doubled its database fees for solutions sitting on non-Oracle cloud platforms.
By the Data Platform team at WARDY IT Solutions. Understand your infrastructure – Run the Microsoft Assessment and Planning (MAP) toolkit to obtain a detailed inventory of your current infrastructure.Note: This is the tool Microsoft run during the True Up process. Production and Non-Production – Microsoft does not charge for non-prod SQL Servers so don’t […]
Over the past few months, we’ve seen an increasing number of organisations looking to migrate from Oracle to Microsoft SQL Server. As a consultant in the Data Platform team at WARDY IT, I thought it would be useful to share the Oracle to SQL Server migration process myself and the team use.