Newsletter Issue #61
|In this issue:
Getting Value from SQL Server Monitoring
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 - Specialising in building Microsoft SQL Server Solutions - 1300 WARDY IT
If you have been forwarded this newsletter and would like to subscribe then send an email to firstname.lastname@example.orgThis email has been sent to [email], to unsubscribe click
WARDY IT Solutions
Brisbane Office: Level 2, 21 Quay Street, Brisbane QLD 4000, Australia
Hobart Office: 175 Collins Street, Hobart TAS 7000, Australia
Melbourne Office: Level 1, Suite 9, 600 Lonsdale Street, Melbourne VIC 3000, Australia
Perth Office: 102 Walters Drive, Osborne Park WA 6017, Australia
Sydney Office: Level 2, 50 York Street, Sydney NSW 2000, Australia
phone: 1300 WARDY IT (927 394)
Copyright © 2011 wardyit.com. All rights reserved.