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

SQL Server 2008 R2 Best Practices Analyzer SQL Server 2008 R2 Best Practices Analyzer
Big Data Big Data
SQL Server Consolidation Breakfast SQL Server Consolidation Breakfast
Loading Data to SQL Azure Migrating to Reporting Services
SQL Server 2008 R2 Training SQL Server 2008 R2 Training
Houston Houston
SQL Server Healthcheck SQL Server Healthcheck
SQL Server Most Secure Database SQL Server Most Secure Database
ROLAP for SQL Server Data Warehouses ROLAP for SQL Server Data Warehouses
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 has created a Silverlight Business Intelligence solution to track Twitter trends. The Twitter trends for TechEd can be found here


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


The last month has seen some very exciting times for the team at WARDY IT Solutions. Below are just some of the highlights:

  • A BI solution developed for one of our customer’s solutions was showcased in iTWire
  • The Twitter BI Solution we developed for TechEd will be showcased at the PASS Summit 2010, the world’s largest SQL Server conference
  • Peter Ward was awarded the recipient of the 2010 Pearcey Queensland Award. This award recognises and celebrates the achievements of Australia's ICT and Digital Media entrepreneurs.


The awards and accolades that we continue to receive demonstrates our recognized position as Australia’s leading SQL Server Consultants, Trainers and Business Intelligence specialists.


Over the last month we have also been working with a number of customers on their SQL Server roadmap and how they can align their database upgrade cycle with the 18 month release cycle for SQL Server. WARDY IT Solutions is in the privileged position that we have already started working with the next release of SQL Server, codenamed “Denali”. Due to our deep understanding of SQL Server the WARDY IT Solutions team were invited to Redmond to work with the Microsoft SQL Server development team and undertake a Software Design Review on many of the new features in “Denali”. So if you are looking to upgrade your version of SQL Server then WARDY IT Solutions is in a position to help you migrate today and develop a roadmap to allow you to seamlessly move to the next release when it is available.


Also stay tuned for next month’s SQL Server newsletter we will be showcasing some of the brand new features of our award winning Virtual DBA service. Virtual DBA is a remote database administration service designed by WARDY IT Solutions to assist your organisation with the management of your Microsoft SQL Server.


Happy Reading

Peter Ward


PS. If you are in Brisbane don't miss out on our SQL Server Consolidation breakfast where you will learn how to use SQL Server as a Service.



SQL Server 2008 R2 Best Practices Analyzer

The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instances and determines if the configurations are set according to the recommended best practices. The SQL Server 2008 R2 Best Practices Analyzer can be downloaded from here.


Big Data

Ten years ago, a single gigabyte of data seemed like a vast amount of information. Now, we commonly hear of data stored in terabytes or petabytes. The recent Aspen Institute Roundtable on Information Technology looked at how to analyse this data explosion. A whitepaper on this analysis of "Big Data" can be found here.


SQL Server Consolidation Breakfast

WARDY IT Solutions is running a Free SQL Server breakfast in Brisbane on Wednesday the 20th of October. In this session you will see how multiple SQL Server instances can be consolidated utilising SQL Server as a Service. You can register for this event here.


Migrating to Reporting Services

If you are looking to migrate from other reporting platforms to SQL Server Reporting services a new portal has been created to provide resources to assist with the migration. The Reporting Services Migration portal can be found 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.



Microsoft Project Code-Named “Houston” is a light weight database management tool for SQL Azure. Houston can be used for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data. You can start using CTP1 of Houston 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.


ROLAP for SQL Server Data Warehouses

The SQLCAT have released a new whitepaper that shows the advantages and disadvantages of ROLAP in comparison with Multidimensional OLAP (MOLAP), and evaluates various ROLAP-related data warehouse optimization techniques regarding their effectiveness and limitations. This whitepaper 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