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

In-memory Databases In-memory Databases
Why Not Oracle RAC Why Oracle RAC is not the Right Solution
Virtual DBA on the Windows Phone Virtual DBA on the Windows Phone
SQL Server 2012 Training SQL Server 2012 Training
Tuning Spatial Queries in SQL Server 2012 Tuning Spatial Queries in SQL Server 2012
Data Quality Services Performance Best Practices Data Quality Services Performance Best Practices
SQL Server Healthcheck SQL Server Healthcheck
Learn DAX in 30 Minutes Learn DAX in 30 Minutes
xVelocity in SQL Server 2012 xVelocity in SQL Server 2012
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions was invited to review the Data Platform and Business Intelligence exams for SQL Server 2012


WARDY IT Solutions is running the course 6231 Maintaining a Microsoft SQL Server Database in Brisbane on the 14th of May

 

WARDY IT Solutions has been the MAPA Data Management Partner of the Year since 2009

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

 

Following the release of SQL Server 2012 last month the General Availability of SQL Server 2012 was the 2nd of April. General Availability means that SQL Server 2012 is now available on the Microsoft price list. Despite SQL Server 2012 being release for less than two months, WARDY IT Solutions has already deployed solutions based on this new platform for several customers.

 

Over the last month I have been travelling throughout Australia and New Zealand presenting at the SQL Saturday events. WARDY IT Solutions were proud to be a Gold sponsor of the downunder events and that our subject matter experts delivered more sessions than any other organisation.

 

One of the things that became apparent from talking to a number of people throughout these events is the confusion about SQL Server 2012 licencing. WARDY IT Solutions has a team of qualified SQL Server licencing specialists that can assist to ensure you have the appropriate licencing in place to take advantage of the features in SQL Server 2012. This workshop is part of the WARDY IT Solutions SQL Server Licensing assessment services. To take advantage of this free assessment contact WARDY IT Solutions today.

 

If you are looking to get up to speed with this next release of SQL Server, SQL Server 2012 then look no further than WARDY IT Solutions.

 

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

 

 

Peter Ward

 

^top

In-memory Databases

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. SQLCAT have released an article that provides an overview of the different design patterns that are available. This article can be found here.

^top

Why Oracle RAC is not the Right Solution

A new white paper has been released that shows why customers might not want to implement Oracle Real Application Clusters (RAC) in their database solution. This white paper explains common myths and misunderstanding about Oracle RAC and demonstrates that Oracle RAC costs more than 5 times then a SQL Server solution. This white paper can be downloaded from here.

^top

Virtual DBA on the Windows Phone

As part of WARDY IT Solutions Virtual DBA solution we provide each customer with a complimentary portal that provides a real-time view of their entire SQL Server topology.

 

With the release of the Windows Phone we saw an opportunity to extend the Virtual DBA Portal to allow customers to view the status of their servers beyond the limits of their desktops. You can take a look at the Virtual DBA Portal on the Windows Phone Marketplace.

^top

SQL Server 2012 Training

WARDY IT Solutions has been developing training for SQL Server 2012 over the past few months and we are proud of the fact that we have the first SQL Server 2012 training in Australia. We have developed the SQL Server 2012 First look course as well as the just released SQL Server 2012 AlwaysOn Workshop. For more details on all the WARDY IT Solutions SQL Server training refer to here.

^top

Tuning Spatial Queries in SQL Server 2012

Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application through put. SQL Server 2012 introduces a few key new features and improvements to assist you in that goal. To find out more about these improvements refer to here.

^top

Data Quality Services Performance Best Practices

SQL Server Data Quality Services (DQS) is a knowledge-driven product that lets you perform a variety of data quality operations such as cleansing, matching, and data profiling. The Data Quality Services Performance Best Practices Guide describes how to get the best performance out of DQS, especially when working with large data volumes. This guide 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

Learn DAX in 30 Minutes

A QuickStart is now available for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. The Quickstart is designed to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modelling and analytical problems. You can find this quickstart to help you get the most out of your data here.

^top

xVelocity in SQL Server 2012

With the release of SQL Server 2012, Microsoft announced xVelocity. Velocity is a technology designed to deliver huge performance improvements for data warehousing and business intelligence. xVelocity is a memory optimized column store index feature in SQL Server 2012 and SQL Server is the first mainstream RDBMS to integrate a memory optimized columnar data storage capability into the relational database engine. To find out more about the performance benefits of xVelocity refer to here.

^top

SQL Server Virtual DBA

WARDY IT Solutions Virtual DBA service was named one of Australia's 100 most innovative products or services, in one of the largest and most audacious innovation awards of its kind in Australia - 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