April 2020 Roundup: Licensing in SQL Server, Azure Cost Optimisation, Power BI Training Online


The world really does change quickly. In last month’s newsletter, I spoke about how any form of social interaction had become a distant memory due to the impact of COVID-19. However, a few long weeks later in Australia, we are starting to see an easing of the restrictions put in place to manage the pandemic and this week, Sydney’s iconic Bondi Beach once again, is open for swimming and surfing.

Despite the health crisis starting to subside through the management of the spread of COVID-19, there are still many organisations who are being impacted beyond the initial crisis management. McKinsey describes the responses as a series of waves of activity with many organisation being in the scale down in the interim phase. WARDY IT Solutions has made a number of resources available to help assist with this scaling down, including a new whitepaper focusing on Optimising SQL Server Licencing in Azure and we have a webinar running on the 13th of May to further assist with Azure optimisation insights.

We are now including Cloud Beacon as part of the Virtual DBA service and will continue to make this powerful cloud cost clarity tool available to anyone for free for the duration of the pandemic.

I would like to take this opportunity to thank all of the medical and emergency service workers and the countless essential workers that have helped to manage the crisis and WARDY IT Solutions is proud to have been able to support in a small way through contributing to #BuyThemACoffee and donating to the RBWH Foundation Coronavirus Action Fund.

WARDY IT Solutions understands that many businesses have been severely impacted by COVID-19 so if there is anything the team and I can do to assist, then do not hesitate to contact me at any time.

Webinar: Licensing SQL Server in Azure

WARDY IT Solutions will be hosting a webinar on Licensing SQL Server in Azure. Join us to learn how your existing investments in SQL Server licensing can be used to optimise the costs associated with the usage of SQL Server workloads in Azure.

The webinar will take place on Wednesday 13 May at 11:00 AM AEST. If you want to learn more or register for the webinar, please visit this page.


10 Tips for Azure Cost Optimisation

Database Administrators face challenges in keeping databases running as performance demands and data steadily increase. With the advent of cloud, the role of a traditional database administrator has evolved to become a more visible resource in an organisation. One of the key focuses now for DBAs is managing costs and learning different ways to optimise the cloud spend.

We’ve put together 10 tips for DBAs to optimise the costs associated with Azure:


Enrol in online Power BI Training

WARDY IT Solutions is excited to run Power BI training every day between now and the end of June. All courses will take place online. There are three online courses on offer: Power BI EssentialsPower BI Advanced, and Analyzing Data with Power BI.

Only 12 tickets are available for each training session, so please register to secure your place:


Webinar: Top 10 things your DBA should be doing to prepare for a crisis

Our next webinar will discuss 10 strategies that DBAs should be implementing during this period of uncertainty.

As COVID-19 continues to spread, disruption to normal business is inevitable. This will present a challenging year for all businesses, with changing approaches to work and day to day operations. This will also present opportunities for businesses to improve and implement best practices that will ensure a resilient and reliable SQL Server Environment.

If you are interested in learning about creating a resilient SQL Server Environment, please join our webinar on Friday 22 May at 11:00 AM AEST.


Keep your projects moving with DBA on Demand

WARDY IT Solutions are experts at SQL Server Database Administration. We offer help and assistance as you need it, no retainer necessary, with our DBA on Demand offer.

DBA on Demand gives organisations fast access to highly skilled DBAs from our Virtual DBA team, to ensure you can increase capacity or cover for staff in the event of illness, shifting project teams or unforeseen circumstances, without losing any time.


David Alzamendi received distinction for Power Platform

Many of you may know David Alzamendi, one of WARDY IT’s exceptional Data Architects. David received the 2020 Microsoft FastTrack Recognized Solution Architect distinction for Power Platform. David is one of five recipients in the world and the only recipient in the Asia Pacific region.

FastTrack Recognized Solution Architect is a recognition conferred by the Power Platform product engineering team upon a practicing solution architect, for consistently exhibiting deep architecture expertise and creating high quality solutions during customer engagements.


Optimising your SQL Server licenses in Azure whitepaper

Optimising your SQL Server licences in Azure is a great way to reduce costs and avoid bill shock. When a migration is well planned and managed effectively, the benefits of SQL Server in Azure can include:

  • Easy to right fit the SQL Server service to the workload
  • Ability to scale up and down services on demand
  • Ability to stop and pause services
  • Use of Operational Vs Capital Budgets

Download the whitepaper below to learn how to optimise your SQL Server licenses in Azure:


Database Experimentation Assistant

Wouldn’t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence.

Read this recent blog post by the SQL Server Team to learn more about the prerequisites for running Database Experimentation Assistant and the steps to follow to run:


Choose between the vCore and the DTU Purchasing Models 

Azure SQL Database lets you easily purchase a fully managed platform as a service (PaaS) database engine that fits your performance and cost needs. Depending on the deployment model you’ve chosen for Azure SQL Database, you can select the purchasing model that works for you.

Read this recent blog post by Microsoft to understand the different purchasing models are available for different Azure SQL Database deployment models.