Loads of SQL Server tips as well as all the latest SQL Server news brought to you by Australia's Leading SQL Server Consultants and Trainers
WARDY IT Solutions
Newsletter Issue #48
WARDY IT Solutions
In this issue:

SQL Server Training Schedule SQL Server Training Schedule
SQL Server Plan Cache SQL Server Plan Cache
Australian ALM Conference Australian ALM Conference
Hobart SQL Server User Group Hobart SQL Server User Group
Server Consolidation Guidance Server Consolidation Guidance
SQL Server 2008 R2 Upgrade Guidance SQL Server 2008 R2 Upgrade Guidance
SQL Server Healthcheck SQL Server Healthcheck
SQL Server in the Magic Quadrant SQL Server in the Magic Quadrant
Migration Assistant for MySQL Migration Assistant for MySQL
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions is running the first PowerPivot training in Australia

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


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


2010 will mean a number of changes for organisations with the release of SQL Server 2008 R2 along with SharePoint and Office 2010. The release date for the next version of SQL Server, SQL Server 2008 R2 has been announced as May 2010, so now is the time to start planning the roadmap to implement this new version of SQL Server. If you are trying to work out what these changes mean to your organisation you should contact WARDY IT Solutions who are clearly Australia’s leading SQL Server consultants, trainers and Business Intelligence specialists.


WARDY IT Solutions was the first to market with a SQL Server 208 R2 workshop in Australia - SQL Server Hotlap. We are also the first company in Australia to offer training in PowerPivot. PowerPivot is a new feature in SQL Server 2008 R2 which allows businesses to concentrate on the analysis and presentation of data in order to meet their immediate needs. We have also implemented a SQL Server 2008 R2 solution for one of Australia’s largest Federal government agencies.


Even if you are not thinking of implementing SQL Server 2008 R2, the announcement of Service Pack 4 for SQL Server 2005 and Service Pack 2 for SQL Server 2008 being released in Quarter 4 and Quarter 3 in 2010 respectively will mean you are not isolated from changes to SQL Server.


Now is the perfect opportunity to review your SQL Server environment to ensure that you are in a position to manage this change. Peter Hrstich from the Queensland Police Service had the following to say about a recent SQL Server review WARDY IT Solutions performed; “The level of service, commitment and result were unsurpassed what I have seen from a company for a long time”.


If you want to know more about how Australia’s leading SQL Server business can help you organisation then why not grab my ear at the SQL Server 2008 R2 workshops that I am running along the East-Coast of Australia for Microsoft at the of March.


To keep updated with all the WARDY IT Solutions news why not follow us on Twitter - http://www.twitter.com/wardyit


Happy Reading

Peter Ward


SQL Server Training Schedule

WARDY IT Solutions has developed the following exclusive SQL Server courses including the first PowerPivot training course to be delivered in Australia:

  • Brisbane - 5th May - SQL Server Administration Essentials
  • Brisbane - 12th May - SQL Server Developer Essentials
  • Brisbane - 14th May - SQL Server Business Intelligence Launchpad
  • Brisbane - 18th May - SQL Server Reporting Services
  • Brisbane - 21st May - Integrating SQL Server with SharePoint
  • Brisbane - 25th May - SQL Server 2008 R2 Step-up
  • Brisbane - 26th May - SQL Server 2008 R2 PowerPivot

For more details and to register for these courses email contact@wardyit.com.


SQL Server Plan Cache

Microsoft has recently released a new white paper that explains how SQL Server 2008 allocates memory for plan caching, how query batches are cached and suggests best practices on maximizing reuse of cached plans. To download this white paper refer to here.


Australian ALM Conference

The first annual Australian ALM Conference which incorporates Microsoft Australia's Official Launch event for Visual Studio 2010 is being held in Sydney from the 12th to 13th of April. There will also be two days of post conference training available including a 2 day course of Agile Database Development. For more details on this conference and to register your interest refer to here.


Hobart SQL Server User Group

After a six month hiatus WARDY IT Solutions will be re-launching the Hobart SQL Server User Group. The Hobart SQL Server User Group will be held at lunchtime every second month on the second Thursday. The March SQL Server User Group will be held at WARDY IT Solutions Hobart office. For more details on this event refer to here.


Server Consolidation Guidance

Consolidation in general terms is the combining of various units into more efficient and stable larger units. When applied to SQL Server, consolidation specifically translates into improved cost efficiency from higher utilization of resources. Microsoft has recently released a white paper on the consolidation for SQL Server which can be downloaded from here.


SQL Server 2008 R2 Upgrade Guidance

Are you thinking of upgrading or implementing SQL Server 2008 R2? WARDY IT Solutions have developed 2-Day SQL Server 2008 R2 upgrade assessment to ensure upgrading SQL Server is a seamless process and that organisations can take advantage of the new features introduced in SQL Server 2008 R2. To find out more email contact@wardyit.com.


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 in the Magic Quadrant

The team at WARDY IT Solutions work on some of the largest BI sites in Australia and we believe SQL Server 2008 is the platform of choice for customers of all sizes who want enterprise-class benefits with the highest levels of security, reliability, and scalability for the lowest possible Total Cost of Ownership. Well it looks like Gartner agrees with us and has positioned SQL Server in the Magic Quadrant for Data Warehouse Database Management Systems. You can view the full Gartner Report here.


Migration Assistant for MySQL

The Microsoft SQL Server Migration Assistant (SSMA) 2008 is a new toolkit that has been released that can assist with migrating from MySQL to SQL Server 2008 and SQL Azure. To find out more about this free toolkit refer to here.


SQL Server Virtual DBA

Virtual DBA was recently featured at the Microsoft Enterprise Product Roadmap Event. To find out more about our participation in this event refer to here.


Virtual DBA was a finalist in the QLD Australian Computer Society Awards QLD ICT Awards for Service Delivery and Training.


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 service 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