Loads of SQL Server tips as well as all the latest SQL Server news brought to you by Australia's Leading SQL Server Consultants and Trainers
WARDY IT Solutions
Newsletter Issue #49
WARDY IT Solutions
In this issue:

SQL Server Training Schedule SQL Server Training Schedule
What is Dallas What is Dallas
Australian ALM Conference Australian ALM Conference
Number of Mirrored Databases Microsoft Pivot
Server Consolidation Guidance Number of Mirrored Databases
Parallel Data Warehouse Parallel Data Warehouse
SQL Server Healthcheck SQL Server Healthcheck
Introducing Microsoft StreamInsight Introducing Microsoft StreamInsight
SQL Server 2000 to 2008 Upgrade Whitepaper SQL Server 2000 to 2008 Upgrade Whitepaper
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions is running the first PowerPivot training in Australia

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


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


The first quarter of any year is often one of predictions for the year ahead and 2010 is no different. Business Intelligence has been high on the list of priorities for Information Technology teams no matter what sector they are in for the last five year. In fact, Microsoft first started to tout the concept of self-service Business Intelligence with the release of SQL Server 2005. However for many organisations Business Intelligence is an oxymoron.


After talking to CIO’s over the last few year I have found that many are starting to realise that they have not done a particularly good job of articulating the benefits of Business Intelligence to the Financial Decision Makers (FDM’s) in their organisation – the CEO’s and CFO’s. Many FDM’s eye’s still glaze over when the word’s Business Intelligence are uttered. However there is one thing that FDM’s have learnt over the last 12 months and that is the need for increased visibility.


The prediction from WARDY IT Solutions for 2010 is that SQL Server 2008 R2 and Business Intelligence will finally start to deliver on what has been promised by vendors for many years. We are so confident in this that we have come up with the ‘BI Insight Guarantee’. For two week two expert SQL Server consultants will help your team establish a greater insight into to your business. If at the end of this two week engagement we have not turned the data deluge in your organisation into meaningful and actionable information then the engagement is free – simple. Why are we so confident of being able to deliver business value using Microsoft SQL Server 2008 R2:
  • We are the Microsoft APC Data Management Partner of the Year
  • We are a finalist of the QLD ACS IT for the second year running
  • We were the first company in Australia to deliver SQL Server 2008 R2 training
  • We are the only company to offer PowerPivot training in Australia
  • We have already delivered production solutions based on SQL Server 2008 R2
  • We are reviewing the SQL Server 2008 R2 training for Microsoft
  • We are delivering SQL Server 2008 R2 training for Microsoft
  • We are Australia's leading SQL Server consultants and trainers


To take advantage of our proven experience in delivering solutions based on Microsoft SQL Server 2008 R2 then call 1300 WARDY IT (927 394) today.


Happy Reading

Peter Ward


SQL Server Training Schedule

WARDY IT Solutions has developed the following exclusive SQL Server courses including the first PowerPivot training course to be delivered in Australia:

  • Brisbane - 5th May - SQL Server Administration Essentials
  • Brisbane - 12th May - SQL Server Developer Essentials
  • Brisbane - 14th May - SQL Server Business Intelligence Launchpad
  • Brisbane - 18th May - SQL Server Reporting Services
  • Brisbane - 21st May - Integrating SQL Server with SharePoint
  • Brisbane - 25th May - SQL Server 2008 R2 Step-up
  • Brisbane - 26th May - SQL Server 2008 R2 PowerPivot
  • Sydney - 8th June - SQL Server 2008 R2 Step-up
  • Sydney - 9th June - SQL Server 2008 R2 PowerPivot
  • Melbourne - 15th June - SQL Server 2008 R2 Step-up
  • Melbourne - 16th June - SQL Server 2008 R2 PowerPivot

For more details and to register for these courses email contact@wardyit.com.


What is Dallas?

Microsoft Codename "Dallas" is a new service allowing developers and information workers to easily discover, purchase, and manage premium data subscriptions in the Windows Azure platform. To find our more on how Dallas allows the consumption of data refer to here.


Australian ALM Conference

The first annual Australian ALM Conference which incorporates Microsoft Australia's Official Launch event for Visual Studio 2010 is being held next week in Sydney from the 13th to 14th of April. For more details and to register for this conference refer to here.


Microsoft Pivot

Microsoft Live Labs' has recently release a powerful new discovery tool powered by Silverlight that provides an intuitive interface to assist with the exploration of information. To find out how you can start to visualise collections of data refer to here.


Number of Mirrored Databases

A question that is often asked when consolidating SQL Server is the number of databases that can be mirrored in a single instance. There is a lot of misconceptions about database mirroring and the SQLCAT team have debunked a lot of the myths with a new blog post which can be found here.


Parallel Data Warehouse

Microsoft SQL Server 2008 R2 Parallel Data Warehouse (previously code named project "Madison") is a new Edition introduced in SQL Server 2008 R2. The Parallel Data Warehouse edition is a highly scalable appliance that delivers performance at low cost through a massively parallel processing. To find out more about this new Edition of SQL Server refer to 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.


Introducing Microsoft StreamInsight

Microsoft SQL Server StreamInsight is a platform for complex event processing that is available with SQL Server 2008 R2. StreamInsigt provides the ability to develop event-driven applications for businesses with high throughput, low latency requirements. To find out more about StreamInsight then refer to here.


SQL Server 2000 to 2008 Upgrade Whitepaper

Despite the fact that SQL Server 2008 has been available for 18 months, many organisations are still running SQL Server 2000. Microsoft have made available a whitepaper that discusses the factors that should be take into consideration to plan a successful upgrade to SQL Server 2008. To download this whitepaper refer to 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 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?


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