Did you know? WARDY IT Solutions has more SQL Server Microsoft Certified Trainers than any other organisation in Australia WARDY IT Solutions Virtual DBA service was named one of Australia's 100 most innovative products or services

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

Once again WARDY IT Solutions has been recognized as Australia’s leading SQL Server consultants, trainers and Business Intelligence specialists.

WARDY IT Solutions has been awarded as a finalist for the Microsoft Australia Partner Awards (MAPA) Data Platform Partner of the Year Award. This prestigious award recognises Microsoft partners who have successfully delivered innovative solutions based on the Microsoft Data Platform.

To celebrate being awarded as a finalist for this prestigious award we are introducing a special offer for our popular Business Intelligence End-to-End course. For any registrations on the course in September we will provide a free 1/2 day of onsite post-course consulting. You can register for the Business Intelligence End-to-End course here. You can find details on all of our Microsoft SQL Server training here.

WARDY IT Solutions provides SQL Server training from the trenches. Not only is WARDY IT Solutions a premier authorised training channel for delivering learning products and services on Microsoft SQL Server technologies but each course is delivered by a Microsoft Certified expert who brings broad expertise from working in the field. Each WARDY IT Solutions SQL Server training course also comes with a Skills Protection Guarantee - meaning if a team member leaves within 6 months we will retrain the new team member for FREE.

You can keep updated on all the latest WARDY IT Solutions SQL Server news on Facebook & Twitter:

Happy Reading

Peter Ward

^top

Getting Value from SQL Server Monitoring

In this free breakfast on the 28th of September you will see how to reduce the cost of SQL Server monitoring and support. The core role of a Database Administrator is protecting the data assets of an organisation. However today's DBA is juggling many different roles and responsibilities; from day-to-day operational support through to project delivery. As a result of these conflicting priorities essential database monitoring is often overlooked. This breakfast will show how SQL Server 2008 R2 helps reduce monitoring and support costs. Register for this free breakfast here.

^top

SQL Server Denali CTP 3 Product Guide

^top

Database Maintenance for SharePoint 2010

There is a lot of confusion and misinformation about how to manage SharePoint 2010 databases. A new Microsoft White paper has been released that describes the recommended maintenance strategies for the databases that host content and configuration settings for SharePoint 2010 Products. This whitepaper can be found here.

^top

Expert SQL Server Training

Are you looking for deep SQL Server training from experts that work day-to-day in the trenches rather than someone that just follows the bouncing-ball? Each WARDY IT Solutions SQL Server training course is delivered by a consultant that works in the field on some of the largest SQL Server sites in Australia. You can download the full WARDY IT Solutions training schedule here and book online here for these not to be missed training events.

^top

SQL Server Columnstore Index FAQ

The SQL Server columnstore index feature (code-named Apollo) is a new feature to speed up data warehouse query processing that is being introduced in SQL Server code-named Denali. In many cases this feature can assist to increase query performance by a factor of 10 to 100. You can find out more about the columnstore index feature here.

^top

SQL Azure Delivery Guide

Are you thinking of using SQL Azure for your next project? The SQL Azure Delivery Guide provides a primer for solution implementers who are starting a project with SQL Azure. The delivery guide can be found here.

^top

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.

^top

SQL Server PDW using a Kimball Approach

Microsoft has released a new white paper that explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse (PDW), and how you would incorporate this new product as the cornerstone of your DW/BI system. This white paper can be found here.

^top

Running SQL Server with Hyper-V Dynamic Memory

Memory is a critical resource to Microsoft SQL Server workloads, especially in a virtualized environment where resources are shared and contention for shared resources can lead to negative impact on the workload. A new white paper has been released that describes the unique considerations that apply to virtual machines that run SQL Server workloads and the best practices that should be followed. This white paper can be downloaded from here.

^top

SQL Server Virtual DBA

WARDY IT Solutions Virtual DBA service was named one of Australia's 100 most innovative products or services, in one of the largest and most audacious innovation awards of its kind in Australia - the Anthill Magazine 'SMART 100' Index.

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?

^top