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

WARDY IT Solutions continues to be the leader in innovative Microsoft SQL Server Solutions throughout APAC with our practice continuing to grow based on continued excellence in delivering solutions for clients. As a result of this growth WARDY IT Solutions has relocated our Brisbane Head-Office. WARDY IT Solutions Brisbane Head-Office is now located at:

164 Wharf Street

Spring Hill

You can find our new location on Bing Maps.

All of the other contact details for WARDY IT Solutions will remain the same:

Email contact@wardyit.com

Phone 1300 WARDY IT (927 394)

Fax 07 3856 5422

Over the next few weeks we will be making some announcements about some of the other innovative solutions we are releasing in the Microsoft SQL Server marketplace in 2013 including the line-up for SQL Platinum Training. Kalen Delaney is running the first SQL Platinum Training event in 2013. Kalen's courses and seminars on SQL Server Internals have been delivered at internal Microsoft training events and as on-site courses for premier Microsoft partners around the world. Book by the 15th of February to take advantage of the early bird pricing.

You can keep updated on all the latest WARDY IT Solutions SQL Server news on Facebook & Twitter:

^top

SQL Server Data Loading Performance Guide

If you are looking for patterns and practices to assist with bulk loading large data sets into SQL Server then the SQL Server Data Loading Performance Guide should be your first point of call. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process. You can view this white paper here.

^top

Availability Group FAQ

SQL Server AlwaysOn is a new high availability solution that has been introduced in SQL Server 2012. With any new technology comes a list of commonly asked questions. Allan Hirt has prepared a list of Frequently Asked Questions about this new technology which can be found here.

^top

Azure Performance and Scalability Compared and Contrasted

While SQL Server and Windows Azure SQL Databases (SQL Database for short, formerly SQL Azure) have large and important similarities, they are not identical, and while the differences are relatively small, they affect the way that applications perform on SQL Database compared to SQL Server. As a result, the application architecture and performance evaluation techniques for each platform also differ. For more details and to compare these platforms refer to here.

^top

SQL Platinum Training

WARDY IT Solutions SQL Platinum Training provides a superior educational experience to our clients. We work with prestigious world renowned training specialists to bring the best of breed training to Australia in harnessing the latest technologies and thought leadership.

Kalen Delaney is returning to Australia in March and will be presenting a 4 day, advanced course, SQL Server 2012 Query Tuning Internals Deep-Dive.

The course will be presented on SQL Server 2012 and cover features specific to that version, but most of the information is relevant to SQL Server 2008 and some is relevant to SQL Server 2005.

Kalen Delaney is considered to be the world's leading expert in SQL Server Internals. Kalen's courses and seminars on SQL Server Internals have been delivered at internal Microsoft training events and as on-site courses for premier Microsoft partners around the world.

Take advantage of the Early Bird price til the 15th of February of $3,600 ex GST Book Now!

^top

Parallel Data Warehouse v2

^top

SSIS Tips Tricks and Best Practices with Azure

SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from Windows Azure (WA) SQL Database, as part of the total extract, transform, and load (ETL) solution and as part of the data movement solution. SSIS can be used effectively to move data between sources and destinations in the cloud, and in a hybrid scenario between the cloud and on-premise. A new white paper has been release that outlines SSIS best practices for cloud sources and destinations. This whitepaper can be downloaded from 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

SQL Server 2012 Upgrade Guide

Are you thinking of upgrading to SQL Server 2012? Well the Technical Upgrade Guide should be your first stop. This guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012. To download the guide refer to here.

^top

Understanding Big Data

A new whitepaper has been released that describes how to cleanse and match master data using the Enterprise Information Management products of Microsoft SQL Server 2012 Master Data Services (MDS), SQL Server Data Quality Services (DQS), and SQL Server Integration Services (SSIS). The white paper addresses scenarios for building and cleansing a new master data entity, updating one, and performing matching. It also describes some of the differences between Master Data Services and Data Quality Services. This white paper can be found here.

^top

SQL Server Virtual DBA

WARDY IT Solutions Virtual DBA service was named one of Australia's 100 most innovative products or services for the second year running in the Anthill Magazine 'SMART 100' Index.

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