Tuesday, March 22, 2016

SG SQL UG Meetup - Mar 2016

Date: Mar 17th
Agenda:
Mar 17th - 6:45 PM to 7 PM - Registration and Snacks
7 PM to 8:15 PM - Topic 1 - Presentation by Edwin Sarimento
8:15 PM to 8:30 - Break
8:30 PM to 9:30 - Topic 2 - Presentation by Martin Catherall
Location: Microsoft Office, One Marina Boulevard, Conf Room SINOMB 22CF-15 (24) AV

Topic 1: 5 Things To Consider: Stretching SQL Server Failover Clustered Instances and Availability Groups to Microsoft Azure
Abstract : Dealing with SQL Server Failover Clustered Instances and Availability Group for local high availability is already complicated with a lot of the external dependencies such as the network and the Windows Server Failover Cluster (WSFC.) But it becomes even more complicated when you stretch it out for disaster recovery to Microsoft Azure. In this session, learn the five (5) things that you need to consider when you implement SQL Server Failover Clustered Instances and Availability Group for disaster recovery into Microsoft Azure. We will cover how Active Directory, DNS, WSFC heartbeat and quorum configuration affects deployments of SQL Server Failover Clustered Instances and Availability Group in a disaster recovery site and how to properly configure a client application for connectivity.
Speaker Profile: Edwin Sarimento
Edwin M. Sarmiento is the Managing Director of 15C, a consulting and training company that specializes on designing, implementing and supporting SQL Server infrastructures. He is a  Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack ranging from Active Directory to SharePoint and anything in between. He is very passionate about technology but has interests in music, professional and organizational development, and leadership and management matters when not working with databases. Edwin lives up to his primary mission statement: "To help people and organizations grow and develop their full potential."

Topic 2:  A Lap around Columnstore
Abstract : 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.

Speaker Profile: Martin Catherall
Martin 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.
Download link for the slides: here