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

Since the release of SQL Server 2014 earlier this year, there have been a number of new announcements regarding the Microsoft Data and Analytics Platform. Many of these announcements such as the new Azure SQL Database service tiers and the addition of forecasting capabilities to Power BI for Office 365 are based around Hybrid and Cloud based scenarios. WARDY IT Solutions has been assisting numerous customers successfully implement solutions that enable them to adopt a flexible pubic, partner and private cloud model for their data assets. If you would like to know more about how you too can optimize your data and analytics platforms by adopting cloud-based services for SQL Server then contact WARDY IT Solutions today for our free SQL Server Cloud Optimisation workshop.

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

^top

Leverage In-Memory OLTP for Applications

In-Memory OLTP allows data to be moved into memory resident tables while keeping other data in traditional disk-based table structures. A new whitepaper has recently been published that discusses common patterns for implementing and leveraging the new In-Memory OLTP capabilities of SQL Server 2014. You can download the whitepaper from here.

^top

How to Cluster SQL Server Analysis Services

For SQL Server, AlwaysOn failover cluster instances (FCIs) are one of the more popular approaches for making the relational database engine highly available. Analysis Services (SSAS) can benefit from an equivalent approach for BI workloads that are mission critical. To find out how to deploy a clustered instance of Analysis Services with SQL Server refer to here.

^top

Installing MDS in an AlwaysOn Environment

A new whitepaper has been released that describes how to install and configure Microsoft SQL Server Master Data Services in a high-availability/disaster recovery deployment that uses SQL Server with AlwaysOn enabled. To find out more about this deployment scenario refer to here.

^top

Forecasting with Power BI for Office 365

At the recent PASS Business Analytics Conference the availability of new forecasting capabilities for Power View in Office 365 was announced. In Power View, you can now apply predictive forecasting and hindcasting when visualizing and exploring your data. To find out more about this new functionality refer to here.

^top

SQL Server 2014 sets World Record

The industry standard organization for performance benchmarking, Transaction Processing Performance Council, verified that Microsoft SQL Server 2014 broke the world record for the On-Line Transaction Processing (OLTP) workload with the TPC-E and broke multiple world records for Data warehousing (DW) with the TPC-H. To find out more about this new benchmark in performance refer to here.

^top

Free SQL Server 2014 eBook

Microsoft Press has announced the release of a free eBook, Introducing Microsoft SQL Server 2014 which is available for free for a limited time. This eBook book by Ross Mistry and Stacia Misner is available for download 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 2014 Database as a Service

Microsoft has released a new whitepaper that provides a guide to building the infrastructure for hosting Microsoft SQL Server Database as a Service. This reference architecture includes hardware, software, system design, and component configuration and can be downloaded from here.

^top

Free Exam Voucher

WARDY IT Solutions provides a bonus for all 5 Day Microsoft Official Curriculum (MOC) SQL Server training course. When you book any 5 Day MOC training you receive a FREE Prometric Exam Voucher. To take advantage of this offer contact us today.

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