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

MySQL Migration Assistant MySQL Migration Assistant
Microsoft Drivers for PHP for SQL Server Microsoft Drivers for PHP for SQL Server
24 Hours of PASS 24 Hours of PASS
Loading Data to SQL Azure Loading Data to SQL Azure
SQL Server Training SQL Server Training
TechEd Customer Drinks TechEd Customer Drinks
SQL Server Healthcheck SQL Server Healthcheck
Geo-Replication Performance Gains Geo-Replication Performance Gains
TechEd Online TechEd Online
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

View a recent video testimonial for a Business Intelligence solution WARDY IT Solutions implemented here

WARDY IT Solutions Virtual DBA manages some of the largest mission critical SQL Server sites in Australia


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


When working with customers to assist them to adopt SQL Server 2008 R2 there is one question that comes up time and time again - How to understand SQL Server 2008 R2 licencing and pricing. While assisting an organisation recently with a complex upgrade and consolidation scenario involving multiple editions, multiplexing and virtualisation we discovered a licencing guide from Directions on Microsoft. This licencing guide provides an easy to understand document to assist to demystify the new licencing for SQL Server 2008 R2. This licencing guide can be found here. If you would like to know more about how WARDY IT Solutions can assist to ensure you maximize your SQL Server licencing value then contact 1300 WARDY IT (927 394).


There are a numerous companies that claim to be Microsoft SQL Server specialists, however WARDY IT Solutions has demonstrated the fact that we are Australia’s leading SQL Server Consultants, Trainers and Business Intelligence specialists. Not only do we have the demonstrated industry experience, we also have the industry accolades to support our claim as well as the customer testimonials to match. This brochure details just some of the reasons why to choose WARDY IT Solutions to provide your SQL Server solutions.


Although SQL Server 2008 R2 was only released in April this year, the team at WARDY IT Solutions have already begun work with Microsoft on Denali which is the code name for the next release of SQL Server. Our team have been invited to work with the development team in Redmond to assist with the Software Design Review process. Our team has also been engaged to assist to develop the Microsoft Official Curriculum for SQL Server 2008 R2, this curriculum will be used to train 1000’s of people in SQL Server.


Microsoft TechEd Australia is Australia's largest annual technology event. The team at WARDY IT Solutions are proud that two of our employees have been selected to present at TechEd Australia. This is just another reason that WARDY IT Solutions is Australia’s leading SQL Server specialists.


If you will be attending TechEd Australia, make sure you stop in at our Exhibitor Stand to say hello to the team.


Happy Reading

Peter Ward



MySQL Migration Assistant

Microsoft has announced the release of the SQL Server Migration Assistant (SSMA) for MySQL. The SQL Server Migration Assistant for MySQL is the newest migration toolkit, others include Oracle, Sybase, Access, and an analyzer for PowerBuilder. These toolkits were designed to tackle the complex manual process when migrating databases. The MySQL SQL Server Migration Assistant can be downloaded from here.


Microsoft Drivers for PHP for SQL Server

Microsoft has recently announced an important interoperability milestone with the updated release of the Microsoft Drivers for PHP for SQL Server. In addition to accessing SQL Server, the updated drivers enable PHP developers to easily connect to and use Microsoft's cloud database offering, SQL Azure, as well as functionality like exposing OData feeds. The Microsoft Drivers for PHP for SQL Server 2.0 are available from here.


24 Hours of PASS

WARDY IT Solutions Chief Technical Architect, Peter Ward is one of the exceptional line-up of SQL Server and BI experts from around the world that will present a sneak peek of the PASS Summit 2010 in 24 free live webcasts between September 15-16. To register for this free event refer to here.


Loading Data to SQL Azure

Once you have set up a SQL Azure database, the next step is to load data into to this database. However there are a number of different techniques that can be used to perform this load. The SQLCAT team has recently written a blog post that outlines the different tools to maximize the data upload speeds to SQL Azure. This blog post can be found here.


SQL Server Training

If you are looking for SQL Server training from real world specialists then look no further the WARDY IT Solutions. All of our SQL Server trainers are consultants that assist to manage some of the largest SQL Server sites in the Asia-Pacific region. We have just release our training schedule for the remainder of 2010 including our Report Builder 3.0 course which is the only course of it's type being offered in Australia. To download the course schedule refer to here.


TechEd Customer Drinks

WARDY IT Solutions will be exhibiting at TechEd Australia. This year's event is being held at the Gold Coast Convention and Exhibition Centre from the 24-27th of August. We will be hosting customer drinks on Wednesday night from 7:30pm in Broadbeach. To register for these drinks email contact@wardyit.com, or why not pop into the WARDY IT Solutions exhibitor stand.


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.


Geo-Replication Performance Gains

As communication links provide more and more flexibility organisations are looking to explore the use of Geo-Replication between data centres. With SQL Server 2008 and Windows Server 2008 there was an order of magnitude of performance improvement. In a recent test Microsoft.com Engineering Operations was able to achieve a 100 times increase in performance between Washington and Ireland. To read about the performance improvements in Geo-Replication refer to here.


TechEd Online

If you were unable to make it to the recent TechEd North America and the Business Intelligence Conference in New Orleans then don’t despair. As much of the content was recorded and is available to view and download at TechEd Online. The Data Platform track can be found here and the Business Intelligence track can be found here.


SQL Server Virtual DBA

For the second year running our Virtual DBA was a finalist in the QLD Australian Computer Society Awards QLD ICT Awards for Service Delivery and Training. Virtual DBA was also nominated as a finalist for the QLD AIIA iAwards.


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 is a Microsoft Gold Certified Partner
WARDY IT Solutions is the APC 2009 Microsoft Data Management Partner of the Year
WARDY IT Solutions
WARDY IT Solutions