SQLSaturday #706 - Wellington 2018

Event Date: 02/17/2018 00:00:00

Event Location:

Whitireia New Zealand
3 Wi Neera Dr, Elsdon, Porirua
Wellington, Wellington, New Zealand

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Troubleshooting Issues with Extended Events in real time

Abstract: Extended events to aid in performance tuning and in day to day administration specially when you don’t have any benchmarking data for troubleshooting issues. In this session, we will see how the Extended Events streaming API can be used to process events in a near real-time. We will demonstrate how this feature enables new possibilities to capture real time problems without enabling any third party tools or inbuilt SQL Server features to capture issues like blocking, deadlocks, high CPU and many more. Extended Events were introduced in SQL Server 2008 but by SQL Server 2016, it has enhanced significantly. After this session, hopefully you will start using extended event, if you haven’t started using till now.

Speaker(s):

Dharmendra Keshari

Track and Room: Database Administration Deployment - Microsoft

Title: DBATools! The reason to finally start learning and using Powershell

Abstract: Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008. In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.

With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.

In this session we will look how to download, install and begin using the power within both this module and Powershell.

No prior experience with Powershell required!

Speaker(s):

Patrick Flynn

Track and Room: Database Administration Deployment - DataCore

Title: DevOPs and the DBA

Abstract: You may have heard the word “DevOps” and wondered whether it is just another buzzword and/or what it can do for you.

In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery.

Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work

Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments.

Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery.

Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.

Speaker(s):

Hamish Watson

Track and Room: Database Administration Deployment - Microsoft

Title: Flex your data muscles from DBA Workbench

Abstract: 2016 is an exciting year for all of us, that continues within 2017 as well! We need a process and procedure to follow upgrading to SQL Server 2016., let’s walk through a high-level upgrade workflow to help us put the process in perspective by breaking down the upgrade process - DBA Workbench.

We will overview live demo with suite of Upgrade Advisor, a single consistent tool that contains three categories of advisors: Upgrade, New Features, and Best Practices, with an extensibility option to add new scenarios over time. A showcase of analyser to go through detailed list of upgrading and features that we have from SQL Server 2016 arsenal.

This session focus is upon what-to-do and what-not-to-do in your data platform upgrade management.

Speaker(s):

Satya Jayanty

Track and Room: BI Platform Architecture, Development Administration - Room 4

Title: Kick Start! SQL Server 2016/2017 Performance Tips and Tricks

Abstract: Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 / 2017 has introduced many new features. In this 75 minute session we will be learning quite a few of the new features of SQL Server 2016 / 2017. Here is the glimpse of the features we will cover in this session. • Adaptive Query Plans • Batch Mode Adaptive Join • New cardinality estimate for optimal performance • Adaptive Query Processing • Indexing Improvements • Introduction to Automatic Tuning This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2016 / 2017 and its new features.

Speaker(s):

Pinal Dave

Track and Room: Database Administration Deployment - DataCore

Title: When Things go Wrong - Error Handling in SQL Server

Abstract: In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server is a most confusing topic, because there are such great inconsistencies. But that does not mean that we as database developers can hide our head in the sand.

This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.

Speaker(s):

Erland Sommarskog

Track and Room: Cloud/Enterprise Application Development Deployment - Microsoft

Title: A Beginners Guide to HA/DR

Abstract: High Availability and Disaster Recovery (HA/DR) planning is not just about the technology. When thinking or talking about High Availability/Disaster Recovery, many people jump straight to a particular technology without understanding other factors impacting the solution, and then waste time working backwards to understand requirements. Recovery Objectives, SLA’s and budget are some of the commonly overlooked factors when planning and developing a HA/DR solution. In this session we will walk through the 6 building blocks I take into account when developing a HA/DR solution. You can then use this same methodology to implement High Availability and/or Disaster Recovery in your own environment, working forward to determine the right technology.

Speaker(s):

Warwick Rudd

Track and Room: Database Administration Deployment - Microsoft

Title: Data Privacy and the Data Professional.

Abstract: It’s almost a daily occurrence to hear about some sort of data breach. But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex. Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world. We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer? Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.

Speaker(s):

Martin Catherall

Track and Room: Database Administration Deployment - Microsoft

Title: SQL Server 2017 with Python R: On-premises Machine Learning

Abstract: The R server 2017 provides many functionalities for database developers. It helps us to get more insight out of data by applying descriptive, predictive, and prescriptive analysis on data. Writing R and Python codes inside SQL server management studio 2017 make this happen. In this session, first I will provide some descriptions on the predictive analysis and how to use decision tree algorithm for that reason. Then I will show how to set up SQL server 2017 to run R and Python scripts inside it. Moreover, audience will learn about the best practice of predictive analytics insider SQL server management studio with the aim of creation predictive model, storing model, training model and doing prediction.

Speaker(s):

Leila Etaati

Track and Room: Advanced Analytics and Information Delivery - Unisys

Abstract: Come to this session to learn all about security and sharing in Power BI. Session starts with covering all types of sharing (basic sharing, work spaces, apps, publish to web, embedded), and their pros and cons. Session will then continue with Row Level Security topic. You will learn how to secure the content of Power BI based on roles. You will learn through live demos different types of implementing row level security, such as; Row level security through SSAS Live query, RLS in Power BI regardless of the data source, and dynamic row level security. Finally, in this session you will learn best practices and architecture advise for both Sharing and Security, and would be able to choose best security and sharing architecture for your Power BI solution requirement.

Speaker(s):

Reza Rad

Track and Room: BI Platform Architecture, Development Administration - TradeMe

Title: Real-Time Data Processing - How do I choose the Right Solution

Abstract: Analyzing data from IoT devices, web-sites and user applications can be challenging if the insights needed are in real-time. Azure has developed solutions to meet those challenges. But there is more than one solution available for this problem. Which one do I choose and what are the decision points? Come to this session and learn about how do you choose the right architecture and solution for processing real-time data on Azure.

In this session you will learn about different Real-Time Data Processing solutions on Azure and how to choose the right one for your business problem.

Azure Stream Analytics
Storm on Azure HDInsight
Spark on Azure HDInsight

Speaker(s):

Anupama Natarajan

Track and Room: Advanced Analytics and Information Delivery - Unisys

Abstract: GDPR (General Data Protection Regulation) is an EU legal initiative taking effect in May 2018, which protects data held anywhere by anyone on EU citizens. Why should you care about a new law from the other side of the planet? Because we live in an inescapably interconnected world.

This legislation comes with painful penalties for those who don’t comply. As a data professional, you will need to be aware of its implications for your organisation and the data which it holds.

This is a high-level look at the requirements of and obligations arising from GDPR for application designers and data professionals.

For specific guidance for your company, please seek specialised legal advice. I am not a lawyer. I am only qualified to utter my own opinions.

Speaker(s):

Julie Woolner

Track and Room: Cloud/Enterprise Application Development Deployment - Microsoft

Title: Using SQL as the basis for analysis in Python - Walking through an example on Kiwisaver in NZ

Abstract: What percentage of people in New Zealand have a KiwiSaver account? Who is more likely to have one, and who is less? How is KiwiSaver participation affected by the fact that the money can be withdrawn to buy a home, especially given that the housing market is currently very difficult to enter into?

These questions can be answered using SQL within Python to join summarise data from multiple sources, and subsequently performing some analysis and data visualisation in Python.

KiwiSaver has been around since 2007, but how much do we really know about its impact? Analysing this further requires gathering data from various sources and shaping it so that it is ready to be combined using SQL. The classifications used by different data sources needs to be addressed before choosing appropriate SQL joins.

Once this is done, we can calculate new summary statistics using SQL within Python. These then form the basis of the analysis and visualisation that can be performed in Python.

Speaker(s):

Emma Vitz

Track and Room: Advanced Analytics and Information Delivery - Unisys

Title: The Smart Way to Troubleshoot SQL Server Always On Cluster and Av

Abstract: SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). But when mission-critical databases go offline, bringing them back online could be a nerve-wracking experience.

This session will look at understanding how the underlying WSFC platform works to help us maintain availability of our databases. This is for DBAs and systems administrators who are responsible for administering SQL Server FCIs and AGs but are not so comfortable with figuring out why the databases went offline and what they can do about it. We’ll walk thru the troubleshooting process that I follow to quickly identify and resolve SQL Server FCI and AG availability issues.

Speaker(s):

Edwin M Sarmiento

Track and Room: Database Administration Deployment - TradeMe

Title: What do you mean there are no maintenance Windows?

Abstract: Imagine you develop for, or manage, a database system that powers a platform that must be operational 24/7/365. There are users worldwide every minute of the day. Need to update a schema to support an application change? Since the old versions of the app will still be using the database during update, you can’t do a breaking change until after the new app is rolled out everywhere. How do you do fit index maintenance in when there is constantly a heavy workload? What about backups? In this session we’re going to look at real world problems faced by many organisations and some ways to “work around them”

Speaker(s):

Dave Dustin

Track and Room: Database Administration Deployment - DataCore

Title: Introduction to Data Vault

Abstract: Over the last 10 years, Data Vault has become a common concept in the Data world. What is it? Why is it interesting? Where can it be used? How is it implemented in SQL Server? This presentation will give you a flavour of Data Vault. It will introduce: The concepts which make up Data Vault; The common tools used for building Data Vaults; How it works in SQL Server; The importance of Data Modelling and how it is structured; Interaction with modern Analytic Tools; Where to go for more information.

Speaker(s):

Brian Bradley

Track and Room: BI Platform Architecture, Development Administration - TradeMe

Title: Machine Learning Services in SQL Server, Featuring Dinosaurs!

Abstract: When Machine Learning Services in SQL Server 2017 was announced, I was really impressed with the potential of the idea: Bringing the algorithm right to the data! No more fiddly and expensive data pipelines!

I wanted to investigate what this would look like in practice, to see if it was a good fit for Xero’s use cases.

In this session, I’ll give a brief overview of the results of my investigation, demonstrate what using R for machine learning in SQL Server looks like, and give some opinions on how that fits with Xero’s needs. And because we’re all sick of the usual toy datasets, I’ll be using data about dinosaurs!

Speaker(s):

Simon Carryer

Track and Room: BI Platform Architecture, Development Administration - TradeMe

Title: Hidden “Gems” in SQL Server 2017

Abstract: Without doubt SQL Server 2017’s release had surprised the industry with it’s support for Linux. It’s ability to run on Linux has garnered a lot of publicity and focus.But SQL Server 2017 includes a myriad of smaller new features and enhancements. This session is going to cover these “gems” and highlight how they can have a dramatic influence on how you develop, administer, optimize and troubleshoot SQL Server 2017.

Speaker(s):

Victor Isakov

Track and Room: Database Administration Deployment - DataCore

Title: Advanced DAX for the SQL Professional

Abstract: Are you a whizz at SQL and curious about learning more about DAX? This session will be aimed to share some helpful tips and tricks for creating beautiful DAX when building Power BI reports or Tabular Cubes. Most people who learn DAX come from an Excel background, but this session will be tailored to those used to set based approaches such as SQL.

We will create data from thin air and show how you can shape your data model using DAX.

Speaker(s):

Phillip Seamark

Track and Room: BI Platform Architecture, Development Administration - TradeMe

Title: Azure Machine Learning and its real world use cases

Abstract: Is Machine Learning still a buzz word or can we easily put it to use to gain actionable insights from our data ? In this demo filled hands-on session we will cover how you can find hidden patterns in the data, find outliers, predict results using real world datasets.

This should also get you accustomed to ML concepts like regression, classification, over-fitting, cross validation etc., The goal of the session is to make audience knowledgeable enough to be able to build, deploy and consume a machine learning models easily.

Speaker(s):

Ram Katepally

Track and Room: Advanced Analytics and Information Delivery - Unisys

Title: Split, Merge and Eliminate - An Introduction to Partitioning

Abstract: In my life as a Consultant, partitioning is one of the least used or even inefficiently used components of SQL Server that I have seen. Partitioning provides many potential benefits such as easier index maintenance, data loads and archiving using partition switching and improved query performance through partition elimination.. In this session we’ll cover the basics of partitioning - from getting started with partition switching to partition elimination to make your queries go faster - with plenty of demos for you to take away.

Speaker(s):

Martin Cairney

Track and Room: Database Administration Deployment - DataCore

Title: Introduction to DAX

Abstract: What is DAX all about? Come to this session to learn about Calculated Column, Measure, and Calculated Tables and their differences. You will learn about the basics of language. You will learn about Filter functions, table functions, and iterators. You will learn about what is the difference between SUM and SUMX and many other scenarios.

Speaker(s):

Reza Rad

Track and Room: Advanced Analytics and Information Delivery - Unisys

Title: SQL Server on Linux? Yes, Linux!

Abstract: With SQL Server almost available on Linux, seasonal SQL Server DBAs, who spent most of their work on Windows, should hone their skills on Linux.

The session will explore the essential skills needed to manage SQL server on Linux. It will also explore the most common tasks and procedures DBAs commit on Windows and their equivalents on Linux. Some troubleshooting skills on Linux will be explored, as well

Speaker(s):

Mohamed Mawla

Track and Room: Database Administration Deployment - DataCore

Title: Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub

Abstract: This session will focusing on providing a SQL/BI developer with a walkthrough developing apps for Windows 10 IoT core running on a Raspberry Pi and using this to collect data and send data to Azure IoT hub. Some of the aspects that will be looked at is development environment , Windows 10 IoT core running on a Raspberry Pi , Azure IoT the challenges faced, from getting started to getting an app running that sends data to IoT hub and visualizing this data in Power BI.

Speaker(s):

Arohan Naidoo

Track and Room: BI Platform Architecture, Development Administration - Room 4

Title: Networking with Women

Abstract: Opportunity for the Women attending the Wellington SQLSaturday event to get to know each other and get connected. Come and say Hi and let us get to know each other.

Speaker(s):

Anupama Natarajan

Track and Room: Women in Technology - Microsoft

Title: Growing your career as a woman in STEM

Abstract: Imposter Syndrome, career stops and starts, toxic workplaces - there are many reasons why women leave technology careers. This lightening talk aims to provide some thoughts on how to overcome the barriers and get the career you deserve.

Speaker(s):

Michelle Burke

Track and Room: Women in Technology - Microsoft

Title: What SQL Server DBAs Need To Know About Distributed Availability

Abstract: With the introduction of Distributed Availability Groups in SQL Server 2016, it is becoming even more confusing to decide on the appropriate high availability and disaster recovery architecture to implement. In this session, we will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario and how you can combine them with the other high availability and disaster recovery features to meet your database recovery objectives and service level agreements.

Speaker(s):

Edwin M Sarmiento

Track and Room: Database Administration Deployment - TradeMe

Title: Migrating SQL Server to AWS Cloud

Abstract: Tips and tricks for using the Amazon Web Services’ Database Migration Service to painlessly migrate a SQL Server database to cloud computing.

Speaker(s):

Steven Ensslen

Track and Room: Database Administration Deployment - TradeMe

Title: Power BI Report Server Demystified

Abstract: Power BI Report Server is a solution that you deploy on your own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways. This session will cover

• Tips on getting your Power BI Report Server installed • Create a power BI report • Publish the report on the Power BI Report Server

Speaker(s):

Indira Bandari

Track and Room: Advanced Analytics and Information Delivery - Unisys

Title: Azure Analysis Services rocks!

Abstract: Azure Analysis Services has been in the cloud for a few months and it rocks!

This session will cover fundamentals of using Azure Analysis Services. I will go through the new capabilities of the service and compare it with the SQL Server Analysis Services on-premises.

I will also explain why we should take it into account for our solutions and how to build models in the new service.

Speaker(s):

David Alzamendi

Track and Room: BI Platform Architecture, Development Administration - TradeMe

Title: MDX Cubes and Azure

Abstract: MDX Cubes are they still there in the Azure World? Come and learn

Speaker(s):

Phillip Seamark

Track and Room: Advanced Analytics and Information Delivery - Unisys

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Arohan Naidoo

Arohan is a Business Intelligence developer working at Entelect primarily on the Microsoft BI stack who has an interest in using Big Data and IoT to find insights into ways to improve daily life as well as focused research on using technology to enhance learning.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

Leila Etaati

Twitter: - @leila_etaati

LinkedIn: Leila Etaati

Contact: http://blog.radacad.com

Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQLSaturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQLSaturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.

Dave Dustin

Twitter: - venzann

With more than 35 years industry experience, Dave has worked with organisations and data systems of all sizes. He is currently Principal Engineer at Xero.

Phillip Seamark

Twitter: - PhilSeamark

LinkedIn: Phillip Seamark

An accomplished database and business intelligence (BI) professional with an in-depth knowledge of the Microsoft BI stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling.

Expert knowledge in all facets of BI/DW including planning architecture, project management, dimensional modelling, performance tuning, ETL design, development and optimization, report and dashboard design as well as installation and administration. Author of multiple books on DAX.

Over 27 years of commercial experience in delivering business applications across a broad range of technologies.

Edwin M Sarmiento

Twitter: - EdwinMSarmiento

LinkedIn: Edwin M Sarmiento

Contact: http://www.EdwinMSarmiento.com

Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

Anupama Natarajan

Twitter: - @shantha05

LinkedIn: Anupama Natarajan

Contact: http://www.anupamanatarajan.com

Anu Natarajan is a Data and AI Consultant with 15+ years of experience working in design and development of Data Warehouse, Business Intelligence, AI enabled applications, and SaaS integrated solutions. Anu is a Microsoft MVP Data Platform, Microsoft Certified Trainer and passionate in sharing knowledge. She loves solving complex business problems with innovative solutions using technologies. Anu also speaks at conferences including PASS Summit, SQLSaturdays, Data Platform Summit, Difinity, and she organizes local user group meetups.

Brian Bradley

LinkedIn: Brian Bradley

Brian Bradley is a Business Intelligence Specialist who has solid experience in all things Data. Hailing from South Africa, Brian now calls New Zealand home. He has had a long and extensive career working for many top organisations such as Optimal BI, Xero and Fujitsu. On this journey he has paved his way as a Data Warehouse and Business Intelligence Solution Architect, specialising in Data Vault Architecture, Design, Build and Modelling. In his spare time he is a Blockchain enthusiast and keeps abreast of all the new and improving developments in the market, strengthening and building on business focus and the Microsoft BI Stack. He is a “Certifed Data Vault Modeller” as well as being certified to conduct the CDVDM Certifcation.

Patrick Flynn

Twitter: - sqllensman

Contact: http://sqllensman.com/blog/

Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.

Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge

Emma Vitz

Twitter: - https://twitter.com/EmmaVitz

Emma has recently graduated from Victoria University with a degree in Statistics and Psychology. She is working as an Actuarial Analyst in for a consulting firm in Auckland, and also has a strong passion for data science and the new approaches it allows us to take to solve complex problems.

Anupama Natarajan

Twitter: - @shantha05

LinkedIn: Anupama Natarajan

Contact: http://www.anupamanatarajan.com

Ram Katepally

LinkedIn: Ram Katepally

Contact: http://katepally.com/

Ram Katepally is an experienced Data Analytics Consultant who worked on multiple BI projects in varied set of business domains.

He is MCSE in both Data Platform Data Analytics verticals, with a passion for analytics and visualizations. In his free time he is a avid player of chess.

Reza Rad

Twitter: - Rad_Reza

LinkedIn: Reza Rad

Contact: http://radacad.com/blog

Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.

Pinal Dave

Twitter: - pinaldave

LinkedIn: Pinal Dave

Contact: https://blog.sqlauthority.com

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Martin Catherall

Twitter: - MartyCatherall

LinkedIn: Martin Catherall

Contact: http://martincatherall.com

Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region. Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.

Warwick Rudd

Twitter: - @warwick_Rudd

LinkedIn: Warwick Rudd

Contact: http://www.sqlmastersconsulting.com.au/Blog

Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.

Michelle Burke

Twitter: - smrtgirl

Contact: https://smrtgirl.nz

Michelle has been working in data and SQL Server for longer than she’d care to admit. One of her current favourite datasets is her Untappd check-ins (if you’re going to invest so much in craft beer, you might as well mine the data, right?). She is passionate about data quality, data security, solving business problems, and building welcoming and diverse teams.

Julie Woolner

Julie is a Database Solutions Architect for Xero, building on many years’ experience as a DBA on SQL Server and other (not to be mentioned here) vendors’ offerings. Having seen much poor use of database technology in her time, her passion is to see it done right more often!

Her current focus is on Data Governance and associated issues.

Dharmendra Keshari

LinkedIn: Dharmendra Keshari

Contact: http://dharmendrakeshari.com/

Dharmendra Keshari has strong and in-depth experience in Database Management. Currently, working as Senior Database Administrator at Micron Technology in Singapore and handling one of the most critical databases which are being used by Singapore Public Hospitals, national specialty centres and polyclinics. Dharmendra is an avid, regular mentor on social media, helping several enthusiast in solving their problems related to Database management. he is co-leader and regular speaker at Singapore SQL Server Pass Chapter (User Group). He has done certification for “Microsoft SQL Server#174; 2008, Implementation” and “Maintenance amp; Administering Microsoft SQL Server 2012 Database”.

Indira Bandari

Twitter: - indirabandari

LinkedIn: Indira Bandari

Contact: http://mytechlearning.blogspot.co.nz/

Indira is a Microsoft Data Platform MVP in New Zealand. She has a Masters degree in Statistics and is passionate about data, analytics and Artificial Intelligence. She is a BI and SQL Lead, an international speaker, mentor and part time trainer with over 15 years of experience in designing and developing data warehouses and analytical solutions.
Volunteering and sharing her knowledge is her passion. In her pass time, she runs free game development classes, database concepts and data visualization classes for 9-16 year old kids. She is a Co-organiser for Data, Insights and Power BI User Group , Auckland AI Meetup Group and SQLSaturday Auckland. She speaks at various conferences, Virtual Webinars, PASS events etc

Victor Isakov

Twitter: - @victorisakov

LinkedIn: Victor Isakov

Contact: http://www.victorisakov.com

Victor Isakov (MCA, MCM, MCSM, MCT, MVP) is a Database Architect and trainer who provides consulting and training services to various organizations in the public, private, and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd/Ignite, PASS Summit, IT/Dev Connections, and SQLSaturdays. Victor has written a number of books on SQL Server and has worked with Microsoft to develop the SQL Server exams and certification. In 2017 he authored “Exam Ref 70-764 Administering a SQL Database Infrastructure (1st Edition)”. He is one of only three non-Microsoft, Microsoft Certified Architects in the world.

Steven Ensslen

Twitter: - @StevenEnsslen

LinkedIn: Steven Ensslen

Contact: http://stevenensslen.com

I’m a leader in business intelligence. I work to replace ignorance with knowledge by reducing uncertainty. I gather information that answers important questions and I help to define the questions that need answering.

Along the way I use analytical software and databases. I automate scrupulously. And I build teams by teaching my peers to do these things too.

Hamish Watson

Twitter: - theHybridDBA

LinkedIn: Hamish Watson

Contact: http://www.sqlservercentral.com/blogs/the-hybrid-dbas-blog/

Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies.

He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies.

He has been managing SQL Server since SQL Server 2000, and pragmatic approaches to delivering business value to clients is his career passion.

Educating and helping others learn is a driver for Hamish. He is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.

Edwin M Sarmiento

Twitter: - EdwinMSarmiento

LinkedIn: Edwin M Sarmiento

Contact: http://www.EdwinMSarmiento.com

Phillip Seamark

Twitter: - PhilSeamark

LinkedIn: Phillip Seamark

Over 27 years of commercial experience in delivering business applications across a broad range of technologies.

Erland Sommarskog

Contact: http://www.sommarskog.se

Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

Martin Cairney

Twitter: - martin_cairney

LinkedIn: Martin Cairney

Martin has 20 years’ experience in SQL Server technologies. His experience spans both the Database Engine and infrastructure requirements, and Data Warehousing and BI implementations. He has worked across many industry sectors including London’s global financial institutions and both State and Federal Government Departments. He is a SQL Server MVP, MCT and an experienced conference presenter, having presented at PASS Summit, SQLBits, and SQLSaturday events and User Groups round the world

Reza Rad

Twitter: - Rad_Reza

LinkedIn: Reza Rad

Contact: http://radacad.com/blog

David Alzamendi

Twitter: - techtalkcorner

LinkedIn: David Alzamendi

Contact: https://www.techtalkcorner.com

Delivering Business Intelligence and Data Analytics Solutions with On-Premises and Cloud technologies since 2011, David Alzamendi is a Microsoft Certified Solutions Expert and event speaker who solves problems with best practice procedures and the latest technology.

David is passionate about the positive impact data can have on our lives, businesses, economy and the environment. He prides himself on using his creativity and optimism to solve what others thought impossible.

Mohamed Mawla

Trilingual Principal Consultant amp; Team Tech lead at a global Tech Consulting Mohamed had worked with large SQL server environments such as financials and gov of hundreds of SQL server instances and enormous amounts of data. His favorite subjects are Cloud Analytics, performance tuning, High Availability, especially Replication and Disaster recovery. Certified Google Cloud and Azure Data Engineer.

When not working, Mohamed carries his cameras and takes a trip somewhere.

Simon Carryer

Simon Carryer is a Data Scientist at Xero, in Wellington. He works with a team of Data Engineers to “bring the magic” to small business accounting - helping the application learn about your accounting so you can spend less time entering data, and more time getting insights about your business.

Simon’s focus is on fostering a culture of data-driven decision making, and building data products that deliver real value to customers.

SQLSaturday #706 - Wellington 2018

Sessions

Title: Troubleshooting Issues with Extended Events in real time

Title: DBATools! The reason to finally start learning and using Powershell

Title: DevOPs and the DBA

Title: Flex your data muscles from DBA Workbench

Title: Kick Start! SQL Server 2016/2017 Performance Tips and Tricks

Title: When Things go Wrong - Error Handling in SQL Server

Title: A Beginners Guide to HA/DR

Title: Data Privacy and the Data Professional.

Title: SQL Server 2017 with Python R: On-premises Machine Learning

Title: Ultimate Security and Sharing in Power BI

Title: Real-Time Data Processing - How do I choose the Right Solution

Title: GDPR - What is it? Why should I care?

Title: Using SQL as the basis for analysis in Python - Walking through an example on Kiwisaver in NZ

Title: The Smart Way to Troubleshoot SQL Server Always On Cluster and Av

Title: What do you mean there are no maintenance Windows?

Title: Introduction to Data Vault

Title: Machine Learning Services in SQL Server, Featuring Dinosaurs!

Title: Hidden “Gems” in SQL Server 2017

Title: Advanced DAX for the SQL Professional

Title: Azure Machine Learning and its real world use cases

Title: Split, Merge and Eliminate - An Introduction to Partitioning

Title: Introduction to DAX

Title: SQL Server on Linux? Yes, Linux!

Title: Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub

Title: Networking with Women

Title: Growing your career as a woman in STEM

Title: What SQL Server DBAs Need To Know About Distributed Availability

Title: Migrating SQL Server to AWS Cloud

Title: Power BI Report Server Demystified

Title: Azure Analysis Services rocks!

Title: MDX Cubes and Azure

Speakers

Sponsors