A Lap Around Columnstore – Brisbane

Person delivering a speach.

A Lap around Columnstore Event

Columnstore indexing was first introduced in SQL Server 2012, however it was not widely adopted.

SQL Server 2014 added additional functionality to columnstore which resulted in a marginally higher uptake.

The initial versions required some creative thinking to get all of the promised performance gains out of the technology.

Now, SQL Server 2016 enhances this functionality greatly and it’s all set to become mainstream.

Columnstore promises significant performance gains for datawarehouses along with operational analytics.

This presentation will look at many of the new features in columnstore as well as briefly look at some of the internals and give the audience some insight into how they can leverage its potential.

About the Presenter

Martin Catherall is a RockSolid SQL consultant, a SQL Server MVP, PASS Regional Mentor for the Asia Pacific (APAC) region and until recently leader of the Christchurch, New Zealand SQL Server User Group. Now based in Melbourne, he’s getting to know the Australian SQL community.

He has been using SQL Server in various roles since 2000. In addition to anything data related be enjoys playing the guitar and having fun with his family.

Location:

Microsoft Brisbane
Level 28, 400 George Street, Brisbane (map)

Date:

Thursday 24th March 2016

Time:

05:30 PM

Click here to RSVP for the event

Microsoft Azure for the SQL Server DBA – Canberra

Microsoft Azure for the SQL Server DBA

Microsoft Azure for the SQL Server DBA

SQL Server has shipped with features that integrate Azure since 2008 R2. Fast forward to 2016 and we have seen plenty of development from Microsoft in the cloud arena. As our IT landscape evolves in support of cloud-based computing, this technology will slowly but surely become more integrated into the life of a DBA. In this session we explore what Azure means for your applications, how to identify good candidates for the cloud, and how to build your Azure knowledge FAST.

About the Presenter

Michael van Halderen is an independent SQL Server professional who has been working in the IT industry for over 14 years. He has worked exclusively with SQL server for more than 8 years in both DBA and DB Developer roles in Australia and the UK. Michael has contributed to SQL Server exam development in Redmond and holds an MCSE: Data Platform certification.

Location:

Microsoft Canberra Branch
Level 4, 6 National Circuit, Barton (map)

Date & Time:

Tuesday, 05 April 2016, 5:00PM

Please register here to let us know you are coming.

Sundale Harnesses the Power of Business Intelligence Visualisation

Sundale BI Case Study

Microsoft Power BI Data Visualisation Case Study

Executive Summary:

Data visualisation provides the tools for business managers to remove the complexity between relationships in data and analyse the correlations between cause, effect and outcome. Sundale was unable to integrate its data and present a uniform view of employee engagement in a simple format. Partnering with WARDY IT Solutions, Sundale identified their core requirements and defined a proof of concept to connect their disparate systems and visualise activities using Microsoft’s Power BI.

How WARDY IT Solutions Helped:

Microsoft’s recently updated Power BI was trialed in the evaluation phase of the project. Power BI integrated easily with Sundale’s production SQL Server, Dynamics AX and CRM systems after custom data connectors were created to couple the systems. WARDY IT Solutions’ team of analysts prototyped a number of visualisations to support the proof of concept resulting in management extending the evaluation into a live production roll-out across the organisation.

Collaborating with WARDY IT Solutions helped Sundale’s IT professionals to quickly prototype and deliver a full production system. This improved Sundale’s bottom line and provided tangible proof that technology improved service levels and lifestyle quality for Sundale residents.

Read the full case study here.