The latest SQL Server news from WARDY IT Solutions.
            
Not rendering correctly? View this email as a web page here.
            
Call us today: +61 7 3054 5300
    

What's On @ WARDY IT Solutions!

The latest SQL Server news, updates, training and event details.

Hi there,

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

The world of data is changing rapidly with more and more organisations embracing data to drive innovation.  As a result they require a platform that supports this innovation.  That is why when it comes to managing data, the choice is clear: Microsoft SQL Server is an industry leader in both Operational Database Management Systems and Business Intelligence and Analytics Platforms.

However simply just having a great platform is not enough to enable the data insights that are required to drive business transformation. That is where WARDY IT Solutions can assist. WARDY IT Solutions have proven success enabling organisations maximize the investment in the their data assets including recently assisting RACT Insurance deliver a more intuitive reporting solution that offers actionable insights.

If you would like to know more about how WARDY IT Solutions can enable success for your organisation then contact us today.

WARDY IT Solutions has been recognised as one of Australia’s leading Microsoft Power BI Partners. This recognition is based on numerous successful implementations of Power BI that have delivered business value and provided rich visualisations and insights.

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

Regards,
Peter 

Peter Ward
Managing Director
WARDY IT Solutions

What's new in SQL Server 2016 Master Data Services

Are you curious what Master Data Services is all about or wanting to explore the many new features and capabilities delivered with SQL Server 2016?  Well a new hands on lab is available to assist you explore what is new with Master Data Services (MDS) in SQL Server 2016.  You can access this free hands on lab here.

SQL Server 2016 Community Technology Preview 3.3

Earlier in February the SQL Server engineering team announced the availability of SQL Server 2016 public preview release Community Technology Preview (CTP) 3.3.  This release of SQL Server demonstrates the “Cloud First” tenet as the build has already been deployed to SQL Azure Database worldwide. To learn more about this release refer to here.

SQL Server Express images in the Azure Gallery

Microsoft has recently added images for SQL Server Express with Tools 2014, 2012, and 2008 R2 in the Azure Gallery. These images include the core SQL Server Engine as well as SQL Server Management Studio.  SQL Server Express is a version of SQL Server that you can use for development and test as well as for web and mobile apps with lightweight relational database needs.   The SQL Server Express licensing is free, so you only need to pay for running the virtual machine.  For more information about these new images refer to here.

Power BI Publish to Web

The Power BI “publish to web” capability has been released in preview. The Microsoft Power BI publish to web feature allows users to tell compelling stories with interactive data visualizations in minutes.  You can easily embed interactive Power BI visualizations in your blog and website or share the stunning visuals through your emails or social media communications. You can reach millions of users on any device, any place, for an engaging experience. To find out about this new Power BI feature refer to here.

Dynamic Data Masking to Obfuscate Sensitive Data

Data privacy is a major concern today for any organization that manages sensitive data or personally identifiable information.  Examples of such data include sensitive customer information such as phone numbers, email addresses and bank information, HR data on employees and financial business data.  SQL Server 2016 and Azure SQL DB now offer a built-in feature that helps limit access to those particular sensitive data fields called Dynamic Data Masking (DDM).  You can learn more about this feature here.

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. Find out more details on our SQL Server Healthcheck here.

Cortana Analytics Suite

The Cortana Analytics Suite is a fully managed big data and advanced analytics suite that enables you to transform your data into intelligent action. This analytics suite empowers you to take action ahead of your competitors by going beyond looking in the rear-view mirror to predicting what’s next.  Find out more about how Cortana Analytics Suite enables machine intelligence to evolve from simple descriptive analytics to prescriptive analytical recommendations here.

End of Extended Support for SQL Server 2005

Extended support for SQL Server 2005 ends on April 12, 2016. If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates. Now is the time to upgrade to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. To find out more about your options and how to upgrade from SQL Server 2005 contact WARDY IT Solutions today.

MAPA 2013

If you've got any questions, please feel free to send me an email anytime. Just hit Reply.

You may also be interested in:

SQL Server Health Check