The latest SQL Server news from WARDY IT Solutions.
            
Not rendering correctly? View this email as a web page here.
            
Call us today: +61 7 3054 5300
    
Allan Hirt Mission Critical Deep Dive Event

What's On @ WARDY IT Solutions!

The latest SQL Server news, updates, training and event details.

Hi there,

Welcome to the January 2016 newsletter from Australia's leading SQL Server Consultants, Trainers and Business Intelligence specialists.

Organisations are always looking for new and innovative ways that they can ensure continual business improvement and maximize the investments in their Data Assets.  WARDY IT Solutions continues to be a thought-leader in assisting organisations deliver Business Intelligence and Advanced Analytics solutions that deliver this vision.  Recently WARDY IT Solutions has assisted A2 Milk Company improve sales ROI with analytics that reveal deep insights into international sales performance.  You can find out more in this recent case-study that showcases this solution.

WARDY IT Solutions has been recognised as one of Australia’s leading Microsoft Power BI Partners. This recognition is based on numerous successful implementations of Power BI that have delivered business value and provided rich visualisations and insights.

WARDY IT Solutions is also proud to have founded the QLD Power BI User Group  with the inaugural meeting on Thursday 11 February 2016 (full details here).  If you want to know more about Power BI and how it can assist in unlocking business insights then contact the proven Power BI Experts, WARDY IT Solutions.

You can stay updated on all the latest WARDY IT Solutions SQL Server news on Facebook & Twitter:

Regards,
Peter 

Peter Ward
Managing Director
WARDY IT Solutions

Gartner Magic Quadrant for Advanced Analytics Platforms

Predictive analytics and other types of advanced analytics technology are becoming major factors in the analytics market. This Magic Quadrant evaluates 16 leading providers of advanced analytics platforms that are used to build solutions from scratch. Find out more about how Microsoft is a visionary in this area here.

Allan Hirt Mission Critical Deep Dive

Whether your business hours are 9 to 5 or 24x7x365, your systems need to be up when the business requires them. This advanced 4-day workshop, designed for SQL Server professionals and IT administrators alike, will not only teach you the technical and non-technical things you need to have for solid high availability and disaster recovery solutions, but also show you demonstrations and hands-on labs with multiple versions of SQL Server. Planning, implementing, and administering of the solutions will be covered, and will be taught by Cluster MVP, author, and SQL Server high availability expert Allan Hirt. There are limited places on these workshop so register here today.

Query Store

Query Store is a new feature in SQL Server 2016, and Azure SQL Database V12. It’s designed to help you with query performance troubleshooting.  As your database grows in size it is not unusual to experience performance regressions. Without the ability to see all the changes in the query plans it’s difficult to figure out why regressions happen and what you can do to prevent them in the future.  Query store is designed to simply to this troubleshooting by providing the equivalent of a black box flight recorder.  To find out more about this feature refer to here.

Backing up DocumentDB Databases

Backing up is a basic building block of a Business Continuity and Disaster Recover (BCDR) plan, and something you absolutely cannot afford to get wrong.  Through engagement with customers Microsoft has devloped and verified backup strategies to enable all customers to build a successful BCDR plan. To find out more about these back strategies refer to here.

SQL Server Security

Security is unquestionably a major priority for Microsoft. A recent news story reported that Microsoft is spending over $1 billion a year to make Microsoft products more secure.  The Microsoft data platform, including SQL Server and Azure SQL Database, is at the top of the list of products investing in security. To find out more about SQL Server Security refer to the Security Center for SQL Server Database Engine and Azure SQL Database.

Running R Scripts in Power BI

With just a few steps in Power BI Desktop you can run R scripts and create a data model, from which you can create reports, and share them on the Power BI service.  Find out more about how you can use R with Power BI, click here.

Analyze Data History Using Temporal Tables

Temporal Tables are a new feature in SQL Server 2016 that provides insights from historical data. Temporal Tables allow you to track the full history of changes without additional code and lets you focus your data analysis on a specific point in time in a very simple and efficient way. Find out more about Temporal Tables refer to here.

Power BI Mobile App

The Power BI Mobile App provides access to all of your data from both SQL Server Reporting Services 2016 on-premises and Power BI in the cloud. You can download and find out more this rich visualization experience for mobile devices here.

MAPA 2013

If you've got any questions, please feel free to send me an email anytime. Just hit Reply.

You may also be interested in:

SQL Server Health Check