WARDY IT Solutions is proud to announce that they will be delivering the first SQL Server 2008 R2 workshops in Australia.

The workshops will be conducted as a free ½ day Hot Lap. A Hot Lap is a quick and concise way of finding out what is new in SQL Server 2008 R2 and how these changes will improve database operations, developer efficiency and enable self-service Business Intelligence solutions.

The SQL Server 2008 Hot Laps will be held at the end of January in Melbourne, Brisbane and Sydney with Canberra and Hobart to be scheduled in February.

Melbourne – 27^th January: 1:00pm – 5:00pm

Brisbane – 28^th January: 8:00am – 12:00pm

Sydney – 29^th January: 8:00am – 12:00pm

The morning events will include a light breakfast and morning tea and the afternoon sessions will include a light lunch and afternoon tea.

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

To celebrate the launch of our new Hobart office, WARDY IT Solutions will be hosting a free SQL Server breakfast in Hobart on Friday the 2nd of October.

In this session you will see how multiple databases can be consolidated to a single SQL Server 2008 server without the need for a magic wand. Traditionally organisations have continued to increase their SQL Server footprint as they have introduced new technologies to manage business processes. Due to the current economic climate it is becoming harder for organizations to minimize the costs associated with maintaining multiple servers throughout the enterprise. Despite the challenges of tightening budgets, SQL Server 2008 provides an opportunity to reduce costs through consolidation. This session will demonstrate how SQL Server 2008 can be used to assist with consolidating applications from multiple servers without sacrificing the goals of performance and availability.

To register your interest in attending this FREE SQL Server Breakfast seminar please email contact@wardyit.com. Feel free to forward this to friends and colleagues who may be interested in attending also.

When Wednesday 7th August from 7:30am

Where WARDY IT Solutions - Hobart Office | 175 Collins Street, Hobart

Add this event to your Outlook Calendar

All attendees of Tech-Ed on the Gold Coast will receive a free HP Netbook.

Well Brisbane leading consultants – WARDY IT Solutions, Enhance ALM and Portal Synergy have partnered together to provide you the opportunity to Pimp your free Netbook. So make sure you pop by the booth during Tuesday night's Welcome Reception or on Friday for an opportunity to win some great prizes to Pimp your Netbook.

WARDY IT Solutions has been selected as a finalist for the Australian Partner Conference (APC) Partner of the Year. The category of our solution nomination is Data Management Solutions Partner of the Year.

The solution described in the nomination is the SQL Server 2008 Consolidation which is a service designed to migrate application databases from multiple physical locations to a single location. This aims to identify the optimal way to implement the consolidation process whilst taking into consideration the desired outcome of the individual organization and the requirements of the applications being migrated. Through the consolidation service implementation, organisations can reduce the costs of maintaining multiple servers. More information on this solution can be found in the Microsoft Partner Solution Description which can be found here.

The second WARDY IT Solutions SQL Server breakfast for the year is on Thursday the 7^th of May. This breakfast is a Free quarterly event hosted by WARDY IT Solutions. Catering will be served from 7:30am with the one hour presentation starting at 8:00am.

The May Breakfast will focus on how to utilise the Business Intelligence features of SQL Server 2008 to provide insights into trends that affect the health of an organisation.

To register your interest in attending this FREE SQL Server Breakfast seminar please email contact@wardyit.com. Feel free to forward this to friends and colleagues who may be interested in attending also.

When: Wednesday 7th May from 7:30am

Where: Microsoft Brisbane | Level 9, Waterfront Place | 1 Eagle Street | Brisbane

Add this event to your Outlook Calendar

SQL Server expert Kalen Delaney, the author of Inside SQL Server and the new book SQL Server 2008 Internals, is a special guest in Australia this June for WARDY IT Solutions.

Kalen will be presenting a not to be missed one day seminar in Melbourne, Canberra, Brisbane and Sydney.

In Melbourne and Sydney Kalen will be presenting on SQL Server Storage Formats.

In Canberra and Brisbane Kalen will be presenting on SQL Server Internals.

The dates for these seminars are:

June 15: Melbourne – SQL Server Storage Formats

June 17: Canberra – SQL Server Internals

June 19: Brisbane – SQL Server Internals

June 22: Sydney – SQL Server Storage Formats

The cost of these seminars is only $695.00 ex. GST, however up until the 27^th of March each registration will receive a free copy of Kalen's new book SQL Server 2008 Internals. Places on these seminars is strictly limited so don't delay registering as Kalen sold out last time she was in Australia. You can register by emailing contact@wardyit.com or calling 1300 WARDY IT (927 394).

A question that I am often asked when I do a presentation is how I configure SSMS so that when the query is executed the query is displayed in the header of the messages. I find that when presenting it can be easier to talk to the output rather than flicking back to the Query Editor.

Below is an example of the statement being displayed in the header of the messages:

To configure this is SSMS follow the steps below:

1. Open SSMS
2. Select Tools | Options
3. Expand Query Results
4. Expand SQL Server
5. Select Results to Text
6. Check Include the query in the result set