June 2017 Roundup

June 2017 Roundup

The data that is generated by many organisation is their life blood as they undertake a digital transformation. The world of data is rapidly evolving in ways that are transforming industries and business models and forcing enterprises to consider new approaches to reporting and analytics.

For many organisations, the traditional data warehouse is under pressure due to the data explosion and the volumes, velocity and variety of data types. The modern enterprise needs a logical architecture that can scale to meet these demands whilst enabling the business to gain valuable insights. To find out more about how your organisation can benefit from a modern data warehouse contact WARDY IT Solutions today.

To wrap up, here’s my top picks for the month:

End of Financial Year Offer: 10% off all public and private training

With just days to go until the end of the financial year, make sure you invest what’s left of your budget before it’s too late. Purchase any of our public or private training course packages with 10% discount before the end of June 2017 and use it anytime between now and December 2017. Find out more.

Webinar: What’s new in SQL Server 2017

You asked, we listened. Following the sell-out success of our SQL Server 2017 Hot Laps, we know many of you were disappointed to hear the events were fully booked so we’ve scheduled a webinar! In this free 1 hour session, we’ll explain how the new version of SQL Server will improve database operations, developer efficiency and enable self-service Business Intelligence and Data Analytics solutions. Register now.

Deploy Power BI On-Premise

Do you want an on-premises solution for deploying Power BI today? And the flexibility to move to the cloud tomorrow? Check out Power BI Report Server – build your Power BI environment on-premise and distribute reports behind your organisation’s firewall. It’s included with Power BI Premium so you can move to the cloud on your terms. Our Power BI Quickstart is the perfect way to get started with Power BI in your organisation whether you deploy on-premises or in the cloud.

Building your Plan B – how to build a plan for when your systems implode

For organisations that rely on accurate real-time data, having a disaster recovery plan is essential. Check out our latest blog post for top tips on what to consider when building your business continuity and disaster recovery plans.

Spinal Life Australia transition to the cloud

One of the key imperatives for Spinal Life Australia was the delivery of a consistent business application user experience for all workers – any time, any place, anywhere. Find out how Spinal Life Australia exceeded business continuity expectations in the lead-up to the rollout out of the National Disability Insurance Scheme (NDIS) in Queensland. Download the case study here.

Automatic plan correction in SQL Server 2017

Automatic plan correction is a new automatic tuning feature in SQL Server 2017 that identifies SQL query plans that are worse than previous one, and fix performance issues by applying previous good plan instead of the regressed one. Learn more about this exciting feature in 2017 here.

Azure SQL Data Warehouse loading patterns and strategies

Microsoft Azure SQL Data Warehouse is a platform-as-a service (PaaS) offering that provides independent compute and storage scaling on demand. Microsoft has released guidance that provides data loading guidelines for SQL Data Warehouse. There are several common loading options such as SSIS, BCP, Azure Data Factory (ADF), and SQLBulkCopy and Polybase that this document explores.