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

Analyzing I/O Characteristics Analyzing I/O Characteristics
Free Brisbane SQL Server Breakfast Free Brisbane SQL Server Breakfast
IPD Guide for SQL Server IPD Guide for SQL Server
SQL Server 2008 R2 Best Practices Analyzer SQL Server 2008 R2 Best Practices Analyzer
Master Data Services eClinic Master Data Services eClinic
Hobart SQL Server 2008 R2 Launch Hobart SQL Server 2008 R2 Launch
SQL Server Healthcheck SQL Server Healthcheck
Business Intelligence Conference Keynote Business Intelligence Conference Keynote
TechEd Early Bird Discount TechEd Early Bird Discount
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions was a finalist for the QLD AIIA iAwards


WARDY IT Solutions Virtual DBA manages some of the largest mission critical SQL Server sites in Australia

 

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

 

In Australia the 30th of June not only indicates the half year mark for the year but it also marks the end of Financial Year. While the New Year is the traditional time for making personal resolutions such as losing weight and exercising more; the end of the Financial Year signals an opportunity for businesses to review the year that was and plan for the year ahead.

 

Does your planning for the new financial year include upgrading your SQL Server environment to SQL Server 2008 R2? If not then perhaps you should read the Forrester Consulting paper on the Total Economic Impact Of SQL Server 2008 Upgrade.

 

Can you organisation afford to miss out on these benefits that were achieved by upgrading to SQL Server 2008:
  • ROI - A risk-adjusted ROI of 162% with a breakeven point (payback period) of six months after deployment
  • Benefits - The risk-adjusted, present value of the benefits as a result of the upgrade amount to $3.1 million over a three-year period

 

If you are thinking about upgrading SQL Server, WARDY IT Solutions is providing a free 2-hour onsite upgrade assessment review that will assist with the upgrade planning. To take advantage of this offer call 1300 WARDY IT (927 394) today.

 

The new WARDY IT Solutions SQL Server training schedule for the remainder of 2010 has been released and can be found here.

 

Happy Reading & New Financial Year

Peter Ward

 

^top

Analyzing I/O Characteristics

Understanding how to analyze the characteristics of I/O patterns for SQL Server and how they relate to a physical storage configuration is useful in determining deployment requirements for any given workload. A new white paper has been released to assist with analysis. The whitepaper can be downloaded here ^top

Free Brisbane SQL Server Breakfast

WARDY IT Solutions is running a Free SQL Server breakfast in Brisbane on Tuesday the 10th of August. This Breakfast will demonstrate how the managed self-service business intelligence features in SQL Server 2008 R2 can provide significant business advantage. Register for this free event here.

^top

IPD Guide for SQL Server

The Infrastructure Planning and Design (IPD) guide for Microsoft SQL Server 2008 and SQL Server 2008 R2 helps technical decision makers identify the appropriate SQL Server roles needed and also determine the infrastructure components, server placement, and fault-tolerance configuration necessary to meet planning requirements. The IPD guide can be downloaded from here.

^top

SQL Server 2008 R2 Best Practices Analyzer

The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that gathers information about a Server and the SQL Server instances installed on the Server. The tool indicates potential problems and recommends solutions to the potential problems. The Best Practices Analyser can be found here.

^top

Master Data Services eClinic

As the server and application sprawl across organizations continues, there has never been a more important time to aim for a single version of the truth and to improve both operational and reporting consistency. Master Data Services is a solution with SQL Server 2008 R2 that assist to address this challenge. A free eClinic on this new technology can be found here.

^top

SSIS Performance Video's

Performance tuning SQL Server Integration Services (SSIS) Packages is often seen as a dark art. The SQL Server CAT team have just released a new video series about how to design and tune SSIS packages for performance. The video series 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

Business Intelligence Conference Keynote

Ted Kummert, senior vice president of the Business Platform Division at Microsoft keynoted the second day of the Microsoft Tech Ed North America 2010. This keynote demonstrates how SQL Server 2008 R2 is enabling increasingly rich opportunities for effective data visualization, manipulation and analysis. The keynote shows off the rich integration among the applications, showing how data surfaced in a browser via SharePoint could be directly manipulated in Excel. To view this keynote refer to here.

^top

TechEd Australia Early Bird Discount

Microsoft TechEd Australia is Australia's largest annual technology event. This year’s event is being held at the Gold Coast Convention and Exhibition Centre and WARDY IT Solutions is an exhibitor. The early bird rate for the event is available up until the 16th of July. To register for the event refer to here.

^top

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 service 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 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