May 2020 Roundup: Azure Synapse migration, questions to ask your MSP, and Power BI licensing options

WARDY May roundup

In a recent investor call, Satya Nadella the CEO of Microsoft, made the comment “we’ve seen two years’ worth of digital transformation in two months”, in reflection of the rapid adoption of technology as a result of the pandemic. At its heart, digital transformation is the adoption of technology to solve business problems. This rapid adoption of new technology is being embraced by organisations of all sizes, even my local suburban deli has pivoted their business to start providing online services and has added additional services lines that will be in place long after COVID-19.

Moments of crisis have historically served as a powerful impetus for innovation as extreme adversity fosters innovation and the building of great companies. Eighteen of the thirty organisations currently on the Dow Jones Industrial Index were founded during economic downturns.

As part of this innovation, we have seen a rapid adoption of Power BI to help enable a data-driven culture, so organisations can make confident business decisions by using up-to-the-minute analytics. WARDY IT Solutions has developed our Power BI QuickStart service to rapidly introduce all the features and benefits of Power BI in a short, low cost, agile engagement.

If there is anything the WARDY team can do to assist you, do not hesitate to contact us.

Case Study: Iceland Foods modernises Data Estate with WARDY IT Solutions

WARDY IT Solutions assisted UK grocery chain Iceland Foods to migrate their existing data warehouse from Teradata to Azure Synapse.

WARDY IT Solutions were able to review the data warehouse and implemented improvements, migrating their data estate to Azure Synapse. This resulted in significantly reduced operational costs and increased agility.

With the former estate retired, the Azure data estate aligned with Iceland Foods’ broader business plan of Cloud migration.


SQL Server Test Those Backups

Regular backup testing is a crucial part of any Backup and Restore strategy. If your backups haven’t been tested, you’re effectively not backing up at all. Murphy’s law will guarantee that the backup you need to restore will be unavailable in some form or another.

WARDY IT Solutions is here to help you better understand your current Backup and Restore process, assist you in finding out whether it is working as intended and potentially provide a better overall solution to better match your changing business needs.


How is Power BI Licensed?

A question that our customers frequently ask is; “What does it cost to use Power BI in my organisation”?

The simple answer is that it can cost nothing, with the price increasing based on your organisational requirements.

There are four main licensing options in Power BI, and the following blog post summarises the differences between each:


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

Last week we had a great turnout at our webinar!

You can watch our recorded webinar for ‘Top 10 Things Your DBA Should be Doing to Prepare for a Crisis’ here.

If you are interested in learning more about the Virtual DBA service visit our site for more information or request your free trail here.


Questions to ask your MSP ebook

Is your offshore MSP exposing you to unnecessary risk? Businesses relying on offshore staffing may be completely unaware that COVID-19 curfews and overseas restrictions pose a risk to their own operations.

This ebook provides an overview of how to protect your organisation and avoid risking disruption by assessing the support service you have in place. To help you do this, we have compiled a number of questions to ask your MSP.

Download our ebook and find out the right questions to ask your MSP to ensure your database doesn’t suffer.


Monitor Your Cloud Assets to Prevent Bill Shock

Cloud based applications are continuing to grow in popularity, due to benefits such as simplified deployment, increased accessibility and reduced maintenance.

However, building a bank of Cloud based applications can lead to unexpected bill shock, so it is crucial to monitor your assets and ensure that you are only paying for active, in-use applications.

To combat this issue and reduce the risk of bill shock, WARDY IT Solutions have launched Cloud Beacon. An intelligent, real-time monitoring tool, Cloud Beacon presents an overview of your entire Cloud footprint and spend to date.

Set up is quick and easy, with your dashboard accessible within one day. To find out more or to enquire about Cloud Beacon, contact WARDY IT Solutions today.


Introducing Power BI deployment pipelines

The use of analytics within the organization is a daily practice for many. Stakeholders across organizations rely on the information and insights to take decisions and actions, making analytics mission-critical to the success of the organization.

As users consume more, they also require more of their analytics – more data in a single report, smarter and easier ways to answer questions, and obviously data must always be fresh, available and reliable. To keep up with the ongoing requirements, BI teams are required to deliver updates faster while maintaining excellent quality so end-users will not lose trust in the data.

Microsoft announces the public preview release of Power BI Deployment pipelines, a new and improved way for BI teams to manage content lifecycle within Power BI Premium.


Troubleshoot Report Performance in Power BI

This article provides guidance that enables developers and administrators to troubleshoot slow report performance. It applies to Power BI reports, and also Power BI paginated reports.

Slow reports can be identified by report users who experience reports that are slow to load, or slow to update when interacting with slicers or other features. When reports are hosted on a Premium capacity, slow reports can also be identified by monitoring the Power BI Premium Metrics app. This app helps you to monitor the health and capacity of your Power BI Premium subscription.


Open sourcing the Java language extension for SQL Server

With over 20 years of existence, Java is still one of the most popular programming languages and is used in many enterprise applications.

In SQL Server 2019, we added a Java language extension, which enables secure execution of Java programs in the context of a SQL Server query. This enables a wide range of scenarios such as performing advanced text and data preparation tasks, reaching out to external APIs to get data and also training machine learning models and model scoring.

Today, Microsoft announces that they are open sourcing the Java language extension for SQL Server on GitHub.


The May 2020 release of Azure Data Studio is now available

The May release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.

Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.

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 our GitHub.