SQLSaturday #456 - Auckland 2015

Event Date: 10/03/2015 00:00:00

Event Location:

  • Auckland University of Technology
  • AUT International House Auckland, Wakefield St, Auckland
  • Auckland, Auckland, New Zealand

PDF of Schedule

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

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: Being Smarter with Azure Machine Learning

Abstract: Machine Learning is a subfield of computer science which is so pervasive today that you probably use it dozens of times a day without knowing it. Azure Machine Learning is a valuable tool that can be employed by data scientists with different skill levels. Azure ML also supports R and Python custom code, which can be dropped directly into your workspace. In this session, I will show a demo of using Azure ML with R. Audience will learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, choose the right algorithm, and then finally to the integration of predictive insights.

Speaker(s):

  • Leila Etaati

Track and Room: SQLSaturday Main Track - SQLSat Room


Title: Power BI; Amazing Things You Can Do

Abstract: Power Query, Power View, and Power Pivot has been in the BI market for a while. Microsoft combined these three products into a single product and service with a new designer called Power BI Desktop (Power BI Designer). Power BI gathered features of these three products all in one, so building dashboards and effective visualization items with this tool is much easier nowadays. In this session you will learn all new and great features of Power BI. You will learn how to work with different data source, and apply Power Query transformation on them. You will learn tricks and tips of modelling with Power BI Desktop, and then how to visualize effectively with this tool. You will also learn how to build dashboards on Power BI website. At the end of this session you will be able to use Power BI for your everyday data analysis as well as organizational data mash up and visualization. So expect lots of demos in this session.

Speaker(s):

  • Reza Rad

Track and Room: SQLSaturday Main Track - SQLSat Room


Title: SQL Developer Tips and Tricks

Abstract: Martin has seen life from a few different sides of the database environment. Often the world of TSQL and DBA are seen from vastly different viewpoints – but it doesn’t have to be this way. Join Martin to find out some ways that these two groups can enhance each other’s life and work as efficiently as possible. We’ll examine a range of tip during this presentation that most SQL professionals should get value from.

Speaker(s):

  • Martin Catherall

Track and Room: SQLSaturday Main Track - SQLSat Room


Title: Myths and misconceptions

Abstract: There are a great many theories, anti-patterns and just plain wrong ideas that people (mostly Devs, but including DBAs) believe about SQL Server. Yes, it’s enterprise ready. No, it doesn’t magically tune/tweak itself (it needs some lovin’ from time to time (just nowhere near as much as Oracle)). We’re going to look into debunking some of these falsehoods.

Speaker(s):

  • Dave Dustin

Track and Room: SQLSaturday Main Track - SQLSat Room


Title: Deep dive into Running SQL Platform on Azure IAAS

Abstract: In this deep dive session, we dig in on SQL Server VM troubleshooting, best practices and configurations across multiple scenarios.In this demo packed session learn about Performance Tuning, end to end High Availability and Disaster Recovery and look at some of the Hybrid Scenarios and Features.

Speaker(s):

  • Aben Samuel

Track and Room: SQLSaturday Main Track - 2


Title: Mission Critical SQL Server and You

Abstract: Mission Critical systems require High Availability, High Performance High Security of the data, which is the most important part of your company. Could you survive if your environment did not have these?

In this session I will look at the options available to you to meet your High Availability, High Performance High Security requirements using some of the new and enhanced features being released in SQL Server 2016 to build better mission critical environments.

Speaker(s):

  • Warwick Rudd

Track and Room: SQLSaturday Main Track - SQLSat Room


Speakers

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

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.

Aben Samuel

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

LinkedIn: Aben Samuel

Contact: http://wellytonian.com

Established track record with over 9 years of experience in helping organizations to efficiently use their networks; ensuring that the design of an organization#39;s IT infrastructure allows all of the components, including computers, the network, and software, to fit together and work properly.

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.

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.

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.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page