Newsletter Issue #73
|In this issue:
High Availability & Disaster Recovery Deep-Dive
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?
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:
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 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.
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.
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 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.
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.
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.
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.
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 - Specialising in building Microsoft SQL Server Solutions - 1300 WARDY IT
If you have been forwarded this newsletter and would like to subscribe then send an email to firstname.lastname@example.orgThis email has been sent to [email], to unsubscribe click
WARDY IT Solutions
Adelaide Office: Level 5, City Central, Tower 2, 121 King William Street, Adelaide SA 5000, Australia
Brisbane Office: 164 Wharf Street, Spring Hill QLD 4000, Australia
Canberra Office: Level 5, 7 London Circuit, Canberra ACT 2600, Australia Hobart Office: 175 Collins Street, Hobart TAS 7000, Australia
Melbourne Office: Level 1, Suite 9, 600 Lonsdale Street, Melbourne VIC 3000, Australia
Perth Office: 102 Walters Drive, Osborne Park WA 6017, Australia
Sydney Office: Level 2, 50 York Street, Sydney NSW 2000, Australia
phone: 1300 WARDY IT (927 394)
Copyright © 2013 wardyit.com. All rights reserved.