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 #80
WARDY IT Solutions
In this issue:

Allan Hirt Mission Critical Deep Dive Allan Hirt Mission Critical Deep Dive
SQL Server 2014 Training SQL Server 2014 Training
Operations Management Suite Operations Management Suite
Azure SQL Data Warehouse Azure SQL Data Warehouse
Mission Critical Performance and Scale White Paper Mission Critical Performance and Scale White Paper
End of Extended Support for SQL Server 2005 End of Extended Support for SQL Server 2005
SQL Server Healthcheck SQL Server Healthcheck
SQL Server 2016 Hotlap SQL Server 2016 Hotlap
Microsoft Azure Data Factory Microsoft Azure Data Factory
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions is an Authorised Pearson VUE Testing Centre

WARDY IT Solutions is a Gold Microsoft Partner in both Data Platform and Data Analytics


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


As enterprises rapidly look at how they can start to leverage cloud solutions for their data platform and data analytic solutions there is a need for trusted partners that can assist with the migration of the these key workloads. WARDY IT Solutions continues to demonstrate that they are the true leader in Microsoft SQL Server Big Data, Data Platform and Business Intelligence solutions in Asia Pacific. WARDY IT Solutions was recently awarded the global winner of the HP and Microsoft Outstanding Frontline Partner Award for 2015 in Big Data and as a Finalist in the 2015 Microsoft Australia Partner Awards for the Excellence in Business Insights and Data Award.


WARDY IT Solutions is one of the only SQL Server specialists that can assist with the entire length and breadth of Microsoft SQL Server from Data Platform and Data Analytics through to training and ongoing support and maintenance. WARDY IT Solutions will be presenting a first look at the next generation of SQL Server as part of our SQL Server 2016 Hotlap’s running throughout Australia in September.


Also of note is that WARDY IT Solutions is now part of the WARDY Group. The WARDY Group is a group of the best of breed technology company’s focusing on delivery industry leading solutions on the Microsoft platform and includes not only WARDY IT Solutions but also MrCRM delivering Microsoft Dynamics solutions and MOC Training delivery Microsoft Instructor Led Training.


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



Peter Ward



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 today.


SQL Server 2014 Training

WARDY IT Solutions is the leading provider of the SQL Server 2014 training course Updating Your SQL Server Skills to MS SQL Server 2014 (Course Code 10977). This five-day instructor-led hands on course is delivered by our expert specialist Consultant trainers and teaches participants how to use the enhancements and new features that have been added to SQL Server since the release of SQL Server 2008. To find out more about this and other SQL Server training course refer to here.


Operations Management Suite

The Operations Management Suite (OMS) is a collection of IT management solutions powered by a modern cloud-based management platform that enables you to gain visibility on deployments across both cloud and on-premises. It also helps you take control of your IT environment by remediating problems and orchestrating complex and repetitive operations through automation. Included in OMS is the SQL Assessment which evaluates the configuration and assesses the health of your SQL Server deployments. To find out more about the OMS refer to here.


Azure SQL Data Warehouse

With growing data volumes there is a need to take advantage of the cost-efficiencies, elasticity and hyper-scale of cloud for large data warehouses. With Azure SQL Data Warehouse you can take advantage of the cloud and work with your existing infrastructure and tools, utilize your current skills and integrate with many sources of data. To find out more about Azure SQL Data Warehouse refer to here.



Mission Critical Performance and Scale White Paper

As the volume and complexity of data continue to increase, organizations require a new approach to their mission-critical capabilities. Microsoft has released a new white paper that examines how capabilities built into Microsoft SQL Server including enterprise-grade security, availability and performance, along with support for a full range of complex data types define a new level of mission critical performance. You can download this white paper from here.


End of Extended Support for SQL Server 2005

Extended support for SQL Server 2005 ends on April 12, 2016. If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates. Now is the time to upgrade to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. To find out more about your options and how to upgrade from SQL Server 2005 contact WARDY IT Solutions today.


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.


SQL Server 2016 Hotlap

WARDY IT Solutions is proud to announce that they will be delivering the first SQL Server 2016 workshops in Australia. The workshops will be conducted as a free 2 hour Hot Lap. A Hot Lap is a quick and concise way of finding out what is new in SQL Server 2016 and how these changes will improve database operations, developer efficiency and enable self-service Business Intelligence solutions. Find out more about the Hotlap’s being run in September here.


Microsoft Azure Data Factory

Azure Data Factory is a fully managed cloud-based data integration service that orchestrates and automates the movement and transformation of data. It is part of a family of state-of-the-art cloud analytics products including Azure Data Catalog, Azure Machine Learning, HDInsight, Power BI, and Azure Stream Analytics that are helping transform data into intelligent action. To find out more about Azure Data Factory refer to here.


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.


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 an Australian SQL Server Partner of the Year since 2009
WARDY IT Solutions
WARDY IT Solutions