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

QLD SQL Server User Group QLD SQL Server User Group
Windows Azure Marketplace DataMarket Windows Azure Marketplace DataMarket
SQL Server Backup Simulator SQL Server Backup Simulator
Visio Forward Engineer Add-in for Office 2010 Visio Forward Engineer Add-in for Office 2010
SQL Server 2008 R2 Training SQL Server 2008 R2 Training
SQL Server 2008 Service Pack 2 SQL Server 2008 Service Pack 2
SQL Server Healthcheck SQL Server Healthcheck
SQL Server Most Secure Database SQL Server Most Secure Database
Melbourne Office Melbourne Office
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

See what one of our customers says about our Virtual DBA solution and how it provided strategic benefits here

WARDY IT Solutions was proud sponsors of the Perth2Sydney charity ride and created a reporting solution to track the riders


One of WARDY IT Solutions SQL Server consultants Warwick Rudd has joined the cause for Movember and men's health. You can sponsor Warwick and his Mo here


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


There is one word on the lips of every IT executive today and that is Cloud. Despite the Cloud being a new term for many organisations WARDY IT Solutions have been designing and building cloud solutions for SQL Server since the release of SQL Server 2008. Our Private Cloud solutions for SQL Server allow you to achieve elasticity in your database environment by reducing the SQL Server footprint and providing 'SQL Server as a Service'. WARDY IT Solutions have just released a new Readiness Assessment workshop to help you realise the benefits of 'SQL Server as a Service'. For more details about this offering contact us today on 1300 927 394.


October has seen a number of changes in the Microsoft Partner Programme. One of the core visions of the Microsoft Partner Programme has always been to provide expertise to help serve customers better. The changes from the Microsoft Partner Programme to the Microsoft Partner Network are designed to allow Microsoft Partners to demonstrate higher levels of capability and expertise. WARDY IT Solutions is proud of the fact that we have continued to maintain our status with a Gold competency despite the changes. So next time you are in need of a SQL Server expert check that they have achieved a Gold competency in the new Microsoft Partner Network.


Data is an organisations second most important asset, however who will be looking after your data this Christmas? As we start to get closer to the end of the year many of us are starting to think about our Christmas holidays. However despite many people being on leave over the festive season your database environment does not get a break. For many organisations Christmas sees the highest transaction throughput of the year. WARDY IT Solutions have introduced a special offer to allow you to know that your SQL Server databases are being supported and managed this Christmas. To find out more refer to here or why contact WARDY IT Solutions today on 1300 927 394.



Happy Reading

Peter Ward



QLD SQL Server User Group

In the November QLD SQL Server User Group you will have the opportunity to learn about SQL Server Integration Services (SSIS) and how to build on what is provided out of the box. To register for this free event refer to here.


Windows Azure Marketplace DataMarket

Microsoft has released the Windows Azure Marketplace DataMarket which previously had the codenamed “Dallas”. DataMarket provides a wide range of content from authoritative commercial and public sources in a single marketplace, making it easier to find and purchase the data that you need to power your applications and analytics. To find out more about this new data source refer to here.


SQL Server Backup Simulator

The SQL Server Backup Simulator is a tool that has been introduced by the SQL Server support team which will help you while troubleshooting issues in taking a backup of SQL Server using 3rd party VDI utilities like Symantec BackupExec, Quest Litespeed and Redgate SQL Backup. The Backup Simulator can be downloaded from CodePlex and is available here.


Visio Forward Engineer Add-in for Office 2010

Visio Forward Engineer is an Office 2010 add-in that provides Visio the ability to script the database creation of a data model. This Visio add-in can be downloaded from here.


SQL Server 2008 R2 Training

If you are looking for SQL Server 2008 R2 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.


SQL Server 2008 Service Pack 2

SQL Server 2008 Service Pack 2 (SP2) is now available for download. The service pack for all editions can be downloaded from here and the updated feature pack can be downloaded from here.


With SP2 applied, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server. Also instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied.


WARDY IT Solutions have an exclusive 1/2 day SQL Server 2008 Service Pack 2 Readiness Assessment to allow you to seamlessly deploy this new Service Pack and take advantage of the new features. For more information contact us here.


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 Most Secure Database

In a recent ITIC study it was shown that SQL Server is the most secure database server since 2002 and Oracle has recorded the most number of security vulnerabilities of any of the major database platforms over the last eight years. Full details of this study can be found here.


Melbourne Office

WARDY IT Solutions continues to expand throughout Australia and has just opened an office in Melbourne. This office is WARDY IT Solutions fifth Australian office and this office complements our existing offices in Brisbane, Hobart, Perth and Sydney.


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