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

Getting Value from SQL Server Monitoring Getting Value from SQL Server Monitoring
Diagnosing and Resolving Latch Contention Diagnosing and Resolving Latch Contention
Semantic Search Semantic Search
Expert SQL Server Training Expert SQL Server Training
SQL Server Project Crescent Demo SQL Server Project Crescent Demo
Business Decision Appliance Business Decision Appliance
SQL Server Healthcheck SQL Server Healthcheck
Support changes for SQL Server 2000 Support changes for SQL Server 2000
Optimizing SQL Server for Private Cloud Optimizing SQL Server for Private Cloud
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

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

 

WARDY IT Solutions has been the MAPA Data Management Partner of the Year since 2009

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

 

In last month’s newsletter we announced that WARDY IT Solutions was nominated as a finalist for the (MAPA) Data Platform Partner of the Year Award, well we are proud to announce that we are the WINNER of this prestigious award. This award recognises WARDY IT Solutions as Australia's leading solution provider for Microsoft SQL Server. WARDY IT Solutions is proud to have won this prestigious award since 2009!

 

On the back of the (MAPA) Data Platform Partner of the Year Award WARDY IT Solutions has been bestowed with a number of additional awards in the last month including:

  • WARDY IT Solutions has been recognized as a finalist for the Best Vendor Tech Support in the 2011 SQL Server Magazine Community Choice Awards
  • Peter Ward was awarded as the Microsoft V-TSP of the Year in recognition of the relationship that WARDY IT Solutions has with Microsoft

Due to the depth of our SQL Server skills WARDY IT Solutions are able to offer services that no one else in Australia can, including our SQL Server Failover Clustering course. This course is the only course of its kind in Australia and is the WARDY IT Solutions course of the month.

 

This one day Essentials course in Brisbane on 27 of September is designed to demystify failover clustering and help SQL Server DBA's understand SQL Server availability through failover clustering to ensure that mission critical SQL Server environments are highly available. For more details on this course refer to here.

 

On the topic of training WARDY IT Solutions is proud to be brining Kalen Delaney to Australia to present her exclusive 5 day SQL Server Internals & Query Tuning workshop in March 2012 in Brisbane and Sydney. Kalen is the author of the bestselling books SQL Server 2008 Internals, Inside SQL Server 2005: The Storage Engine and Inside SQL Server 2005: Query Tuning and Optimization and is considered to be the foremost expert on Microsoft SQL Server internals. You can find out more information and book on this exclusive course here. You can find out more about the early bird special until the 31st of October here.

 

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

Diagnosing and Resolving Latch Contention

A new white paper has been released that provides in-depth information about the methodology that the Microsoft SQL Server Customer Advisory Team (SQLCAT) team uses to identify and resolve issues related to page latch contention observed on high-concurrency systems. This white paper can be downloaded from here.

^top

Semantic Search

Semantic Search is a new feature in SQL Server code-named Denali that adds additional intelligence to the FullText search by looking at the relationships between words and in and across each document. You can find out more about this new feature 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 Project Crescent Demo

Project Crescent is a new ad-hoc visualization tool that is part of Reporting Services in SQL Server code-named Denali. Project Crescent is designed for end users allowing them to quickly, easily, and visually explore their data and answer ad-hoc questions in just a few clicks. A video on the power of Project Crescent can be found here.

^top

Business Decision Appliance

The HP Business Decision Appliance is a solution optimized for Microsoft SQL Server 2008 R2 and Microsoft SharePoint Server 2010. The appliance takes the guess work out of sizing appropriate infrastructure for the workload and provides seamless configuration of the Microsoft Business Intelligence platform. To find out more about the Business Decision Appliance refer to 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

Support changes for SQL Server 2000

Are you still running SQL Server 2000? Well now is the time to migrate to SQL Server 2008 R2 as from the 13th of April 2013 Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will no longer be supported. Updates to this software will stop and so you will no longer receive patches including security updates. To find out more about the support lifecycle for SQL Server 2000 refer to here

^top

Optimizing SQL Server for Private Cloud

WARDY IT Solutions offers a comprehensive solution for optimizing your databases for Private Cloud. Optimizing SQL Server for Private Cloud solutions will help ensure that your computer, network and storage resources are used efficiently, reducing physical footprint, as well as capital and operational expenses. To find out more about optimizing your databases for Private Cloud refer to 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.

 

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?

^top

WARDY IT Solutions has a Gold Competency in both the Business Intelligence and Data Platform compentencies
WARDY IT Solutions has been the MAPA Data Management Partner of the Year since 2009
WARDY IT Solutions
WARDY IT Solutions