SQLSaturday #571 - Auckland 2016

Event Date: 10/15/2016 00:00:00

Event Location:

  • Microsoft Auckland
  • 5/22 Viaduct Harbour Ave, Auckland CBD, 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).


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

Title: Protecting your data from SQL Injection attacks

Abstract: Kevin will be talking on the topic of SQL injection - something that all of us need to be aware of and protect against.

And here is a blurb from:


” The best way to find out if an application is vulnerable to injection is to verify that all use of interpreters clearly separates untrusted data from the command or query. For SQL calls, this means using bind variables in all prepared statements and stored procedures, and avoiding dynamic queries. Checking the code is a fast and accurate way to see if the application uses interpreters safely. Code analysis tools can help a security analyst find the use of interpreters and trace the data flow through the application. Penetration testers can validate these issues by crafting exploits that confirm the vulnerability.”

Kevin will give us a demo that will show an injection attack in action and how to mitigate it.


  • Kevin Alcock

Track and Room: Database Administration - Ponui

Title: R; One Ring to Rule Them All

Abstract: R is one of the most popular and powerful analytics languages. That helps data scientists to prepare data, predict data, and visualize it. Microsoft offers several deployment options to bring next-generation advanced analytics to your business. Microsoft R Server delivers R-based analytics to where your data lives. Processing analytics in-place eliminates data movement, reducing latencies and operational costs.

In this session, first basic concepts of machine learning will be discussed. Then, a demo of how to use R for data cleaning, visualization, and prediction will be presented. Subsequently, an introduction to use R server and R in SQL Server 2016 will be shown. Finally, a brief introduction on how to use Azure ML with R will be shown.


  • Leila Etaati

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

Title: Security in Power BI

Abstract: Come to this session to learn how to leverage security in Power BI. Share Power BI report with colleagues, or publish it to web, or through an office 365 group. You will also see how to implement Row level security on different data sources either through Power BI security itself, or applying security in the data source level of SSAS Tabular or SQL Server. This is demo heavy session all about Security in Power BI


  • Reza Rad

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

Title: Are You High? Can You Recover? - HA and DR in SQL Server.

Abstract: A look at the options for providing High Availability and Disaster Recovery using the native features available in SQL Server. This session will cover the basis of how the technologies work, what is(and isn’t) protected and a list of the advantages and disadvantages of each technology. We’ll also look at the why of High Availability, Disaster recovery and how to get the business to commit to a design to provide Business Continuity when disaster strikes.


  • Rob Douglas

Track and Room: Database Administration - Ponui

Title: Introduction to the Query Store

Abstract: Query store is an awesome new feature in SQL Server 2016 and Azure SQL Database that allows you to store the history of query plans (what SQL Server turns your SQL statement into), including detailed data on performance, making comparison with previous versions of a statement easy.

The Query Store also lets you identify queries that may degrade performance over time and make necessary adjustments. I#39;ll show how easy it is to work with the Query Store and work with query plans.


  • Dave Dustin

Track and Room: Database Development - MPC

Title: Restoring SQL Server Database to Old Version

Abstract: In this session , I will demonstrating the approach for restoring SQL Server Database to older version( like restoring SQL server 2014 database to SQL Server 2012) using Microsoft azure cloud migration tool.


  • kokila kondasamy

Track and Room: Database Development - Ponui

Title: Adding Power to the DBA toolkit!

Abstract: Interested in being able to manage, monitor and document your SQL Environment from a single location? Want to be able to produce modern interactive reports and dashboards that can be viewed on both desktop and mobile devices?

By adding a little “Power” to your DBA toolkit you can!

By combining PowerShell and PowerBi with the more traditional DBA tools I will show how to query and document your entire environment and produce rich interactive reports that can be consumed by all levels of your organisation.


  • Patrick Flynn

Track and Room: Database Administration - MPC

Title: DW SuperHero-Columnstore Index

Abstract: Columnstore indexes were introduced in SQL 2012. They have the superpower to boost SQL server performance by flipping row based indexing to column based indexing. In this session, we will cover basics of this technology, its usability, performance impact, implementation (through demo), access mechanism and what’s new in SQL 2016.


  • Manjot Kaur

Track and Room: Database Development - MPC

Title: Data Visualization: How to truly tell a great story!

Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…


  • Jonathan Stewart

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

Title: Temporal Databases in Microsoft SQL server 2016

Abstract: Introducing Temporal Databases in SQL Server 2016

More and more organizations are storing archives of data to help them make important business decisions. Traditionally, organizations had to rely on expensive, and tedious methods to go back in time and make sense of growth, negative growth, profit, loss, etc.

Microsoft SQL Server 2016 introduces a new feature called Temporal Databases which essentially solves all the problems mentioned above.

This presentation aims to go deep into Temporal Databases (requirements, use cases, technical know-hows) and present some demo’s in order to gain specific understanding on this new feature which is being called “Time Travel”.


  • Amit Arora

Track and Room: Database Development - MPC

Title: Package Management in Microsoft R Open with Checkpoint

Abstract: Package Management in Microsoft R Open with Checkpoint


  • Andrew Worsley

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


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

Jonathan Stewart

Twitter: - sqllocks

LinkedIn: Jonathan Stewart

Contact: https://sqllocks.net/

Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.

Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on

Andrew Worsley

Twitter: - @aworsleynz

LinkedIn: Andrew Worsley

Data scientist passionate about discovering new and inventive ways of gleaning valuable insights from large data sources.

Interests include spatial statistics, data mining, machine learning, dimensionality reduction and statistical programming.

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

Manjot Kaur

I have been working with SQL server for over 10 years. I have been an internal DBA and a consultant. I am passionate about automation, cloud technologies, performance tuning and learning SQL internals. In my free time I love to read, playing with my toddler and trying my hands on new recipes.

Kevin Alcock

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

LinkedIn: Kevin Alcock

Contact: https://kevin.net.nz

Kevin Alcock Director and Principal Consultant from Katipo Information Security. Kevin has been “Programming for a living since 1986”, including using SQL Server off and on since version 1.1. He has worked in a variety of roles over that time and these days has taken up the mantra of making data safe.

Amit Arora

LinkedIn: Amit Arora

Amit Arora is an SQL Server Consultant with WARDY IT Solutions. Amit has over 10 years of experience working with SQL Server including working as a Technical Advisor and DBA for Microsoft. Amit has recently been working on SQL Server solutions with Microsoft Azure and HDInsight as well as other big data technologies.

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.

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.

kokila kondasamy

LinkedIn: kokila kondasamy

Working as Database Consultant part of SQL Services Professional Services team, providing SQL Server support to a variety of customer across New Zealand and Australia. Apart from SQL Server, Kokila is passionate about Cloud , NoSQL and BigData Technologies.

Rob Douglas

Twitter: - Rob_DouglasNZ

LinkedIn: Rob Douglas

Contact: http://www.gumption.co.nz

Robs SQL history started as a remote DBA, branched into consultancy and now includes providing SQL Solutions to a variety of businesses, government departments and banks throughout Australia and New Zealand using a variety of native SQL solutions to meet their performance, higher availability and Disaster Recovery needs.

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.


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

Back to the SQLSaturday Event List

Back to the home page