April 2019 Roundup

April 2019 - SQL Server News Stories Roundup

Over the last few days my daughter has been in hospital with respiratory issues. The last time I spent any time in a hospital was when my wife gave birth to this bundle of joy in the same hospital 19 months ago. In this time the technology in the hospital has changed dramatically, with each nurse now empowered with a mobile phone running a number of health applications to measure and capture vital statics.

As organisation continue to capture more data there is a need to ensure that the data platform can scale to meet the increased demands but also ensure the security of what is often sensitive data – Are you sure your Data Platform can meet these challenges? Why not book a free Data Platform Modernisation assessment with your team to understand how you can deliver greater security, performance, and innovation.

SQL Server 2019 CTP 2.5 is now Available

The latest preview release of SQL Server 2019 community technology preview (CTP) 2.5 is now available for download. SQL Server 2019 is the first release of SQL Server to closely integrate Apache Spark and the Hadoop Distributed File System (HDFS) with SQL Server in a unified data platform. You can find out how to trial this new capability here.

Brand New Azure Training

We are excited to announce that we are offering two brand new Azure Training Courses – Azure Data Services Essentials and Azure Data Analytics Essentials. These courses cover content not yet addressed by the Microsoft Official Curriculum for Azure. Public course dates are currently scheduled for Brisbane but are filling up fast. If you’re interested in attending a course in a city near you, please get it touch.

Automated Machine Learning from SQL Server

Azure Machine Learning service is a cloud service. You can call the service from SQL Server to manage and direct the automated training of machine learning models in SQL Server. Automated machine learning can be used from SQL Server Machine Learning Services, python environments such as Jupyter notebooks and Azure notebooks, Azure Databricks, and Power BI. Find out how to gain greater insights with ML here.

Reducing downtime for Roses Only with the Virtual DBA service

As a fast-growing online flower retailer offering same-day delivery service, the last thing Roses Only needed was downtime issues. The company’s databases were experiencing deadlocks and timeouts that affected not only internal staff, but also online customers and local florists who were supplying the orders. Find out how the Virtual DBA service reduced downtime and contributed to growing confidence in their systems.

Enterprise-scale Backup for SQL Server Databases

Azure Backup fulfills the cloud promise of a cost-effective, elastic-scale, zero-infrastructure solution that eliminates the need to deploy or manage backup infrastructure, agents, or storage accounts. While it offers long term retention and central management capabilities to help IT admins govern and meet their compliance requirements, it also lets DBAs continue to exercise the power of self-service backup and restore for operational recoveries. Learn more.

Power BI Essentials Courses

This one-day instructor led course concentrates on the Power BI components available in Microsoft Office 2016 and the Power BI Desktop. The participants will learn how to gather and analyse data from a variety of sources and surface visualisations using the Power BI tools to construct compelling insights into business data.

Public course dates are scheduled for Brisbane, Sydney, Melbourne and Adelaide. Get in touch to request private or custom courses.

Webinar: MyVirtualDBA™ Portal

As we mentioned last month, we have released the latest version of SQL Beacon™ and MyVirtualDBA™ – please join us for a webinar on 15th May where we will walk you through all the new features of the MyVirtualDBA™ portal, including how to check your monthly support hours, view Zendesk ticket information and see what the Virtual DBA team have been working on.