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

SQL Serevr Data Loading Performance Guide SQL Server Data Loading Performance Guide
Availability Group FAQ Availability Group FAQ
Azure Performance and Scalability Compared and Contrasted Azure Performance and Scalability Compared and Contrasted
SQL Platinum Training SQL Platinum Training
Parallel Data Warehouse v2e Parallel Data Warehouse v2
SSIS Tips Tricks and Best Practices with Azure SSIS Tips Tricks and Best Practices with Azure
SQL Server Healthcheck SQL Server Healthcheck
SQL Server 2012 Upgrade Guide SQL Server 2012 Upgrade Guide
Cleanse and Match Master Data by Using EIM Cleanse and Match Master Data by Using EIM
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions has more Microsoft Certified Trainers than any other organisation in Australia


WARDY IT Solutions is brining SQL Server expert Kalen Delaney to Australia this March

 

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.

 

Book Kalen Delaney workshop

 

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

 

 

Peter Ward

 

^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

Parallel Data Warehouse v2 is the next version of Microsoft's enterprise-class MPP architecture appliance. This new appliance will be available during the first half of 2013. Parallel Data Warehouse v2 includes PolyBase, a fundamental breakthrough in data processing that will enable queries across relational data and non-relational Hadoop data. For more information on PolyBase and other enhancements in the new version of PDW refer to here.

^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.

 

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