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

Denali Hotlap Denali Hotlap
New Head Office New Head Office
Analysis Services Roadmap Analysis Services Roadmap
Out of the Box SQL Server Features Out of the Box SQL Server Features
Microsoft Lifecycle Support Policy Microsoft Lifecycle Support Policy
SQL Server 2005 Service Pack 4 SSQL Server 2005 Service Pack 4
SQL Server Healthcheck SQL Server Healthcheck
Don’t get NABbed Don’t get NABbed
Backup, Integrity Check and Index Optimization Scripts Backup, Integrity Check and Index Optimization Scripts
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions was a member of the 2010 Deloitte Technology Fast 500 Asia Pacific

WARDY IT Solutions received recognition from the QLD Premier, Anna Bligh for excellence in the QLD ICT industry


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


Twas the night before Christmas, when all through the house not a creature was stirring, not even a mouse. The famous Christmas poem ‘Twas the night before Christmas’ describes many organisations during Christmas, as this festive season means that most organisations stop and put their feet up. However during this festive season while you have your feet up what’s going to happen to your SQL Server databases? Your SQL Server databases contain data which is the second most important assest in the organisation.


While you have your feet up this Christmas, WARDY IT Solutions award winning Virtual DBA solution will continue to be working 365x24x7 supporting some of the world's largest SQL Server sites. We are proud to announce that we have now opened an office in Johannesburg in order to ensure that no matter what time of the day or night you need award winning SQL Server support that there is someone waiting for your call. So if you experience an issue with your databases this Christmas WARDY IT Solutions is available on 1300 WARDY IT (927 394).


Although the sun is well and truly setting on 2010 there are a number of SQL Server announcements that will affect organisations in 2011. The first is the release of SQL Server 2005 Service Pack 4 and the second major announcement is the availability of the first Community Technology Preview (CTP) for Denali. Denali is the code-name for the next release of SQL Server. WARDY IT Solutions will be running the Denali Hotlap’s throughout Australia in February which will provide the first opportunity in Australia to explore this new release.


The team at WARDY IT Solutions would like to take this opportunity to thank you for your support during 2010 and wish you a happy and safe festive season, and a prosperous 2011.


To keep updated with all the WARDY IT Solutions news why not follow us on Twitter



Happy Reading & Best Wishes for the New Year

Peter Ward



Denali Hotlaps

SQL Server Denali is the codename for the next release of SQL Server. WARDY IT Solutions are proud to provide the first opportunity in Australia to explore the feature in the next release of SQL Server. The Hotlap will show how the changes in this release of SQL Server will improve database operations, developer efficiency and enable self-service Business Intelligence solutions. By attending a Hotlap session you will also be in the running to win your own hot lap in a V8 Supercar. To register for these Denali Hotlap's refer to here.


New Head Office

As the WARDY IT solutions team continues to expand we have outgrown our current premises. As a result from the 10th of January we will be relocating the Head Office of WARDY IT Solutions to 21 Quay Street, Brisbane. We will be moving into these new premises on the 10th of January. Make sure you keep an eye out for the open house in the new year. All of the existing contact details for WARDY IT Solutions will remain the same with the move.


Analysis Services Roadmap

At the PASS 2010 conference there were two major announcements for the future of Business Intelligence in SQL Server. The first was the new ad hoc reporting and data visualization experience codenamed “Project Crescent”. The second was a new Business Intelligence Semantic Model (BISM) in Analysis Services. To find out more about this new semantic model refer to here.


Out of the Box SQL Server Features

A new whitepaper has been released which showcases the features that are available out of the box (OTB) with SQL server versus other database platforms. It is interesting to compare what is available out of the box with SQL Server versus which feature other vendors only make available with the purchase of feature packs, options, or separate products. To find out more about this comparison refer to here.


Microsoft Lifecycle Support Policy

One of the areas where there is a lot of confusion is the supportability of SQL Server Service Packs. One thing to be aware of is that when a service pack for a product hits its “end of life date” you must upgrade to a newer service pack otherwise you will get limited troubleshooting technical support from Microsoft unless you purchase a customer support agreement. For more details regarding this policy refer to here.


SQL Server 2005 Service Pack 4

SQL Sever 2005 Service Pack 4 is now available for download. SQL Server 2005 SP4 includes SQL Server 2005 SP3 cumulative update 1 to 11. To download this service pack refer to here 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.


Don’t get NABbed

Almost a day does not go by when there is not another article about an organisation being unable to recover their data in a timely manner. Recently in Australia there have been a number of high profile examples of this including a Bank and an Airline. Not only do these incidents have a direct cost there is also an indirect cost associated with the damage to the organisations reputation. WARDY IT Solutions offers a number of services to ensure that your organisation is no on the front page of the paper due to people being unable to access their money or board their planes. To find out more about our SQL Server risk assessment contact us today here.


Backup, Integrity Check and Index Optimization Scripts

Ola Hallengren has developed a solution to assist in performing backup, integrity check and index optimizations SQL Server 2005 and above. The solution is based on stored procedures, functions, sqlcmd and SQL Server Agent jobs. To find out more about this solution refer to 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