July 2020 Roundup: Isentia Case Study, Azure Synapse Webinar, August QSSUG and more

July 2020 Round up

With the borders closed to international travel and Australian states limiting interstate travel, many people have postponed their holidays over the last few months. There have been numerous studies identifying that taking a break from work is critical for maintaining mental and physical well-being. I have noticed throughout July that the level of fatigue that people, including myself, are experiencing has increased with many people looking and sounding exhausted by the time Thursday comes around each week.

This fatigue is compounded by the fact that remote work can feel more challenging and tiring than in-person collaboration. Microsoft has recently released their second Work Trend Index Report that explores the future of work including the good, the challenging and the unknown and the options to help combat fatigue.

Over the last few months, we have onboarded numerous new Virtual DBA clients to assist with increasing operational excellence and managing the increased or changing workloads being experienced as a result of the pandemic. Discover how global media intelligence and data technology company Isentia leveraged the Virtual DBA service to increase their efficiency.  If you would like to know more about how you can manage your Microsoft Data estate more efficiently then contact me today.

Introduction to Azure Synapse Webinar

Azure Synapse is Microsoft’s new cloud analytics service offering that combines enterprise data warehouse and Big Data analytics capabilities. It offers a powerful and streamlined platform to facilitate the process of consolidating, storing, curating and analysing your data to generate reliable and actionable business insights.

If you are interested in learning about building a modern data warehouse leveraging Azure Synapse, please join our webinar on Thursday 13 August at 11:00 AM AEST.

Join us (online) at our next SQL Server User Group

You may have heard the word “DevOps” and wondered whether it is just another buzzword and/or what it can do for you

Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.

Join Hamish Watson for the August QLD SQL Server User Group as he demystifies the concepts of DevOps and we will look at two aspects of DevOps – Continuous Integration & Continuous Delivery.

This event will be hosted online on Wednesday August 5th from 5:30pm to 7:00pm GMT+10.

Case Study: How Isentia took their database support to the next level by implementing the Virtual DBA service

Working across multiple time zones was resulting in a high demand on database administrators at media intelligence and data technology company Isentia.

The service provided by WARDY IT Solutions is proactive and identifies issues before they escalate.

Read how WARDY IT Solutions helped Isentia to significantly reduce their workload with its 24×7 Virtual DBA service.

The Future of Meetings

Offices are coming back to life around the world as COVID-19 restrictions ease and workplaces become safe to re-enter. As we now have the option to go back to the workplace, things are going to be very different. 

As we get comfortable with the NEW workplace, we will start to realise that common practices in the office, especially meetings, will be different and present new challenges for employees.  

MOQdigital spoke to Andrew O’Leary, National Practice Manager for Converged Communications and Security practice. Read what he thinks the future for meetings will be:

Azure Synapse Analytics: New Workspace Experience

Azure Synapse Analytics Workspace is already in public preview and anyone can create the service.

In our recent blog post, you will find information about the service and a tutorial to create your first Azure Synapse Analytics Workspace.

The service appears to be a one-stop-shop for analytics aimed at users of various levels.

The July 2020 Release of Azure Data Studio is Now Available

Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit GitHub.

The key highlights to cover this month include:

  • Feature tour
  • Notebooks enhancements
  • Drag and Drop Tables in Query Editor
  • Azure Account icon added to Activity bar
  • Insiders Build highlights
  • Bug fixes

For a list of complete updates, refer to the following blog post:

Azure Synapse or Azure SQL Database – Which one to consider for Data Warehouse

We are seeing a rapid increase in the adoption of data warehouse on the Microsoft Azure platform. In a modern data warehouse architecture, a data warehouse is a centralized repository of integrated data from one or more disparate sources and stores current and historical data. This data then can be used for reporting and analysis of the data. 

Very often while working with our customers, we have seen use cases for both Azure Synapse Analytics and Azure SQL database as the right fit for a data store. In this article, we will help to identify which technology option is best for you. 

Power BI Desktop July 2020 Feature Summary

Recent Power BI Desktop updates include several enhancements to Q&A, gradient legend support, ability to further customise slicer header text, the general availability release for both relative time filter and model view enabled for live connect, the ability to launch external tools from Power BI Desktop, and more!

See the full list of updates and enhancements here:

Announcing React Power BI

Microsoft have announced the release of Power BI component for React. React is a popular open-source JavaScript library – many users asked for an easier integration between Power BI and React web applications.

For a quick peek into how to implement it in your application, check out this blog post on the Microsoft Power BI Blog:

Exploring Azure SQL Managed Instance Management Pack

We released System Center Operations Manager Management Pack for Azure SQL Managed Instance recently. It provides comprehensive monitoring capabilities for SQL Managed Instance. If you have a hybrid data environment, you can use a single monitoring solution, SCOM, to monitor all your data assets as we already have management packs for SQL Server and Azure SQL DB.

Read the blog to learn how the Azure SQL Managed Instance Management Pack introduces product specific monitors and rules.