February 2020 Roundup: Azure Managed Instance, Azure SQL Database Healthcheck and ADF Deployment with DevOps

february 2020 sql roundup

My wife and I gave birth to a beautiful baby girl 3 weeks ago. Whist in the hospital chatting to the nursing staff about our previous experiences with our first born they described our two daughters as same same but different. Previously I associated this phrase with being in a marketplace haggling for something, however I thought it was a very adept way of describing the situation.

I think the statement same same but different summarises the changes I am experiencing with our second child but also provides comparisons between deploying SQL Server on-premises versus cloud. The on-premises world is like my first born who over the years I have worked out how to manage and to get the best performance from. Whereas with my newborn I can only rely on some of my existing skills as a parent, but I need to adapt and change them and I can’t approach the same situations in exactly the same way.

If you and your team are looking to adapt your SQL Server skills for the cloud WARDY IT Solutions has a number of options available ranging from our Azure Data Service Essentials training course to our Azure Database Migration assessment. I’d love to hear how you and your team have updated their skills to meet the changing requirements of cloud deployments with your database estate.

Why Azure Managed Instance?

Managed Instance is a fully kitted out SQL Server PaaS option which offers up almost all the feature set of a full SQL Server database installation. This makes application database feature parity easier, and also eases up the way for “Lift and Shift” database migrations from existing SQL Server database installations.

All these advantages along with built-in Azure features of a fully managed service, platform ingrained high availability, performance monitoring, secure network implementations made Managed Instance a truly worthwhile alternative to SQL Server on Azure IaaS or the good old on-premise SQL Server installations.



Register for the Migrate-a-thon – a one-day hands on workshop designed for organisations to accelerate the modernisation of their application portfolio to Azure.

When it comes to moving to the cloud, most existing application migrations come in the form of a “Lift & Shift” to IaaS. Unfortunately, this approach does not unlock the business value of the cloud or take advantage of PaaS services. In this workshop WARDY IT Solutions will assist you to analyse a subset of applications to understand how to accelerate the migration to Azure.


Azure SQL Database Healthcheck

The Azure SQL Database Healthcheck is a comprehensive review to ensure Microsoft SQL Server Best Practices are in place, as well as providing recommendations to improve the health and performance of your database environment.

With WARDY IT Solution’s Azure SQL Database Healthcheck, we ensure no gaps exist and your Azure SQL Database is both secure and performing optimally.


ADF Deployment with DevOps

In one of our latest blog post, Julia Vassileff, BI Consultant and Senior SQL DBA at WARDY IT Solutions, demos the deployment process of Azure Data Factory (ADF) with Azure DevOps.


The ultimate performance for your big data with SQL Server 2019 Big Data Clusters

Microsoft SQL Server 2019 Big Data Cluster enables intelligence over all your data and helps remove data silos by combining both structured and unstructured data across the entire data estate.

In October 2019, Microsoft and Intel conducted performance and scalability testing using workloads derived from the TPC-DS schema with very large data sets producing 1TB, 10TB, 30TB, and 100TB worth of raw structured and semi-structured data running on Microsoft SQL Server 2019 Big Data Cluster. View the result here.


WARDY at Microsoft Ignite

Microsoft Ignite The Tour Sydney was a huge success. We’d like to thank those who attended the event two weeks ago and those who dropped by our booth (booth 414). It was great talking to everyone and we hope to see you again next year!


Announcing the preview of Azure Shared Disks for clustered applications

Last week, Microsoft announced the limited preview of Azure Shared Disks, the industry’s first shared cloud block storage.

Azure Shared Disks enables the next wave of block storage workloads migrating to the cloud including the most demanding enterprise applications, currently running on-premises on Storage Area Networks (SANs). These include clustered databases, parallel file systems, persistent containers, and machine learning applications.