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

June has been a great month for the WARDY IT Solutions team throughout Australia. In June we have been awarded with three prestigious industry awards. WARDY IT Solutions was awarded the HP and Microsoft Outstanding Frontline Partner for 2013 in Big Data and for the third year running our SQL Server support solution known as Virtual DBA was awarded as one of the top 100 most innovative solutions in Australia. However the award that we are most proud of is being recognized as the Worldwide Microsoft Data Platform Partner of the Year!

The WARDY IT Solutions team is the team behind Australia's industry leading Microsoft SQL Server conference SQL Server InFocus. The conference is being held at Jupiter's, Gold Coast on the two days prior to Microsoft TechEd Australia on the 2nd and 3rd of September to allow you to maximize your professional development investment. SQL Server InFocus will feature over 24 deep-dive sessions from industry leading experts from around the globe running in two tracks, Business Intelligence and Data Platform. This conference will provide with real-world information to empower you as a SQL Server professional and provide you with unparalleled opportunities to develop connections with peers and experts. Registration is now available so make sure you save the date in your calendar.

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

^top

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.

^top

SQL Server Analysis Services Multidimensional Deep Dive

• Sydney: 23 July - 26 July 2013

• Melbourne: 29 July - 1 August 2013

There are a limited number of places remaining on these courses so make sure you book now to avoid disappointment.

^top

SSRS Reports on an iPad

If you are thinking about using SQL Server Reporting Services (SSRS) on a mobile device then you should checkout this new video that demonstrates how to view a Reporting Services report on an iPad. You'll learn how to access reports from the report server and from email, use touch to collapse and expand row groups, sort columns, and filter data using parameters, and export the report to different formats. You can view this video here.

^top

Performance Guidance for SQL Server in Windows Azure

A new white paper has been released that discusses the key factors to consider when evaluating performance and planning a migration to SQL Server in Windows Azure Virtual Machines. The white paper also provides best practices and techniques for performance tuning and troubleshooting when using SQL Server in Windows Azure Infrastructure Services. You can download this white paper from here.

^top

Migrating from MySQL to SQL Server 2012

If you are thinking of migrating from MySQL to SQL Server then make sure you checkout the migration guide. In this guide you will learn the differences between the MySQL and the SQL Server 2012 database platforms and the steps necessary to convert a MySQL database to SQL Server 2012. You can download this guide from here.

^top

SQL Server 2012 Licensing Guide

One area where there is still a lot of confusion with SQL Server 2012 is licencing. The SQL Server 2012 Licensing Guide provides an easy to understand overview of how Microsoft SQL Server 2012 is licensed through Microsoft Volume Licensing programs. You can download this Licensing Guide from here here.

^top

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.

^top

SQL Server 2014 In-Memory OLTP

In-Memory OLTP (formally known as code name 'Hekaton') is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve remarkable improvements in performance and reduction in processing time. You can find out more about this new technology in SQL Server 2014 here.

^top

Training from the Trenches

WARDY IT Solutions is offering a special offer on our SQL Server training in July - Book & pay for 10 days of training on any scheduled course by the 30th of July 2013 and receive a FREE Microsoft 64 GB Surface with Windows RT. To take advantage of this offer contact us today.

^top

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.

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?

^top