January 2018 Roundup

January 2018 Roundup

There has been no rest for IT teams over the festive season. The announcement of the Meltdown and Spectre vulnerabilities came while many people were still recovering from their New Year hangovers, catching some organisations by surprise. Microsoft has released guidance on how to respond to these vulnerabilities. However, this has once again highlighted the need to baseline system performance. One common side effect of patching for vulnerabilities is the potential performance impact – without a performance baseline this is hard to pinpoint.

The impact for those without a robust patching process or those running legacy versions of SQL Server is significantly heightened. SQL Server 2005 is no longer supported, leaving no guidance to mitigate the risk of such vulnerabilities. The industry, myself included, would recommend accelerating your upgrade plans. If you are struggling with patching or upgrading, WARDY IT Solutions can assist with our fixed-priced Data Platform services.

MyVirtualDBA: Single source of truth for the status of your SQL Servers

We know how important it is for our customers to maintain full visibility of their servers. With the Virtual DBA service, we look after the SQL Servers on behalf of organisations across Australia. For some customers, we are the DBA but for many, we’re working alongside an existing team.

MyVirtualDBA provides Virtual DBA customers a single point of truth for the status of their SQL Servers at no additional cost. We’ve included everything from real-time performance stats to full details of server errors. You maintain full visibility and see the ongoing performance improvements our team are making.

5 most common causes of SQL Server performance problems

With more than 100 years of SQL Server experience between them, we asked our Data Platform consultants to share their opinions on the most common causes of performance problems, and of course, how to avoid them. Read the post to arm yourself for your next performance tuning session.

Data Analytics for Community Care

The Community Care sector is facing a time of rapid change with the shift towards greater consumer choice. Community Care providers are striving to become more competitive than ever before. For many, this means identifying potential efficiency gains, delivering ever-better client services and empowering employees to make data-driven business decisions. But with limited reporting and siloed data this is near impossible, time consuming and error prone.

We’ve developed Care Insights, a data analytics platform designed solely for Community Care organisations. Care Insights plugs into your existing systems, giving you a single point of truth for you company data. No more jumping between systems or attempting to consolidate data from various sources into one spreadsheet. Learn more.

Balanced scorecards in Power BI

The Azure Database Migration Service is in public preview! It’s a fully managed migration service designed to work together with tools like Data Migration Assistant, Database Experimentation Assistant, and SQL Server Migration Assistant. The new service uses a guided, easy-to-implement process to streamline tasks and regular operations can continue as normal during the migration. Find out more.

Integrate SQL Server into your DevOps pipeline

Continuous Integration and Continuous Deployment allows teams to be more efficient and SQL Server fits seamlessly into this pipeline. SQL Server Data Tools (SSDT) allows you to design and deploy any SQL Server content type. If you prefer to work from within SSMS, it’s worth evaluating Redgate’s SQL Toolbelt.

Deploy SQL Server Integration Services packages to Azure

This tutorial by Microsoft provides steps for provisioning an Azure-SSIS integration runtime (IR) in Azure Data Factory. Then, you can use SQL Server Data Tools (SSDT) or SQL Server Management Studio (SSMS) to deploy SQL Server Integration Services (SSIS) packages to this runtime on Azure.