Loads of SQL Server tips as well as all the latest SQL Server news brought to you by Australia's leading SQL Server consultants, trainers and Business Intelligence specialists



WARDY IT Solutions
Newsletter Issue #73
WARDY IT Solutions
In this issue:

High Availability & Disaster Recovery Deep-Dive High Availability & Disaster Recovery Deep-Dive
SQL Server Quiz SQL Server Quiz
Power BI Power BI
Columnstore Indexes in SQL Server 2014 Columnstore Indexes in SQL Server 2014
Premium Windows Azure SQL Database Premium Windows Azure SQL Database
Resource Governor Monitoring Reports Resource Governor Monitoring Reports
SQL Server Healthcheck SQL Server Healthcheck
Troubleshooting SQL Server High CPU Usage Troubleshooting SQL Server High CPU Usage
Free Exam Voucher Free Exam Voucher
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions is an Authorised Prometric Testing Centre

WARDY IT Solutions has more Microsoft Certified Trainers than any other organisation in Australia.


Welcome to the July 2013 newsletter from Australia's leading SQL Server Consultants, Trainers and Business Intelligence specialists


People often comment that WARDY IT Solutions has won a lot of awards for our SQL Server excellence and want to know what this really means? Each award that we have won is testament to successfully delivering a cutting edge solution for a customer; whether it was deploying one of the first SQL Server 2012 Availability Groups in Australia to migrating multi-terabyte data warehouses from Business Objects to SQL Server or Big Data solutions we have done it.


By engaging WARDY IT Solutions for your SQL Server solutions you are guaranteed that we have the skills and expertise to successfully deliver a solutions and no matter how ‘big, bad or ugly’ the problem - more than likely we have already successfully solved the problem before.


So why would you trust your organisations data assets to anyone other than WARDY IT Solutions?


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



Peter Ward



High Availability & Disaster Recovery Deep-Dive

Allan Hirt is the author of the bestselling books Pro SQL Server Failover Clustering and Pro SQL Server High Availability. Allan is considered to be the foremost expert on Microsoft SQL Server High Availability and Disaster Recovery.


WARDY IT Solutions is proud to be brining Allan to Australia to present his exclusive 4 day Microsoft SQL Server High Availability & Disaster Recovery Deep-Dive workshop in October and November 2013 in Sydney and Melbourne:


  • Melbourne: 29 Oct to 01 Nov 2013

  • Sydney: 04 Nov to 07 Nov 2013


Book exclusive Allan Hirt SQL Server training


SQL Server Quiz

Are you looking to prove your SQL Server knowledge and have a chance to win a $50 Amazon gift voucher each week? Why not checkout SQL Server Quiz and put you knowledge to the test. Find our more here.


Power BI

Power BI for Office 365 provides everyone with powerful new ways to work with data in Excel and Office 365. Easily search, discover, and access data within and outside your organization and, with just a few clicks, shape and transform data. Analyse and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device. To find out more about how you can discover, analyse and visualize data with Power BI refer to here.


Columnstore Indexes in SQL Server 2014

In SQL Server 2012 memory optimized columnstore indexes were first introduced. Despite the query performance improvements obtained using columnstore indexes they had one significant disadvantage – they couldn’t be updated directly. In SQL Server 2014 this limitation has been removed from the columnstore indexes. To find out more about this and other changes to the columnstore indexes refer to here.


Premium Windows Azure SQL Database

A new Premium service for Windows Azure SQL Database that delivers more predictable performance for business-critical applications has recently been released. A white paper has been released which provides an overview of the Premium service for SQL Database and makes recommendations on how to determine the best reservation size for a Premium database. In addition, guidance is provided on how to tune your SQL Database application to get the most from the Premium service. You can find this white paper here.


Resource Governor Monitoring Reports

Resource Governor is a feature first introduced in SQL Server 2008 that can manage the consumption of CPU and memory resources. The SQL Server Premier Field team have developed a report that can measure the current state of Resource Governor usage and the current activity that is taking place. To find out more about how to visualize what is currently happening with resource consumption refer to here.


SQL Server Healthcheck

Does your SQL Server environment need a Healthcheck? The WARDY IT Solutions SQL Server Healthcheck is designed to review and verify the implementation of common SQL Server Best Practices. Our Database Healthcheck includes all the usage and administration aspects of a SQL Server database, ensuring that your SQL Servers are managed and operated well. Our approach is to analyse the total health of your SQL Server environment and highlight areas of concern, providing recommendations to improve the health and performance of your database environment. For more details on our SQL Server Healthcheck refer here.


Troubleshooting SQL Server High CPU Usage

Xperf/WPA is a powerful Windows tracing tool that can be used to assist in troubleshooting numerous issues on a Windows server. The utility allows for in depth tracing without the high overhead typically associated with such tracing. To find out more on how to use this utility to troubleshoot high SQL Server CPU Utilisation refer to here.


Free Exam Voucher

WARDY IT Solutions is offering a special offer on our SQL Server training in August - Book and pay for any Microsoft Official Curriculum course by the 30th of August 2013 and receive a FREE Prometric Exam Voucher. To take advantage of this offer contact us today.


SQL Server Virtual DBA

WARDY IT Solutions Virtual DBA service was named one of Australia's 100 most innovative products or services for the third year running in the Anthill Magazine 'SMART 100' Index.


Virtual DBA is a remote database administration service designed by WARDY IT Solutions to assist organisations with the management of Microsoft SQL Server. Our Virtual DBA service provides a cost effective solution to meet the day-to-day challenges of availability, performance and administration of Microsoft SQL Server databases. To find out more about the benefits of a Virtual DBA refer to here.


Something you may not know is that our Virtual DBA can be utilised for phone and email support. So, if your organisation just needs someone that they can call on for advice then why not use a Virtual DBA?


WARDY IT Solutions has a Gold Competency in both the Business Intelligence and Data Platform compentencies
WARDY IT Solutions 2013 Worldwide Data Platform Partner of the Year WARDY IT Solutions has been the MAPA Data Management Partner of the Year since 2009
WARDY IT Solutions
WARDY IT Solutions